Object reference not set to an instance of an object.

Question

4.00/5 (1 vote)

See more:

Hi
I'm getting the above mentioned error when bing the tabel to gridview.

Here is my code:

C#

public void BindLCLGrid()
{
UPLCL.Update();
string SFRID = TXTSRFID.Text;
<pre>var LCL = from C in DB.TB_TransSeaLCLs
               where C.tSLC_NUIsActive == 1 && C.tSLC_tSEA_NUPKId == mobjGenlib.ConvertLon(SFRID)
              select new { tSLC_NUPKId = C.tSLC_NUPKId, tSLC_tSEA_NUPKId = C.tSLC_tSEA_NUPKId, tSLC_VCVolume = C.tSLC_VCVolume, tSLC_mUOM_NUPKId = C.tSLC_mUOM_NUPKId, 	 	  tSLC_VCBuyRate = C.tSLC_VCBuyRate, tSLC_VCSellRate =C.tSLC_VCSellRate };
dgLCL.DataSource = LCL;
dgLCL.DataBind();
}

i'm Getting error iv "var LCL ..............."
Can anyone plesase help me to resolve this :(

Code block corrected

Posted 15-Mar-14 2:24am

Appdev(Icode)

Updated 15-Mar-14 3:56am

Nelek

v2

Add a Solution

5 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)

Abhinav S · Accepted Answer · 2014-03-15T04:32:00

Solution 3

Debug and step through your source code.
You will get to the exact line where one of your objects is null and this error is being thrown.

Posted 15-Mar-14 4:32am

Abhinav S

gggustafson · Accepted Answer · 2014-03-15T11:12:00

Add a try-catch to your code, as in

C#

public void BindLCLGrid()
    {

    try
        {
        UPLCL.Update();
        string SFRID = TXTSRFID.Text;
        var LCL = from C in DB.TB_TransSeaLCLs
                  where C.tSLC_NUIsActive == 1 && 
                        C.tSLC_tSEA_NUPKId == 
                            mobjGenlib.ConvertLon(SFRID)
                  select new { 
                        tSLC_NUPKId      = C.tSLC_NUPKId, 
                        tSLC_tSEA_NUPKId = C.tSLC_tSEA_NUPKId, 
                        tSLC_VCVolume    = C.tSLC_VCVolume, 
                        tSLC_mUOM_NUPKId = C.tSLC_mUOM_NUPKId,
                        tSLC_VCBuyRate   = C.tSLC_VCBuyRate, 
                        tSLC_VCSellRate  = C.tSLC_VCSellRate };
        dgLCL.DataSource = LCL;
        dgLCL.DataBind();
        }
    catch ( Exception ex )
        {
        MessageBox.Show ( ex.Message +
                          Environment.NewLine +
                          ex.StackTrace );
        }
    }

When the exception occurs, the MessageBox will display a large amount of useful information.

Hope that helps.

Mehdi Gholam · Accepted Answer · 2014-03-15T02:30:00

Solution 1

This means one of your variables is null, run the code in the debugger and move your mouse over each variable (a tooltip will appear) to see which one it is and work your way back to fix it.

Posted 15-Mar-14 2:30am

Mehdi Gholam

Comments

[no name] 15-Mar-14 8:33am

I have checked in Database for SFRID(id is - 36) none of the values seems to be null.

Serge Desmedt · Accepted Answer · 2014-03-15T02:35:00

Solution 2

Somewhere in your link expression you have a null value.

My first check would be either the DB or the TB_TranSeaLCLs variables.

Put hem in seperate variables and step through your code in the debugger to check their values.

Posted 15-Mar-14 2:35am

Serge Desmedt

Comments

[no name] 15-Mar-14 8:40am

ok will try

Appdev(Icode) · Accepted Answer · 2014-03-16T20:06:00

hi
i used my code in below way it works fine..
i missed using

using (LQTransSeaFreightDataContext DB = new LQTransSeaFreightDataContext())

once included it works gud..

thanks for all who helped me

C#

public void BindLCLGrid()
       {
           try
           {
               UPLCL.Update();
               string SFRID = TXTSRFID.Text;
               using (LQTransSeaFreightDataContext DB = new LQTransSeaFreightDataContext())
               {
                   var LCL = from C in DB.TB_TransSeaLCLs
                             where C.tSLC_NUIsActive == 1 && C.tSLC_tSEA_NUPKId == mobjGenlib.ConvertInt(SFRID)
                             select new { tSLC_NUPKId = C.tSLC_NUPKId, tSLC_tSEA_NUPKId = C.tSLC_tSEA_NUPKId, tSLC_VCVolume = C.tSLC_VCVolume, tSLC_mUOM_NUPKId = C.tSLC_mUOM_NUPKId, tSLC_VCBuyRate = C.tSLC_VCBuyRate, tSLC_VCSellRate = C.tSLC_VCSellRate };
                   dgLCL.DataSource = LCL;
                   dgLCL.DataBind();
               }
           }
           catch (Exception ex)
           {

           }
       }