anything wrong with line 29?

[karenkksh]

Hi,

Server Error in '/WebSite1' Application.
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

Line 27: MyConnection.Open();
Line 28:
Line 29: MyCommand = new SqlCommand("select * from users where user_id='" + Request.QueryString["id"].ToString() + "'", MyConnection);
Line 30: MyAdapter = new SqlDataAdapter(MyCommand);
Line 31: MyDataSet = new DataSet();




Source File: c:\Documents and Settings\karen\My Documents\Visual Studio 2005\WebSites\WebSite1\Admin\UserEdit.aspx.cs Line: 29

Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.]
Admin_UserEdit.Page_Load(Object sender, EventArgs e) in c:\Documents and Settings\karen\My Documents\Visual Studio 2005\WebSites\WebSite1\Admin\UserEdit.aspx.cs:29
System.Web.Util.CalliHelper.EventArgFunctionCaller (IntPtr fp, Object o, Object t, EventArgs e) +13
System.Web.Util.CalliEventHandlerDelegateProxy.Cal lback(Object sender, EventArgs e) +45
System.Web.UI.Control.OnLoad(EventArgs e) +80
System.Web.UI.Control.LoadRecursive() +49
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3745

Plz help. Tq

Karen

[enggwaqas]

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

Line 27: MyConnection.Open();
Line 28:
Line 29: MyCommand = new SqlCommand("select * from users where user_id='" + Request.QueryString["id"].ToString() + "'", MyConnection);
Line 30: MyAdapter = new SqlDataAdapter(MyCommand);
Line 31: MyDataSet = new DataSet();



Karen

Make sure that id exists in your query string i.e.
the url to this page should look some thing like this:
http://..../yourpage.aspx?id=someValue

[saran23]

Hi,

Server Error in '/WebSite1' Application.
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

Line 27: MyConnection.Open();
Line 28:
Line 29: MyCommand = new SqlCommand("select * from users where user_id='" + Request.QueryString["id"].ToString() + "'", MyConnection);
Line 30: MyAdapter = new SqlDataAdapter(MyCommand);
Line 31: MyDataSet = new DataSet();




Source File: c:\Documents and Settings\karen\My Documents\Visual Studio 2005\WebSites\WebSite1\Admin\UserEdit.aspx.cs Line: 29

Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.]
Admin_UserEdit.Page_Load(Object sender, EventArgs e) in c:\Documents and Settings\karen\My Documents\Visual Studio 2005\WebSites\WebSite1\Admin\UserEdit.aspx.cs:29
System.Web.Util.CalliHelper.EventArgFunctionCaller (IntPtr fp, Object o, Object t, EventArgs e) +13
System.Web.Util.CalliEventHandlerDelegateProxy.Cal lback(Object sender, EventArgs e) +45
System.Web.UI.Control.OnLoad(EventArgs e) +80
System.Web.UI.Control.LoadRecursive() +49
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3745

Plz help. Tq

Karen

Hi, Null reference exception Will be raised when any object is null,
So Check for everything in the line of code, The connection string must be initialised correctly, the table name must be correct,
I think there is some problem with the quotation marks used to enclose the value, Check this, Set a breakpoint in the line and check for the values.

Thanks
Saravanan

[Plater]

I would bet money on it coming from:
Request.QueryString["id"].ToString()

You should be verifying that Request.QueryString["id"] actually exists before building a string with it.