ASP.NET Update SQL

Question

I have a SQL Server with a roster/information. I would like to update the table with situps, pushups, and Id. I know how to insert information into a table, but having trouble with the Update part of it.

Here is my code:

SqlConnection conns = new SqlConnection(ConfigurationManager.ConnectionStrings["TestDBConnectionString1"].ConnectionString);
SqlCommand cmd = new SqlCommand("UPDATE test SET SitUps = @SitUps, pushUps = @pushUps WHERE (Id = @Id)", conns);
cmd.CommandType = CommandType.Text;

Label sitL = ((Label)FormView2.FindControl("SitUpsLabel"));
Label pushL = ((Label)FormView2.FindControl("pushUpsLabel"));
Label IdL = ((Label)FormView2.FindControl("IdLabel"));

cmd.Parameters.AddWithValue("@SitUps", sitL.Text);
cmd.Parameters.AddWithValue("@pushUps", pushL.Text);
cmd.Parameters.AddWithValue("@Id", IdL.Text);

I'm getting this error

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

I'm pretty sure it's the way I'm treating the Id value. Thanks in advance!!

debug and find out which line is giving the error. It could be that you don't have a "TestDBConnectionString1" connection string configured, or as Waqar said below one of the controls you are attempting to get doesn't exist. — Tobsey
– Tobsey, Commented Aug 30, 2012 at 17:38

Guo Hong Lim · Accepted Answer · 2012-08-30 17:48:02Z

1

Ensure that the 3 id that you stated there, "SitUpsLabel", "pushUpsLabel" and "IdLabel" is the same as what you have on the form view.
I noticed that "IdL" color is odd, try using other variable name instead. You could be using "IdL" for some other purposes.

answered Aug 30, 2012 at 17:48

Guo Hong Lim

1,7203 gold badges13 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

vadim Over a year ago

Thank you sir! that was the issue. I need to start paying attention to what i'm writting :)

Artur Udod · Accepted Answer · 2012-08-30 17:42:17Z

1

The most probable is that FormView2.FindControl returns null, check actual IDs of your controls. How are you sure that exactly this piece of code throws an exception? Seems like you weren't debugging the code (otherwise you would know the exact line and reason), so i advice to do it =)

answered Aug 30, 2012 at 17:42

Artur Udod

4,8011 gold badge35 silver badges59 bronze badges

Comments

Waqar Janjua · Accepted Answer · 2012-08-30 17:34:10Z

0

Before assigning the values to cmd.Parameters first check they are null or not. Example:

if( sitL != null )
{
    cmd.Parameters.AddWithValue("@SitUps", sitL.Text);
}
// In this way add the all parameters.

The error System.NullReferenceException occurs because one of your control was not found and it contains null.

answered Aug 30, 2012 at 17:34

Waqar Janjua

6,1432 gold badges28 silver badges36 bronze badges

Collectives™ on Stack Overflow

ASP.NET Update SQL

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related