string sql="select * from table";
OleDbDataAdapter objAdapter = new OleDbDataAdapter(sql,System.Configuration.ConfigurationSettings.AppSettings["ConnString"]);
DataSet ds = new DataSet();
DataTable MyTable = new DataTable()
objAdapter.Fill(ds,"table");
MyTable=ds.Tables["table"];
Mytable.Columns.Add("ColumnName",????);
OleDbDataAdapter objAdapter = new OleDbDataAdapter(sql,System.Configuration.ConfigurationSettings.AppSettings["ConnString"]);
DataSet ds = new DataSet();
DataTable MyTable = new DataTable()
objAdapter.Fill(ds,"table");
MyTable=ds.Tables["table"];
Mytable.Columns.Add("ColumnName",????);
正解..
DataColumnCollection.Add (String, Type) 创建一个具有指定名称和类型的 DataColumn 对象,并将其添加到 DataColumnCollection 中。
DataColumnCollection.Add (String, Type, String) 创建一个具有指定名称、类型和表达式的 DataColumn 对象,并将其添加到 DataColumnCollection 中。
{
this.sqlDataAdapter1.Fill(ds,"t1");
this.dataGridView1.DataSource = ds;
this.dataGridView1.DataMember = "t1";
} private void button1_Click(object sender, EventArgs e)
{
DataTable dt = ds.Tables[0];
dt.Columns.Add("NewCol");
this.sqlDataAdapter1.Update(ds,"t1");
}
我的物理数据库为什么没有添加一行
dt.Columns.Add("NewCol");
this.sqlDataAdapter1.Update(ds,"t1");
你这是增加一列,哪是增加一行啊?
table.Columns.Add("a",typeof(System.Int32));
不能填充数据后再增加列