批量更新数据

1@ Page language="C#" Debug="true" 

1@ Import Namespace="System.Data" 

1@ Import Namespace="System.Data.SqlClient" 

 1<script runat="server">   
 2void Page_Load(object sender, System.EventArgs e){   
 3SqlConnection conn = new SqlConnection("server=localhost;uid=sa;pwd=kingapex;database=tourmsg");   
 4SqlDataAdapter da = new SqlDataAdapter();   
 5SqlCommand cmd = new SqlCommand("select top 2 id,groupnumber as groupnumber1 from [grouptb]",conn);   
 6DataSet ds = new DataSet();   
 7conn.Open();   
 8da.SelectCommand = cmd;   
 9da.Fill(ds,"grouptb"); 
10
11  
12for(int i=0;i<ds.Tables["grouptb"].Rows.Count;i++)   
13{ 
14
15Response.Write(ds.Tables["grouptb"].Rows[1]+"<br>");   
16} 
17
18  
19for(int i=0;i<ds.Tables["grouptb"].Rows.Count;i++)   
20{   
21ds.Tables["grouptb"].Rows.BeginEdit();   
22ds.Tables["grouptb"].Rows[1] = "wangfengrr";   
23ds.Tables["grouptb"].Rows.EndEdit();   
24} 
25
26String updateCmd = "Update grouptb set groupnumber = @groupnumber Where Id=@id "; 
27
28  
29cmd = new SqlCommand(updateCmd, conn);   
30cmd.Parameters.Add("@id",SqlDbType.Int,4,"id");   
31cmd.Parameters.Add("@groupnumber",SqlDbType.Char,10,"groupnumber1"); 
32
33da.UpdateCommand = cmd;   
34da.Update(ds,"grouptb");   
35ds.AcceptChanges(); 
36
37conn.Close();   
38
39
40}   
41</script>

1@ Page language="C#" Debug="true" 

1@ Import Namespace="System.Data" 

1@ Import Namespace="System.Data.SqlClient" 

 1<script runat="server">   
 2void Page_Load(object sender, System.EventArgs e){ 
 3
 4//建立DataTable数据源   
 5DataTable Dt = new DataTable(); 
 6
 7DataRow Dr; 
 8
 9Dt.Columns.Add(new DataColumn("groupnumber")); 
10
11for(int j =0;j<3;j++){ 
12
13Dr=Dt.NewRow(); 
14
15Dr[0]="groupnumber"+j.ToString(); 
16
17Dt.Rows.Add(Dr); 
18
19} 
20
21  
22SqlConnection conn = new SqlConnection("server=localhost;uid=sa;pwd=kingapex;database=tourmsg"); 
23
24  
25SqlDataAdapter MyAdapter = new SqlDataAdapter(); 
26
27//建立InsertCommand   
28StringBuilder sb = new StringBuilder("");   
29sb.Append("INSERT grouptb (groupnumber) VALUES(");   
30sb.Append("@groupnumber)");   
31MyAdapter.InsertCommand = new SqlCommand();   
32MyAdapter.InsertCommand.CommandText = sb.ToString();   
33MyAdapter.InsertCommand.Connection = conn; 
34
35  
36SqlParameter p1 = new SqlParameter("@groupnumber", SqlDbType.VarChar, 40);   
37p1.SourceVersion = DataRowVersion.Current;   
38p1.SourceColumn = "groupnumber"; // or p1.SourceColumn = Dt.Columns[0].ColumnName;   
39MyAdapter.InsertCommand.Parameters.Add(p1); 
40
41//Update   
42MyAdapter.Update(Dt); 
43
44conn.Close();   
45}   
46</script>