How to bind a grid view

Question

0.00/5 (No votes)

See more:

C#

SQL-Server

SQL-Server-2008

, +

Hello

How to bind a grid view.
My code is as follows.
But it is not displaying a grid.

Plz help

C#

protected void Page_Load(object sender, EventArgs e)
        {            
            //string connection="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\aspnet.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True";
            string connection = "Data Source=path;Initial Catalog=commonlogin;User ID=sa;Password=; ";

            SqlConnection conn = new SqlConnection(connection);
            conn.Open();
            SqlCommand com = new SqlCommand("SELECT * FROM tbl_SqlImage", conn);

            SqlDataReader reader = com.ExecuteReader();
            
            GridView1.DataSource = reader;
            GridView1.DataBind();
        }

-------------------------
Plz suggest me correct code

Posted 14-Jun-12 0:10am

Nikil0012

Updated 14-Jun-12 5:38am

Sandeep Mewara

v3

Add a Solution

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

Mits Machhi · Answer 1 · 2012-06-14T00:26:00

Solution 1

try this :

protected void Page_Load(object sender, EventArgs e)
{

//string connection="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\aspnet.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True";
string connection = "Data Source=path;Initial Catalog=commonlogin;User ID=sa;Password=; ";
 

SqlConnection conn = new SqlConnection(connection);
conn.Open();
SqlDataAdapter ad= new SqlDataAdapter("SELECT * FROM tbl_SqlImage", conn);
Dataset ds=new Dataset();
ad.fill(ds);

if(ds.tables[0].rows.count!=0)
{
          Gridview1.Datasource=ds;
          Gridview1.Databind();
}
Hope this will help you or if not Please the Post error which is generated.
Enjoy.

Posted 14-Jun-12 0:26am

Mits Machhi

Comments

Nikil0012 14-Jun-12 6:31am

I get this error: A field or property with the name 'RequestID' was not found on the selected data source.
On Gridview1.datbind();

Plz help

Nikil0012 14-Jun-12 6:35am

It doesn't display the grid view plz help, i have no data in grid view, and when i insert it it gives above error RequestID

[no name] 14-Jun-12 8:25am

What does your grid contain?
I mean are you autogenerating columns or have you specified the columns to be displayed.
Please try AutoGenerateColumns="true" in gridview, this will enable you to check if the gridview is bound properly or not.
Next you can specify the columns you need to display along with the headers.

Hope this helps you out.
happy coding!
Cheers

Dain Ucak · Answer 2 · 2012-06-14T00:29:00

C#

SqlCommand com = new SqlCommand("SELECT * FROM tbl_SqlImage", conn);

 SqlDataAdapter adap = new SqlDataAdapter(com );
            DataTable dt = new DataTable();
            adap.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();

you can see an easy example in this link

C# SqlDataAdapter

shivprasadshetty · Answer 3 · 2012-06-14T19:29:00

What does your grid contain?
I mean are you autogenerating columns or have you specified the columns to be displayed.
You might be trying to get a column that the query is not returning
Please try AutoGenerateColumns="true" in gridview, this will enable you to check if the gridview is bound properly or not.
Next you can specify the columns you need to display along with the headers.

Hope this helps you out.
happy coding!
Cheers

Vipin_Arora · Answer 4 · 2012-06-14T19:41:00

Solution 5

Hi,

Try following videos:

http://www.youtube.com/watch?v=mEHl0Fzsq3w[^]

http://www.youtube.com/watch?v=FwAnjAcUZQs[^]

Happy Coding :)

Posted 14-Jun-12 19:41pm

Vipin_Arora

How to bind a grid view

4 solutions

Solution 1

Solution 2

Solution 4

Solution 5

Add your solution here

Preview 0