修改了一下,却出现如下问题
public void Register(MemberDetail User)
{
DBConn myConn=new DBConn();
myConn.OpenConn();
string sql="select * from [user]";
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();
myDataAdapter.SelectCommand = new OleDbCommand(sql, myConn.objConn);
OleDbCommandBuilder custCB = new OleDbCommandBuilder(myDataAdapter);
myDataAdapter.MissingSchemaAction=MissingSchemaAction.Ignore;
DataSet custDS = new DataSet();
custDS=new DataSet("User");
myDataAdapter.Fill(custDS,"User"); //code to modify data in dataset here DataRow row=custDS.Tables["User"].NewRow();
row["Username"]=User.strUsername;
row["Password"]=User.strPassword;
custDS.Tables["User"].Rows.Add(row);
myDataAdapter.Update(custDS,"User");
}
未将对象引用设置到对象的实例。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.NullReferenceException: 未将对象引用设置到对象的实例。源错误:
行 97: //code to modify data in dataset here
行 98:
行 99: DataRow row=custDS.Tables["User"].NewRow();
行 100: row["Username"]=User.strUsername;
行 101: row["Password"]=User.strPassword;
源文件: f:\inetpub\wwwroot\zstudiocn\members\members.cs 行: 99 堆栈跟踪:
[NullReferenceException: 未将对象引用设置到对象的实例。]
Members.MembersDB.Register(MemberDetail User) in f:\inetpub\wwwroot\zstudiocn\members\members.cs:99
Members.Reg.btnSave_Click(Object sender, EventArgs e) in f:\inetpub\wwwroot\zstudiocn\members\reg.aspx.cs:292
System.Web.UI.WebControls.Button.onClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NamevalueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1263
--------------------------------------------------------------------------------
版本信息: Microsoft .NET 框架版本:1.0.3705.0; ASP.NET 版本:1.0.3705.0
public void Register(MemberDetail User)
{
DBConn myConn=new DBConn();
myConn.OpenConn();
string sql="select * from [user]";
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();
myDataAdapter.SelectCommand = new OleDbCommand(sql, myConn.objConn);
OleDbCommandBuilder custCB = new OleDbCommandBuilder(myDataAdapter);
myDataAdapter.MissingSchemaAction=MissingSchemaAction.Ignore;
DataSet custDS = new DataSet();
custDS=new DataSet("User");
myDataAdapter.Fill(custDS,"User"); //code to modify data in dataset here DataRow row=custDS.Tables["User"].NewRow();
row["Username"]=User.strUsername;
row["Password"]=User.strPassword;
custDS.Tables["User"].Rows.Add(row);
myDataAdapter.Update(custDS,"User");
}
未将对象引用设置到对象的实例。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.NullReferenceException: 未将对象引用设置到对象的实例。源错误:
行 97: //code to modify data in dataset here
行 98:
行 99: DataRow row=custDS.Tables["User"].NewRow();
行 100: row["Username"]=User.strUsername;
行 101: row["Password"]=User.strPassword;
源文件: f:\inetpub\wwwroot\zstudiocn\members\members.cs 行: 99 堆栈跟踪:
[NullReferenceException: 未将对象引用设置到对象的实例。]
Members.MembersDB.Register(MemberDetail User) in f:\inetpub\wwwroot\zstudiocn\members\members.cs:99
Members.Reg.btnSave_Click(Object sender, EventArgs e) in f:\inetpub\wwwroot\zstudiocn\members\reg.aspx.cs:292
System.Web.UI.WebControls.Button.onClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NamevalueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1263
--------------------------------------------------------------------------------
版本信息: Microsoft .NET 框架版本:1.0.3705.0; ASP.NET 版本:1.0.3705.0
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货