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数据库老被我搞的字段显示“#错误”。