如何将DataTable以最快的速度插入到数据库中

2025-03-06 16:18:23
推荐回答(1个)
回答1:

foreach(datarow dr in dt.rows)
{
string dym = dr["电影名"].toString();
......//类似的读取出 datatable里面的行的指定列的值;
Insert(参数);
}
public void Insert(string a,string b,string c,string,d,string e)
{
SqlConnetion sqlconn = new SqlConnection(“连接字符串");
sqlconn.open();
SqlCommand sqlcmd = new SqlCommand(sqlconn,"insert into biao values (a,b,c,d,e)");
sqlcmd.ExecuteNonQuery();
sqlconn.close();
}