string sSqlQuery=string.empty; for(int i=0;i<datatable.rows.count;i++)> { sSqlQuery+="Insert into sample(c1,c2,c3,c4,c5)values( '"+ dataTable.rows[i]["c1"].toString() +"'," '"+ dataTable.rows[i]["c2"].toString() +"'," '"+ dataTable.rows[i]["c3"].toString() +"'," '"+ dataTable.rows[i]["c4"].toString() +"'," '"+ dataTable.rows[i]["c5"].toString() +"');"; } if(!string.IsNullOrEmpty(sSqlQuery)) { //COde to insert the query into database. }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)