用到函数
返回一个DATASET对像
public DataSet GetDataList(String str)//返回一个DATASET { OleDbConnection conn=myconntion(); OleDbDataAdapter myadapter = new OleDbDataAdapter(str,conn); DataSet ds=new DataSet(); myadapter.Fill(ds); conn.Close(); return ds; }
更新DATASET
public void updatetb(DataSet ds,string str) { OleDbConnection conn=myconntion(); OleDbDataAdapter myadapter = new OleDbDataAdapter(str,conn); OleDbCommandBuilder custCB = new OleDbCommandBuilder(myadapter); //Response.Write(custCB.GetInsertCommand().CommandText); myadapter.Update(ds); conn.Close(); }
添加记录
DataSet ds=GetDataList("select top 1 * from [article]");//只取出1条,当然也可以不取出
DataRow dr = ds.Tables["table"].NewRow();//增加一个ROW
dr["title"]=title.Value;附值
....................
updatetb(ds,"select top 1 * from [article] ");//更新DATASET
通过增加一个ROW对数据的添加
修改一个记录
DataSet ds=GetDataList("select * from [article] where id="+id+"");//取出一个DATASET
DataRow dr = ds.Tables["table"].Rows[0];//修改值,当然是要修改记录的那个ROW
dr["title"]=title.Value;//附值
........
updatetb(ds,"select * from [article] where id="+id+"");//更新DATASET