Gridview dynamic update w/ SqlDataSource

Question

I have a SqlDataSource that updates whenever a user specifies a value. I'm trying to do the following to update the gridview as well, but the gridview won't show anything. Did I miss anything here?

private void updateSessionGridView(string p)
{
    session.SelectCommand = @"SELECT TOP 10  * FROM [MyDB]
                                    where key = '" + p + "'";
    GridView1.DataSourceID = null; 
    GridView1.DataSource = session;
    GridView1.DataBind();
}

for ASP.net. I enabled the AutoGenerateSelectButton. Only 10 "Select" column is shown but no actual data. — Yang
– Yang, Commented Mar 14, 2012 at 0:50
Please don't prefix your titles with "C#" and such. That's what the tags are for. — John Saunders
– John Saunders, Commented Mar 14, 2012 at 1:18

John Saunders · Accepted Answer · 2012-03-16 23:35:31Z

1

If you are using a data source control, then you need to set the DataSourceID property, not the DataSource property.

edited Mar 16, 2012 at 23:35

answered Mar 14, 2012 at 1:17

John Saunders

162k26 gold badges252 silver badges403 bronze badges

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

3 Comments

Yang Over a year ago

Unfortunately it doesn't work either when I change the code to GridView1.DataSource = session.ID

John Saunders Over a year ago

No, do not set DataSource. See `DataSourceID'.

John Saunders Over a year ago

I've edited the answer. If you want to remove the downvote, you should be able now.

Collectives™ on Stack Overflow

Gridview dynamic update w/ SqlDataSource

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related