daset更新问题
public void chayi()
{
string s;
SqlConnection sqlc = new SqlConnection(ConfigurationManager.ConnectionStrings["lj"].ConnectionString);//“”中你自己填入连接数据库的字符串
SqlDataAdapter sqlda = new SqlDataAdapter("select * from student where id not in (select id from new_student)", sqlc);
SqlCommandBuilder thisCommandBuilder1 = new SqlCommandBuilder(sqlda);
sqlc.Open();
DataSet ds=new DataSet();
sqlda.Fill(ds);
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
for (int j = 0; j <= ds.Tables[0].Columns.Count - 1; j++)
if (j != 0 && j != 3)
{
s = ds.Tables[0].Rows[i][j].ToString().Trim();
s = jie(s);
ds.Tables[0].Rows[i][j] = s;
}
ds.AcceptChanges();
DataSet ds2 = new DataSet();
SqlDataAdapter sqlda2 = new SqlDataAdapter(" select * from new_student", sqlc);
SqlCommandBuilder thisCommandBuilder = new SqlCommandBuilder(sqlda2);
sqlda2.Fill(ds2);
ds2=ds;
sqlda2.Update(ds2);
sqlc.Close();
}
这样写好像啥也没发生。new_student和student表结构一样,只是后者有数据前者为空表