改变了DataSet的值之后,我怎么再写回数据库,大家给个方法~~
小弟是这么做的,有些毛病,请大家给点意见,谢谢了
SqlDataAdapter dataAdapter = new SqlDataAdapter("select id,zkzh,kch,zeh from OKTable", Common.PublicClass.GetSqlConnection());//
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet,"OKTable");
Common.Class1.getZKZH(dataSet);//在此随机生成准考证号(DataSet在此更改)
dataAdapter.Update(dataSet,"OKTable");//在此报错了急等侍中........................
小弟是这么做的,有些毛病,请大家给点意见,谢谢了
SqlDataAdapter dataAdapter = new SqlDataAdapter("select id,zkzh,kch,zeh from OKTable", Common.PublicClass.GetSqlConnection());//
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet,"OKTable");
Common.Class1.getZKZH(dataSet);//在此随机生成准考证号(DataSet在此更改)
dataAdapter.Update(dataSet,"OKTable");//在此报错了急等侍中........................
SqlDataAdapter dataAdapter = new SqlDataAdapter("select id,zkzh,kch,zeh from OKTable", Common.PublicClass.GetSqlConnection());//
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet,"OKTable");
Common.Class1.getZKZH(dataSet);//在此随机生成准考证号(DataSet在此更改)
。增加下面语句
SqlCommandBuilder builder = new SqlCommandBuilder(dataAdapter);
dataAdapter.UpdateCommand= builder.GetUpdateCommand();(具体生成什么语言看你要执行的操作 如果是UPDATE 就用GetUpdateCommand)
sqlAdapter.Update(dataSet.Tables["OKTable"])搞定 下会记得多给几分
http://blog.csdn.net/knight94/archive/2006/03/17/627556.aspx
http://blog.csdn.net/knight94/archive/2006/04/15/664530.aspx