Gridview is not displaying data with code-behind sqldatasource

Question

I have gridview and its binded with datasource which is created in the code behind file. And I needed to enable sorting and paging in the easiest way so I wrote as following -

In button's click event

SqlDataSource dataSource = new SqlDataSource(ConfigurationManager.ConnectionStrings["connstr"].ConnectionString, searchQuery);
        dataSource.SelectCommandType = SqlDataSourceCommandType.Text;
        dataSource.SelectCommand = searchQuery;
        if (txtSearchQuery.Text != "")
        {
            dataSource.SelectParameters.Add("searchQuery", txtSearchQuery.Text);
        }
        gridBookings.DataSourceID = dataSource.ID;

However, when the button was clicked, the gridview wasn't populated with data. Any ideas?

Massimiliano Peluso · Accepted Answer · 2011-08-31 08:52:33Z

3

you forgot to call DataBind on the grid:

gridBookings.DataBind();

answered Aug 31, 2011 at 8:52

Massimiliano Peluso

26.8k6 gold badges65 silver badges75 bronze badges

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

1 Comment

Ye Myat Aung Over a year ago

Now its returning empty data. I'm sure the query is correct and there are data in the DB. However, if I change to - gridBookings.DataSource = dataSource; gridBookings.DataBind(); The grid is populated. However, I can't sort it.

Eric Herlitz · Accepted Answer · 2011-08-31 08:54:21Z

0

you must databind

...
gridBookings.DataSourceID = dataSource.ID;
gridBookings.DataBind();

Although I'd prefer this approach

...
gridBookings.DataSource = dataSource;
gridBookings.DataBind();

answered Aug 31, 2011 at 8:54

Eric Herlitz

26.4k28 gold badges117 silver badges167 bronze badges

4 Comments

Ye Myat Aung Over a year ago

From what I've read on a blog, if I use DataSource instead of DataSourceID, I'd have to manually write the code for sorting and paging. Is it correct?

Eric Herlitz Over a year ago

That depends on the control, but if you want control then yes. Have a look at msdn.microsoft.com/en-us/library/ms745786.aspx

Ye Myat Aung Over a year ago

So how would you recommend if I want it to get sorting and paging without minimal codes.

Eric Herlitz Over a year ago

I'd say use the controls shipping with the GridView.

Davide Piras · Accepted Answer · 2011-08-31 08:55:33Z

0

difficult to say without seeing your full page markup and code behind.

In general after associating the DataSource you should also call:

gridBookings.DataBind();

answered Aug 31, 2011 at 8:55

Davide Piras

44.7k10 gold badges103 silver badges150 bronze badges

Collectives™ on Stack Overflow

Gridview is not displaying data with code-behind sqldatasource

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related