grid view connection problem in asp.net

Question

0.00/5 (No votes)

See more:

Hai to All,

In my project i am trying to give data base connection to the grid view it shows the following error: "Object reference is not set to an instance of an object" please healp me .

thank you

Posted 24-Aug-11 20:19pm

rrrer

Updated 24-Aug-11 20:20pm

Uday P.Singh

v2

Add a Solution

Comments

Uday P.Singh 25-Aug-11 2:21am

where is your code? post it, to help you better.

Prerak Patel 25-Aug-11 2:21am

Share some code.

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)

Syed Salman Raza Zaidi · Answer 1 · 2011-08-24T20:27:00

The problem is arising as you are using an object with out making new object(ie with new key word)

Try This or compare it with your code

C#

SqlConnection con=new SqlConnection(//connectionstring);
con.Open();
SqlCommand cmd=new SqlCommand();
DataSet ds=new DataSet();
cmd.CommandText="select * from table";
cmd.Connection=con;
SqlDataAdapter ad=new SqlDataAdapter();
ad.Fill(ds);

Gridview.DataSource=ds.Tables[0];
GridView.Databind();

Dev S · Answer 2 · 2011-08-24T20:29:00

This error occurs beacuse Null Reference. Just debug your code , possibly there is some fault in your code while handling objects.
It generally happens when you try to refernce some object which is Null/Nothing.
Please check whether your connection is properly initialzed or your datareader/dataset is fetching any value from database or not.
Just debug the code properly and the solution is there within it only :)

grid view connection problem in asp.net

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0