关于ACCESS和SQL SERVER 2000在后台代码中添加记录区别的问题
在SQL SERVER 2000中这段代码是正确的
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);
SqlDataAdapter sda = new SqlDataAdapter("select top 0 * from qquser", con);
DataTable dt = new DataTable();
sda.Fill(dt);
DataRow dr = dt.NewRow();
dr["qqname"] = Request.Form["username"];
dr["qqpwd"] = Request.Form["password"];
//dr["isonline"] = 0;
//dr["headpic"] = this.ddlHeadPic.SelectedValue;
//dr["date"] = DateTime.Now;
SqlCommandBuilder cb = new SqlCommandBuilder(sda);
dt.Rows.Add(dr);
sda.Update(dt);
但是在ACCESS中 下列代码却不在编译中出错
OleDbConnection con = new OleDbConnection(ConfigurationManager.AppSettings["conStr"]);
OleDbDataAdapter sda = new OleDbDataAdapter("select top 0 * from qquser", con);
DataTable dt = new DataTable();
sda.Fill(dt);
DataRow dr = dt.NewRow();
dr["qqname"] = Request.Form["username"];
dr["qqpwd"] = Request.Form["password"];
//dr["isonline"] = 0;
//dr["headpic"] = this.ddlHeadPic.SelectedValue;
//dr["date"] = DateTime.Now;
OleDbCommandBuilder cb = new OleDbCommandBuilder(sda);
dt.Rows.Add(dr);
sda.Update(dt);
这是为什么啊,要怎么样才能在ACCESS中以dataadapter.update(dt)形式添加记录?