|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
DataTable dt = new
DataTable();
dt.Columns.Add("UserName", typeof(string));
dt.Columns.Add("Age", typeof(int));
dt.Rows.Add("zzq1", 19);
dt.Rows.Add("zzq2", 20);
using
(System.Data.SqlClient.SqlBulkCopy bcp = new
System.Data.SqlClient.SqlBulkCopy("Data Source=.;Initial Catalog=Test;Integrated Security=True"))
{
//指定目标数据库的表名
bcp.DestinationTableName = "UserInfo";
//建立数据源表字段和目标表中的列之间的映射
bcp.ColumnMappings.Add("UserName", "UserName");
bcp.ColumnMappings.Add("Age", "Age");
//写入数据库表 dt 是数据源DataTable
bcp.WriteToServer(dt);
//关闭SqlBulkCopy实例
bcp.Close();
}
//using (SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=Test;Integrated Security=True"))
//{
// string sql = "Delete [Test].[dbo].[UserInfo]";
// using (SqlCommand com = new SqlCommand(sql, conn))
// {
// conn.Open();
// object obj = com.ExecuteScalar();
// }
//}
|