Object reference not set to an instance of an object.

Question

0.00/5 (No votes)

See more:

Add button code as follows

C#

Sql = "select cpm_pkg_id from CO_PACKAGE_MASTER where cpm_pkg_name = '" + txtpkgdesc.Text.ToString().Trim() + "' ";                        
dt1 = SCon.ReadSql_DT(Sql);

if(dt1.Rows.Count>0)
 {
   Sql ="Insert into CO_PACKAGE_DETAIL values('" + dt1.Rows[0]["cpm_pkg_id"].ToString() + "','" + gvmajormaster.selectedrow(1].tostring.trim() + "','" + gvmajormaster.selectedrows[2].tostring().trim() + "')";

   SCon.ExecSql(Sql);
   lblErr.Text = "Package details inserted successfully";
 }

In gridview as follows

Select   Major Code        Minor Code
         PSTF               AFF

i want to insert the above gridview row values PSTF (Major code) and AFF(Minor Code) into co_package detail.

i treid the below code but shows error as follows
Object reference not set to an instance of an object.

Posted 18-Sep-15 18:35pm

sudhakarthikeyan

Updated 18-Sep-15 19:05pm

Wendelius

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2015-09-18T19:10:00

Based on the code you would encounter the error at least in a situation where you don't have three rows selected in your gridview. In the code

C#

Sql ="Insert into CO_PACKAGE_DETAIL values('" + dt1.Rows[0]["cpm_pkg_id"].ToString() + "','" + gvmajormaster.selectedrow(1].tostring.trim() + "','" + gvmajormaster.selectedrows[2].tostring().trim() + "')";

you refer to indexes 1 and 2. As the indexing starts from 0 these would be the second and the third selected rows. The same potential problem happens if dt1 contains no rows.

Because of this, before doing anything else in the code, check that correct amount of data is selected and present and inform the user if not.

Another note is that you should never concatenate values directly to the SQL statement. Instead, use parameters. Have a look at the examples in SqlParameterCollection.AddWithValue Method[^]

Naveen.Sanagasetti · Answer 2 · 2015-09-20T20:34:00

Solution 2

Hi,

As per error description, if you are trying to assign null value to some object in that scenario you may got this type of error, I request you to please debug your code and check in which line you got this error, and what is the right hand side value of that.

Posted 20-Sep-15 20:34pm

Naveen.Sanagasetti