请帮我解决下吧~都好几天了。。还是不能解决啊

xu56180825 2009-09-13 05:13:13

public partial class AddInfo : UserControl
{
//public DataTable DTable;
//public OleDbDataAdapter ad;
//private SqlConnection Connection;
//private SqlDataAdapter DataAdapter;
//private SqlCommandBuilder Builder;
private DataSet Ds;
private OleDbConnection Connection;
private OleDbDataAdapter DataAdapter;
private OleDbCommandBuilder Builder;
public AddInfo()
{
InitializeComponent();
this.BackColor = Color.White;
//Connection = new SqlConnection(MyDepot.Properties.Settings.Default.MydeConnectionString);
Connection = new OleDbConnection(MyDepot.Properties.Settings.Default.MydeportConnectionString);
Connection.Open();
//MessageBox.Show(MyDepot.Properties.Settings.Default.MydeConnectionString);
//DataAdapter = new SqlDataAdapter("select * from [DEPORT]", Connection);
DataAdapter = new OleDbDataAdapter("select * from [DEPORT]", Connection);
DataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
//Builder = new SqlCommandBuilder(DataAdapter);
Builder = new OleDbCommandBuilder(DataAdapter);
Builder.QuotePrefix = "[";
Builder.QuoteSuffix = "]";
Ds = new DataSet();
DataAdapter.Fill(Ds, "DEPORT");
this.dataGridView1.DataSource = Ds.Tables[0];
Connection.Close();

}

private void AddInfo_Load(object sender, EventArgs e)
{
}
// public DataTable ShowTable
//{
//get { return DTable; }
//set
// {
// DTable=value;
// }
// }

private void button1_Click(object sender, EventArgs e)
{
DataRow dr = Ds.Tables[0].NewRow();
dr[0] = mytextBox1.TextBoxString;
dr[1] = mytextBox2.TextBoxString;
dr[2] = mytextBox3.TextBoxString;
dr[3] = mytextBox4.TextBoxString;
dr[4] = mytextBox5.TextBoxString;
dr[5] = mytextBox6.TextBoxString;
dr[6] = mytextBox7.TextBoxString;
dr[7] = mytextBox8.TextBoxString;
dr[8] = mytextBox9.TextBoxString;
Ds.Tables[0].Rows.Add(dr);
Ds.Tables[0].AcceptChanges();

}

private void button2_Click(object sender, EventArgs e)
{
DataAdapter.Update(Ds.Tables["DEPORT"]);
//OleDbConnection Connection = new OleDbConnection(MyDepot.Properties.Settings.Default.MydeportConnectionString);
// Connection.Open();
// SqlCommand cmd = new SqlCommand("delete from DEPORT WHERE [DE-ID]='2'",Connection);
//cmd.ExecuteNonQuery();
// Connection.Close();
}
}
我把dataGridView等都放在一个用户控件里，mytextBox是自己重新绘制的TEXTBOX，TextBoxString是个属性
public string TextBoxString
{
get { return textBox1.Text.Trim(); }
set { textBox1.Text = value; }
}
我分别试了两种数据库ACCESS和SQLEXPRESS但就是不能更新，DataAdapter.Update(Ds.Tables["DEPORT"])执行了也没用数据库的数据不变，ACC我用VS生成数据源可以新增数据，但SQLEXPRESS自动数据源也不能新增，
我编程方面是不是没错啊？？那我哪可能有问题啊？ACCESS数据库老被我搞的字段显示“#错误”。

...全文