datatable插入数据库(转载)

使用sqlcommand.executenonquery()方法插入

foreach (DataRow datarow in datatable.Rows)
{
string sql &＃61; "INSERT INTO [Table_1]

([CompanyName],[CompanyCode],[Address],[Owner],[Memo])" &＃43;
"VALUES(&＃39;" &＃43; datarow["CompanyName"].ToString() &＃43; "&＃39;" &＃43;
",&＃39;" &＃43; datarow["CompanyCode"].ToString() &＃43; "&＃39;" &＃43;
",&＃39;" &＃43; datarow["Address"].ToString() &＃43; "&＃39;" &＃43;
",&＃39;" &＃43; datarow["Owner"].ToString() &＃43; "&＃39;" &＃43;
",&＃39;" &＃43; datarow["Memo"].ToString() &＃43; "&＃39;)";
using (SqlConnection sqlconn &＃61; new SqlConnection(connectionString))
{
      sqlconn.Open();

      SqlCommand sqlcommand &＃61; new SqlCommand(sql, sqlconn);
      sqlcommand.ExecuteNonQuery();
      sqlconn.Close();
}
}

使用sqldataadapter.update(dataset,tablename);

SqlCommand insertcommand &＃61; new SqlCommand("INSERT INTO [Table_1]([CompanyName],[CompanyCode],[Address],[Owner],[Memo])" &＃43;
"VALUES(&＃64;CompanyName, &＃64;CompanyCode,&＃64;Address,&＃64;Owner,&＃64;Memo)",new SqlConnection(connectionString));
insertcommand.Parameters.Add("&＃64;CompanyName", SqlDbType.NChar, 50, "CompanyName");
insertcommand.Parameters.Add("&＃64;CompanyCode", SqlDbType.NChar, 25, "CompanyCode");
insertcommand.Parameters.Add("&＃64;Address", SqlDbType.NChar, 255, "Address");
insertcommand.Parameters.Add("&＃64;Owner", SqlDbType.NChar, 25, "Owner");
insertcommand.Parameters.Add("&＃64;Memo", SqlDbType.NChar, 255, "Memo");
sqldataadapter.InsertCommand &＃61; insertcommand;

sqldataadapter.Update(dataset, "Table_1");

使用sqlbulkcopy.writetoserver(datatable)

SqlBulkCopy sqlbulkcopy &＃61; new SqlBulkCopy(connectionString, SqlBulkCopyOptions.UseInternalTransaction);
sqlbulkcopy.DestinationTableName &＃61; "Table_1";//数据库中的表名

sqlbulkcopy.WriteToServer(dataset.Tables[0]);