SqlConnection conn=new SqlConnection();
conn.ConnectionString=@"server=wy\mmsl;integrated security=SSPI;database=wlgl";
SqlDataAdapter sda=new SqlDataAdapter("select * from admin",conn);
SqlCommandBuilder myCmdBuilder = new SqlCommandBuilder(sda); conn.Open();
DataSet ds=new DataSet();
sda.Fill(ds); DataRow row=ds.Tables[0].NewRow();
row[0]="wy";
row[1]="wy";
ds.Tables[0].Rows.Add(row);
row.AcceptChanges();
sda.Update(ds);这段程序错在那?
conn.ConnectionString=@"server=wy\mmsl;integrated security=SSPI;database=wlgl";
SqlDataAdapter sda=new SqlDataAdapter("select * from admin",conn);
SqlCommandBuilder myCmdBuilder = new SqlCommandBuilder(sda); conn.Open();
DataSet ds=new DataSet();
sda.Fill(ds); DataRow row=ds.Tables[0].NewRow();
row[0]="wy";
row[1]="wy";
ds.Tables[0].Rows.Add(row);
row.AcceptChanges();
sda.Update(ds);这段程序错在那?
这句去掉,否则不会更新
没有测试,从函数名推断的,个人意见。