I'm very new to the ADO.NET and WebForms arena, so the problem that
I'm having is probably trivial.
Using VS2005, I'm just creating a small test project that has a text
box allowing you to enter a SQL statement, a button to execute the
statement and a GridView control to display the results. The GridView
control should AllowPaging and AllowSorting. The data comes from a SQL
datasource, which I access through a connection string stored in
web.config (no problems there).
When I click the Execute Button, the SQL statement is correctly
executed and the GridView control is properly populated. The problem
arises when I want to jump to the next (or any other) page. It appears
the statement is executed but the gridview control disappears. Any
idea what's causing this?
Here is the relevant excerpt from the aspx page:
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="TextBox1" runat="server"
Text="SELECT * FROM
customerversion " Width="423px"></asp:TextBox>
<br />
<asp:Button ID="Button1" runat="server"
Text="Execute"
OnClick="Button 1_Click" Width="109px" />
<br />
<br />
<asp:GridView ID="GridView1"
runat="server"
AllowPaging="Tr ue"
EnableSortingAn dPagingCallback s="true"
OnPageIndexChan ging="GridView1 _PageIndexChang ing">
</asp:GridView>
</div>
</form>
Below is the code that lives in the Code-Behind file:
protected void Button1_Click(o bject sender, EventArgs e)
{
GetData();
}
protected void GridView1_PageI ndexChanging(ob ject sender,
GridViewPageEve ntArgs e)
{
GridView1.PageI ndex = e.NewPageIndex;
GetData();
}
private int GetData()
{
SqlConnection conn = new
SqlConnection(C onfigurationMan ager.Connection Strings["SCMConnectionS tring1"].ConnectionStri ng);
SqlCommand cmd = conn.CreateComm and();
cmd.CommandType = CommandType.Tex t;
cmd.CommandText = this.TextBox1.T ext;
SqlDataAdapter da = new SqlDataAdapter( );
da.SelectComman d = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataS ource = ds;
GridView1.DataB ind();
return ds.Tables[0].Rows.Count;
}
