Hi,
I have a .NET page which has a gridview of customers from Northwind
database. There's a checkbox for each customer and the gridview allows
paging.
I would like to be able to persist the checkbox status while paging. I'm
starting with the code below but I can't get it to work. You can check some
of the checkboxes and when you click on the pager, no selection is reflected
by the trace. Why's that?
Thanks,
ywb
//*************** *************** *************** **
<%@ Page Language="C#" Trace="true" %>
<%@ Import Namespace="Syst em.Data" %>
<%@ Import Namespace="Syst em.Data.SqlClie nt" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dt d">
<script runat="server">
protected SqlConnection myConnect;
protected SqlDataAdapter myDataAdapter;
protected SqlCommand myCommand;
protected DataSet myDataSet;
protected void Page_Load(objec t sender, EventArgs e)
{
myConnect = new
SqlConnection(" server=(local); database=Northw ind;uid=sa;pwd= ;");
BindData();
}
private void BindData()
{
string sqlQuery = "SELECT * FROM Customers";
myDataAdapter = new SqlDataAdapter( sqlQuery, myConnect);
myDataSet = new DataSet();
myDataAdapter.F ill(myDataSet);
GvwCustomers.Da taSource = myDataSet;
GvwCustomers.Da taBind();
}
private void FindSelections( )
{
foreach (GridViewRow row in GvwCustomers.Ro ws)
{
string customerID = GvwCustomers.Da taKeys[row.RowIndex].Value.ToString ();
CheckBox cbx = (CheckBox)row.F indControl("Cbx Selected");
if (cbx.Checked)
Trace.Warn(cust omerID + " is selected");
else
Trace.Warn(cust omerID + " is NOT selected");
}
}
protected void GvwCustomers_Pa geIndexChanging (object sender,
GridViewPageEve ntArgs e)
{
FindSelections( );
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Paging with Checkboxes</title>
</head>
<body>
<form id="form1" runat="server">
<asp:GridView ID="GvwCustomer s" runat="server" DataKeyNames="C ustomerID"
AllowPaging="tr ue"
AutoGenerateCol umns="False"
OnPageIndexChan ging="GvwCustom ers_PageIndexCh anging">
<Columns>
<asp:TemplateFi eld HeaderText="Del ete">
<ItemTemplate >
<asp:CheckBox ID="CbxSelected " runat="server" />
</ItemTemplate>
</asp:TemplateFie ld>
<asp:BoundFie ld HeaderText="ID" DataField="Cust omerID" />
<asp:BoundFie ld HeaderText="Nam e" DataField="Cont actName" />
<asp:BoundFie ld HeaderText="Tit le" DataField="Cont actTitle" />
</Columns>
</asp:GridView>
</form>
</body>
</html>
//*************** *************** *************** **
