OleDbDataAdapter.UpDates时出错了
错误信息如下:
更新无法找到 TableMapping[“Table”] 或 DataTable“Table”。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.InvalidOperationException: 更新无法找到 TableMapping[“Table”] 或 DataTable“Table”。
public void RegUser()
{
Conn connstr=new Conn();
OleDbConnection myconn=new OleDbConnection(connstr.UserConn);
OleDbDataAdapter da=new OleDbDataAdapter("SELECT * FROM users",myconn);
DataSet ds=new DataSet();
DataTable dt=new DataTable();
DataRow dr;
OleDbCommandBuilder cb;
myconn.Open();
cb=new OleDbCommandBuilder(da);
da.Fill(ds,"users");
dt=ds.Tables["users"];
dr=dt.NewRow();
dr["username"]=Username;
dr["password"]=Password;
dr["truename"]=Truename;
dr["address"]=Address;
dr["phone"]=Phone;
dr["email"]=Email;
dr["qq"]=Qq;
dr["msn"]=Msn;
dr["homepage"]=Homepage;
dr["friendlist"]=Friendlist;
dr["logincount"]=Logincount;
dr["lastlogintime"]=Lastlogintime;
dr["mp"]=Mp;
dr["money"]=Money;
dr["ison"]=Ison;
dr["job"]=Job;
dr["company"]=Company;
dr["headface"]=Headface;
dr["question"]=Question;
dr["answer"]=Answer;
dr["underwrite"]=Underwrite;
dr["sex"]=Sex;
dr["imgwidth"]=Imgwidth;
dr["imgheight"]=Imgheight;
dr["regtime"]=Regtime;
dr["birthday"]=Birthday;
dt.Rows.Add(dr);//<<-------提示此行出错
da.Update(ds,"users");
dt.Dispose();
ds.Dispose();
da.Dispose();
return;
}