Paging-enabled GridView disappears at postback

I've been googling for some time, and could not find the solution to
this problem.

I am testing the paging feature of gridview. I have a very simple web
form on which the user can select a few fields to be included in the
table, which is to be bound to the gridview.

The web form looks like so (Don't worry about the stupidity of this
web form for now.):

Check stuffs you wanna include in the table:

[] Customer ID
[] Customer Last Name
[] Customer First Name
[] Customer Email
[] Customer Phone

[Click this button to show the table]

[-- the paging-enabled gridview is right here --]

The gridview is declared like so:

<asp:GridView ID="GridView1"
EnableViewState="true"
EnableSortingAndPagingCallbacks="true"
DataSourceID="SqlDataSource1"
runat="server"
AllowPaging="True"
AllowSorting="true">
</asp:GridView>

In the code-behind (in C#), I pass the programmatically created SQL
select command to the SqlDataSource like so:

SqlDataSource1.SelectCommand = theSelectCommandCreatedOnTheFly;

Now, after the user clicks the button to create the customer report,
the gridview is populated with customer data with the expected fields.

But, when the paging index is clicked, the gridview disaapears. One
short note from a blog says that gridview will disappear between
postbacks. So, this might be the cause.

I guess I don't need to implement a GridView1_OnPageIndexChanging
method to handle the paging event since I don't think I am manually
binding the gridview to the dataset.

How do we handle this problem? Thanks.On Jan 31, 4:49 am, "antonyliu2...@.yahoo.com"
<antonyliu2...@.yahoo.comwrote:

Quote:

Originally Posted by

I've been googling for some time, and could not find the solution to
this problem.
>
I am testing the paging feature of gridview. I have a very simple web
form on which the user can select a few fields to be included in the
table, which is to be bound to the gridview.
>
The web form looks like so (Don't worry about the stupidity of this
web form for now.):
>
Check stuffs you wanna include in the table:
>
[] Customer ID
[] Customer Last Name
[] Customer First Name
[] Customer Email
[] Customer Phone
>
[Click this button to show the table]
>
[-- the paging-enabled gridview is right here --]
>
The gridview is declared like so:
>
<asp:GridView ID="GridView1"
EnableViewState="true"
EnableSortingAndPagingCallbacks="true"
DataSourceID="SqlDataSource1"
runat="server"
AllowPaging="True"
AllowSorting="true">
</asp:GridView>
>
In the code-behind (in C#), I pass the programmatically created SQL
select command to the SqlDataSource like so:
>
SqlDataSource1.SelectCommand = theSelectCommandCreatedOnTheFly;
>
Now, after the user clicks the button to create the customer report,
the gridview is populated with customer data with the expected fields.
>
But, when the paging index is clicked, the gridview disaapears. One
short note from a blog says that gridview will disappear between
postbacks. So, this might be the cause.
>
I guess I don't need to implement a GridView1_OnPageIndexChanging
method to handle the paging event since I don't think I am manually
binding the gridview to the dataset.
>
How do we handle this problem? Thanks.

sound's like you don't bind your grid after postback

Can you please tell us where you do bind it (sample code)?
On Jan 31, 1:36 am, "Alexey Smirnov" <alexey.smir...@.gmail.comwrote:

Quote:

Originally Posted by

On Jan 31, 4:49 am, "antonyliu2...@.yahoo.com">
>
<antonyliu2...@.yahoo.comwrote:

Quote:

Originally Posted by

I've been googling for some time, and could not find the solution to
this problem.

>

Quote:

Originally Posted by

I am testing the paging feature of gridview. I have a very simple web
form on which the user can select a few fields to be included in the
table, which is to be bound to the gridview.

>

Quote:

Originally Posted by

The web form looks like so (Don't worry about the stupidity of this
web form for now.):

>

Quote:

Originally Posted by

Check stuffs you wanna include in the table:

>

Quote:

Originally Posted by

[] Customer ID
[] Customer Last Name
[] Customer First Name
[] Customer Email
[] Customer Phone

>

Quote:

Originally Posted by

[Click this button to show the table]

>

Quote:

Originally Posted by

[-- the paging-enabled gridview is right here --]

>

Quote:

Originally Posted by

The gridview is declared like so:

>

Quote:

Originally Posted by

<asp:GridView ID="GridView1"
EnableViewState="true"
EnableSortingAndPagingCallbacks="true"
DataSourceID="SqlDataSource1"
runat="server"
AllowPaging="True"
AllowSorting="true">
</asp:GridView>

>

Quote:

Originally Posted by

In the code-behind (in C#), I pass the programmatically created SQL
select command to the SqlDataSource like so:

>

Quote:

Originally Posted by

SqlDataSource1.SelectCommand = theSelectCommandCreatedOnTheFly;

>

Quote:

Originally Posted by

Now, after the user clicks the button to create the customer report,
the gridview is populated with customer data with the expected fields.

>

Quote:

Originally Posted by

But, when the paging index is clicked, the gridview disaapears. One
short note from a blog says that gridview will disappear between
postbacks. So, this might be the cause.

>

Quote:

Originally Posted by

I guess I don't need to implement a GridView1_OnPageIndexChanging
method to handle the paging event since I don't think I am manually
binding the gridview to the dataset.

>

Quote:

Originally Posted by

How do we handle this problem? Thanks.

>
sound's like you don't bind your grid after postback
>
Can you please tell us where you do bind it (sample code)?- Hide quoted text -
>

OK, thanks a lot. I actually mentioned it in my original post. I have
a SqlDataSource control and the GridView is bound to it in the
declaration. I repeat the GridView declaration here:

<asp:GridView ID="GridView1"
EnableViewState="true"
EnableSortingAndPagingCallbacks="true"
DataSourceID="SqlDataSource1"
runat="server"
AllowPaging="True"
AllowSorting="true">
</asp:GridView>

In the code behind, the only thing I programmatically do is to assign
the select command to SqlDataSource1 like so:

SqlDataSource1.SelectCommand = theSelectCommandCreatedOnTheFly;

In other words, I don't have anything in code-behind that mannually
binds the data to the gridview, nothing in my code-behind is like
getting a DataSet, SqlDataAdapter, Fills the DataSet, DataBind the
GridView.

That's why I also mentioned that I probably don't have to implement a
method GridView1_OnPageIndexChanging since I am not manually binding
the GridView. I might be wrong, but please advise. Thanks again.