高考问答航海王启航钻石十连抽:请教DataSet中，怎么增加一条记录？？
来源：百度文库 编辑：高考问答 时间：2024/04/29 23:41:07
如题
string source = "user id=spm;data source=spmdb;password=spm";
string sele = "select * from TEST_DEPT1";
、、、、、、
OracleConnection conn = new OracleConnection(source);
conn.Open();
OracleDataAdapter da = new OracleDataAdapter(sele,conn);
DataSet ds = new DataSet();
da.Fill(ds,"DEPT1");
DataRow row = ds.Tables["DEPT1"].NewRow();
row[0] = Convert.ToInt32(textBox1.Text.Trim());
row[1] = textBox2.Text.Trim();
ds.Tables["DEPT1"].Rows.Add(row);
dataGrid1.SetDataBinding(ds,"DEPT1");
// da.Update(ds,"DEPT1");
conn.Close();