how to bind ds to gridview ?

Question

0.00/5 (No votes)

See more:

Hi,
this is a part of my code,

C#

if (Session["MenuItem"] != null)
{
    string s = Session["MenuItem"].ToString();
    int TypeId = getTypeId(Session["MenuItem"].ToString());
    Adapter = new SqlDataAdapter("SELECT Title,Date,Time,AgeId FROM Subjects WHERE CId = '"+TypeId+"'", con);
    Adapter.Fill(ds, "Subjects");
    GridView1.DataSource = ds;
    GridView1.DataMember = "Subjects";
    GridView1.DataBind();
    GridView1.Visible = true;
    Label3.Text = ds.Tables[0].Rows.Count.ToString();
    //DataTable dt = ds.Tables[0];
    //Adapter.Fill(dt);
    //GridView1.DataSource = dt;
    //GridView1.DataBind();

}

and this for grid view

ASP

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False">
    </asp:GridView>

why gridview does not appear in the page ?

Posted 27-Apr-13 1:52am

Salah Abualrob

Add a Solution

Comments

CHill60 28-Apr-13 7:36am

Are you checking for postback when you get to the page - otherwise it will default to it's intial state every time

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)

PrissySC · Answer 1 · 2013-04-27T02:12:00

When I do this ...

command = new sqlcommand
using command
set text, type, connection
end

table = new datatable
adapter = new adapter
adapter.selectcommand = command

adapter.fill(table)

Then ...

grid.datasource = table.defaultview
grid.databind

Dispose of everything.

My question to you is why set the datamember? You filled with this table. Use datamember only if you have multiple sources of data. Then you can set the specific table or collection. Did I miss something in your code? :) I am not found very often in ASP.

Brijesh Kr · Answer 2 · 2013-04-27T02:26:00

First check, your table has data.

You can bind gridview with dataset as, first declare a public dataset like

public dataset ds;

C#

string s = Session["MenuItem"].ToString();
int TypeId = getTypeId(Session["MenuItem"].ToString());
Adapter = new SqlDataAdapter("SELECT Title,Date,Time,AgeId FROM Subjects WHERE CId = '"+TypeId+"'", con);
Adapter.Fill(ds, "Subjects")
  GridView1.DataBind();;

XML

<asp:GridView DataSource='<%#ds>' ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False">
    </asp:GridView>

as you can notice in source i have added DataSource property for gridview

Try this.

Brijesh Kr · Answer 3 · 2013-04-27T02:26:00

First check, your table has data.

You can bind gridview with dataset as, first declare a public dataset like

public dataset ds;

C#

string s = Session["MenuItem"].ToString();
int TypeId = getTypeId(Session["MenuItem"].ToString());
Adapter = new SqlDataAdapter("SELECT Title,Date,Time,AgeId FROM Subjects WHERE CId = '"+TypeId+"'", con);
Adapter.Fill(ds, "Subjects")
  GridView1.DataBind();;

XML

<asp:GridView DataSource='<%#ds>' ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False">
    </asp:GridView>

as you can notice in source i have added DataSource property for gridview

Try this.

Brijesh Kr · Answer 4 · 2013-04-27T02:26:00

First check, your table has data.

You can bind gridview with dataset as, first declare a public dataset like

public dataset ds;

C#

string s = Session["MenuItem"].ToString();
int TypeId = getTypeId(Session["MenuItem"].ToString());
Adapter = new SqlDataAdapter("SELECT Title,Date,Time,AgeId FROM Subjects WHERE CId = '"+TypeId+"'", con);
Adapter.Fill(ds, "Subjects")
  GridView1.DataBind();;

XML

<asp:GridView DataSource='<%#ds>' ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False">
    </asp:GridView>

as you can notice in source i have added DataSource property for gridview

Try this.

how to bind ds to gridview ?

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0