怎么在DataSet中对DataTable增加一列,并且提交到Access数据库中(WINFORM)

Question

>>>增加一列????you need to run something like OleDbCommand OleDbCommand1 = new OleDbCommand("ALTER TABLE YourTableName ADD COLUMN NewColumnName INTEGER", conn);conn.Open();
OleDbCommand1.ExecuteNonQuery();
conn.Close();if you mean 增加一行 and assume your datatable has a primary key, tryOleDbDataAdapter da = new OleDbDataAdapter("select * from YourTableName", conn);
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
DataSet DataSet1 = new DataSet();
da.Fill(DataSet1,"YourTableName")DataRow dr = DataSet1.Tables["YourTableName"].NewRow();
dr["col1"] = ...;
dr["col2"] = ...;
...
DataSet1.Tables["YourTableName"].Rows.Add(dr);da.Update(DataSet1,"YourTableName");

Answer 1

和提交到SQL里没有什么区别啊

Answer 2

DataRow myRow=this.dataSet.tables["表名"].NewRow()
myRow["字段1"]="aaa";
myRow["字段2"]="aaa";
myRow["字段3"]="aaa";
this.dataSet.tables["表名"].Rows.Add(myRow);//数据适配器myapmyap.Fill(this.dataSet,"表名");