这是我的数据库连接方式:
 private string strConnection = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}\\CommFuntion/db1.mdb", Application.StartupPath);
        private OleDbDataAdapter myAdapter;
        private DataSet myds;
        private DataTable mytb;
        private DataSet dss = new DataSet();
        private OleDbConnection _SConn;
         
        //_SConn=new OleDbConnection(strConnection);
         //public OleDbConnection getConn()
         //{
         //    string connstr = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}\\CommFuntion/DebetContrl.mdb", Application.StartupPath);
         //    OleDbConnection tempconn = new OleDbConnection(connstr);
         //    return (tempconn);
         //}
        public OleDbConnection SConn
        {
            get {
                
            return _SConn; 
            }
            set { 
                _SConn = value; }
        }
     public Pfunction()  
        {
         _SConn = new OleDbConnection(strConnection);
         }        #region 打开关闭连接 Open(),Close()
        /// <summary>
        /// 打开数据库连接
        /// </summary>
     public void Open()
     {
         //_SConn = new OleDbConnection(strConnection);
         if (_SConn.State == ConnectionState.Closed)
             _SConn.Open();
     }        /// <summary>
        /// 关闭数据库连接
        /// </summary>
     public void Close()
     {
         if (_SConn.State == ConnectionState.Open)
         {
             _SConn.Close();
             //_SConn.Dispose();
         }
     }然后是我insert代码
 OleDbCommand cmd = new OleDbCommand();
            cmd.Connection = Func.SConn;
            cmd.CommandText = "insert into [Tb_Customerinfo]([CID],[CName]) values('" + textBox1.Text + "','" + textBox2.Text + "')";
            Func.Open();
            cmd.ExecuteNonQuery();
            Func.Close();
麻烦大家帮我看看,到底哪里错了,只能查询不能添加和删除,谢谢,很急,在线等的