winform c# DataTable 批量插入数据库

1. ** <summary>
2.     /// 批量插入数据库
3.     /// </summary>
4.     /// <param name="userId"></param>
5.     /// <param name="listNum"></param>
6.     private void InsertUserRights(String userId, String[] listNum)
7.     ...{
9.         DeleteUserRights(userId);
10.         // 新建一个DataTable的实例dt
11.         DataTable dt = new DataTable();
13.         // 声明一个DataRow实例dr
14.         DataRow dr;
16.         // 说明DataTable表里的包含哪些字段
17.         dt.Columns.Add(new DataColumn("UserId", typeof(string)));
18.         dt.Columns.Add(new DataColumn("FunctionId", typeof(Int32))); 
20.         foreach (string listValue in listNum)
21.         ...{
22.             if (listValue.Length != 0)
23.             ...{
24.                 //i = Convert.ToInt16(listValue);
26.                 // 用DataTable的NewRow方法新建一个DataRow对象的实例dr
27.                 dr = dt.NewRow();
28.                 dr[0] = userId;
29.                 dr[1] = listValue;
31.                 dt.Rows.Add(dr);
32.             }
33.         }
35.         SqlConnection conn = DbConn.GetConn();     
36.         
37.         SqlCommand cmd = new SqlCommand("Insert Into userFunction(Userid,FunctionId) values(@UserId,@FunctionId)");
39.         SqlDataAdapter adapt = new SqlDataAdapter("select * from userFunction where 1=0", conn);     
40.         
41.         SqlCommandBuilder sqlCmdBud = new SqlCommandBuilder(adapt);
42.         
43.         SqlParameter UserIdParam = new SqlParameter("@UserId",SqlDbType.VarChar,15);
44.         SqlParameter FunctionIdParam = new SqlParameter("@FunctionId",SqlDbType.Int,4);
45.         
46.         adapt.Fill(dt);
48.         adapt.SelectCommand.Parameters.Add(UserIdParam);
49.         adapt.SelectCommand.Parameters.Add(FunctionIdParam);
51.         adapt.SelectCommand.Parameters["@UserId"].SourceColumn = "UserId";
52.         adapt.SelectCommand.Parameters["@FunctionId"].SourceColumn = "FunctionId";
53.         
54.         adapt.UpdateCommand = sqlCmdBud.GetUpdateCommand();
56.         if (dt != null)
57.         ...{
58.             adapt.Update(dt);
59.         }
61.     }