Object reference not set to an instance of an object.

Question

I'm sure I'm just tired and will feel really stupid when I find out the answer, but I have a Web Page that when it tries to set Insert Parameters gives me a NullReferenceException (see subject)

The specific method is :

protected void frmChgRequest_Inserting(object sender, FormViewInsertEventArgs e) {

SqlChgRequest.InsertParameters["ChgID"].DefaultValue = chgIDComplete.ToString();

SqlChgRequest.InsertParameters["RequestDate"].DefaultValue = DateTime.Now.ToString();

}

The error occurs on the first InsertParameters statement. The obvious answer is that the stringbuilder "chgIDComplete" is null, but on debug, it shows a value of "MERCHANT2008115HW". A stringbuilder should have no problem converting to a string. What am I doing wrong?

Anna Hawks · Answer

Thanks for the resource - great article! As a visual learner I appreciate those articles with sample code! I've solved the problem. Don't know how offhand but it's fixed. Thanks for all the input!

John Penn · Answer

This article shows an example of how to use insert parameters with SqlDataSources in C#: http://www.aspfree.com/c/a/ASP.NET/Programmatically-Updating-Databases-using-ASPNET-20-SqlDataSource/2/

John Penn · Answer

Since your StringBuilders aren't null then either SqlChgRequest is null or the InsertParameters collection is either null or doesn't have parameter objects set up within it.

Anna Hawks · Answer

Sorry -- I told you I was tired. SqlChgRequest is my SqlDataSource object.

John Penn · Answer

Where is SqlChgRequest assigned? Make sure that code is called first before this event handler is fired.