如何向access数据库里插入一行?

Question

环境：VS2005 C#下面代码是根据网上代码写的，不成功        /// <summary>
        /// 添加新的一行
        /// </summary>
        /// <param name="table">表名</param>
        /// <param name="key">主键</param>
        /// <param name="ID"></param>
        public static bool AddRow(string table,string key,string ID)
        {
            if (Connected())
            {
                string strCommandText = "select index,tag,name,time,lastname,password,content" + " from " + table;
                OleDbDataAdapter myAdpater = new OleDbDataAdapter(strCommandText, connection);
                OleDbCommandBuilder myBuilder = new OleDbCommandBuilder(myAdpater);
                DataSet myDataset = new DataSet();
                myAdpater.Fill(myDataset, table);
                DataRow newrow = myDataset.Tables[table].NewRow();
                newrow[key] = Convert.ToInt32(ID);
                newrow["tag"] = "";
                newrow["name"] = "";
                newrow["time"] = "";
                newrow["lastname"] = "";
                newrow["password"] = "";
                newrow["content"] = "";
                myDataset.Tables[table].Rows.Add(newrow);
                myAdpater.Update(myDataset, table); //这里出异常!!
                Disconnect();
                return true;
            }
            return false;
        }
请问如何写代码？

Answer 1

    using(OleDbConnection conn = new OleDbConnection(""))
        {
            OleDbDataAdapter coda = new OleDbDataAdapter();
            OleDbCommand comm = new OleDbCommand();
            string sql= "insert into a(a) values('')";
            conn.Open();
            comm = new OleDbCommand(sql, conn);
            comm.ExecuteNonQuery();
            conn.Close();
          }OleDbCommandBuilder   db=   new   OleDbCommandBuilder( _oleDbDataAdapter   ); 
_oleDbDataAdapter.InsertCommand   =   db.GetInsertCommand(); 
_oleDbDataAdapter.Update(ds,   ds.Tables[0].TableName); 
ds.AcceptChanges();

Answer 2

OleDbConnection conn = new OleDbConnection("数据库连接串");
conn.Open();
OleDbCommand comm = new OleDbCommand("Insert语句",conn);
comm.ExecuteNonQuery();
conn.Close():