conn = new OleDbConnection(Prop.sConStr);
OleDbDataAdapter oda = new OleDbDataAdapter("select id,dept_name from tDept", conn);
DataSet ds = new DataSet();
oda.Fill(ds, "tDept");比如说,这样得到的ds,我想给它添加一行记录,怎么办?
OleDbDataAdapter oda = new OleDbDataAdapter("select id,dept_name from tDept", conn);
DataSet ds = new DataSet();
oda.Fill(ds, "tDept");比如说,这样得到的ds,我想给它添加一行记录,怎么办?
dr["id"] = "obj_001";
dr["dept_name"] = "张三";dt.Rows.Add(dr);
DataRow newRow = ds.Tables[0].NewRow();
//给列赋值
newRow["id"]="";
newRow["dept_name"]="";
ds.Tables[0].Rows.Add(newRow);