请问如何在Dataset中“添加”新的行，而不是覆盖？

Question

drAddItems = DataSet.Tables[""].NewRow();
.
.
.
.
DataSet.Tables[""].Rows.Add(drAddItems);

Answer 1

DataRowCollection rc;
DataRow myNewRow;
rc=DS.Tables["data"].Rows;
object[] rowVals=new object[10];
rowVals[0]=textBox0.Text;
rowVals[1]=textBox1.Text;
rowVals[2]=textBox2.Text;
rowVals[3]=textBox4.Text;
rowVals[4]=textBox5.Text;
rowVals[5]=textBox6.Text;
rowVals[6]=textBox7.Text;
rowVals[7]=textBox8.Text;
rowVals[8]=textBox9.Text;
rowVals[9]=textBox10.Text;
myNewRow=rc.Add(rowVals);
OleDbCommandBuilder CC=new OleDbCommandBuilder(seld1);
seld1.Update(DS,"data");

Answer 2

DataRow r = DataSet.Tables[0].NewRow();
r=...
DataSet.Tables[0].Rows.Add(r);

Answer 3

DataRowCollection rc;
DataRow myNewRow;
rc=DS.Tables["data"].Rows;
object[] rowVals=new object[10];
rowVals[0]=textBox0.Text;
rowVals[1]=textBox1.Text;
rowVals[2]=textBox2.Text;
rowVals[3]=textBox4.Text;
rowVals[4]=textBox5.Text;
rowVals[5]=textBox6.Text;
rowVals[6]=textBox7.Text;
rowVals[7]=textBox8.Text;
rowVals[8]=textBox9.Text;
rowVals[9]=textBox10.Text;
myNewRow=rc.Add(rowVals);
OleDbCommandBuilder CC=new OleDbCommandBuilder(seld1);
seld1.Update(DS,"data");
这个是可以的

Answer 4

你可以使用DataSet.Merge(),但是如果主键相同还是要覆盖，
使用DataTable.Rows.Add()方法。