for(int i = 0 ;i<dataTable.Rows.Count;i++) { string id = Convert.ToString( dataTable.Rows[i]["id"]); string name = Convert.ToString( dataTable.Rows[i]["name"]);
//执行insert语句 //insert into table1(id,name) values (id,name) }
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data;namespace ConsoleApplication1 { class Program { static void Main(string[] args) { DataTable table = GetDataTable(); //你的datatable for (int i = 0; i < table.Rows.Count; i++) {
用foreach(datarow item in dt.rows)
for(int i = 0 ;i<dataTable.Rows.Count;i++)
{
string id = Convert.ToString( dataTable.Rows[i]["id"]);
string name = Convert.ToString( dataTable.Rows[i]["name"]);
//执行insert语句
//insert into table1(id,name) values (id,name)
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
DataTable table = GetDataTable(); //你的datatable
for (int i = 0; i < table.Rows.Count; i++)
{
//在这里可以给实体类赋值
//取值方法:table.Rows[i]["列名"];
//然后将实体传给插入方法执行操作
}
}
}
}
System.Data.SqlClient.SqlCommandBuilder cb=new SqlCommandBuilder(da);
DataSet ds=new DataSet();
遍历
DataRow dr=dt.NewRow();Rows.Addda.Update(ds);