Adding Data to a GridView

Question

I'm trying to display some data from a Stored Procedure into my GridView. What I'm doing is onLoad; creating a DataTable, adding two rows to it (debugged and there's definitely data in them) and then;

GridView1.DataSource = DataTable

However my GridView comes back empty every time. Why is this?

and more tags, to your question like asp.net, or android so that your question can be view by many other users — Qadir Hussain
– Qadir Hussain, Commented May 8, 2013 at 4:51

FJT · Accepted Answer · 2012-08-20 15:52:13Z

2

Try

 GridView1.DataBind();

to load the data

answered Aug 20, 2012 at 15:52

FJT

2,0831 gold badge16 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

windowsgm Over a year ago

Oh thought you only needed a DataBind if you wanted the GridView permanently linked to the datatable. That worked in so far as the GridView has two rows now, but no columns and hence no data.

wkl · Accepted Answer · 2017-04-19 14:08:02Z

0

On The page load we can bind the data with data table

protected void Page_Load(object sender, EventArgs e)
{

    con.Open();
    cmd = con.CreateCommand();

    string CommandText1 = "select * from TRAVEL_Preferences_INFO where USER_ID='" + str_USER_ID + "'";
    DB = new SQLiteDataAdapter(CommandText1, con);
    DS.Reset();
    DB.Fill(DS);
    DT = DS.Tables[0];
    grdTravelPreference.DataSource = DT;
    grdTravelPreference.DataBind();
}

edited Apr 19, 2017 at 14:08

wkl

1,8942 gold badges17 silver badges28 bronze badges

answered Apr 19, 2017 at 10:34

Siddharam Padamgond

12 bronze badges

Collectives™ on Stack Overflow

Adding Data to a GridView

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related