 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / ASP.NET / Web Controls / August 2005gridview paging and sorting
i have a gridview and sqldatasource control on a page i also have a bunch of textboxes and dropdownlists to filter the data. when the page is first navigated to, i set the selectcommand and call the select method of the sqldatasource control. then i filter the data and it still works. but then i try to page and sort the data and it breaks. below is the code. should i be handling the PageIndexChanged/Sorted event instead of the PageIndexChanging/Sorting event? <%@ Page Language="C#" EnableViewState="True" MasterPageFile="AdminPage.master" %> <script language="c#" runat="server"> void sdsRDK_Selected(Object Sender, SqlDataSourceStatusEventArgs E) { lblTotal.Text = E.AffectedRows.ToString(); } void Page_Load (Object Sender, EventArgs E) { if (!Page.IsPostBack) { DataBind(); } } void btnRefresh_Click(Object Sender, EventArgs E) { DataBind(); } void gvCustomers_Sorting(Object Sender, GridViewSortEventArgs E) { DataBind(); } void gvCustomers_PageIndexChanging(Object Sender, GridViewPageEventArgs E) { DataBind(); } void DataBind() { gvCustomers.PageSize = Convert.ToInt32(ddlRPP.SelectedItem.Value); lblSQL.Text = "SELECT [CusId], [Name], [Addr1] + '<br>' + [City] + ', ' + [State] + ' ' + [Post] AS Address, [PhoneWork], [Contact], [EmailWork] FROM [COCUS] WHERE (CusId Like " + (tbCusId.Text == "" ? "'%' OR CusId Is Null)" : "'%" + tbCusId.Text + "%')") + " AND (Name Like " + (tbName.Text == "" ? "'%' OR Name Is Null)" : "'%" + tbName.Text + "%')") + " AND (Addr1 Like " + (tbAddr1.Text == "" ? "'%' OR Addr1 Is Null)" : "'%" + tbAddr1.Text + "%')") + " AND (Addr2 Like " + (tbAddr2.Text == "" ? "'%' OR Addr2 Is Null)" : "'%" + tbAddr2.Text + "%')") + " AND (City Like " + (tbCity.Text == "" ? "'%' OR City Is Null)" : "'%" + tbCity.Text + "%')") + " AND (County Like " + (tbCounty.Text == "" ? "'%' OR County Is Null)" : "'%" + tbCounty.Text + "%')") + " AND (State Like " + (ddlState.SelectedItem.Value == "%" ? "'%' OR State Is Null)" : "'" + ddlState.SelectedItem.Value + "')") + " AND (Post Like " + (tbPost.Text == "" ? "'%' OR Post Is Null)" : "'%" + tbPost.Text + "%')") + " AND (Country Like " + (tbCountry.Text == "" ? "'%' OR Country Is Null)" : "'%" + tbCountry.Text + "%')") + " AND (BillCusId Like " + (tbBillCusId.Text == "" ? "'%' OR BillCusId Is Null)" : "'%" + tbBillCusId.Text + "%')") + " AND (BillAddr1 Like " + (tbBillAddr1.Text == "" ? "'%' OR BillAddr1 Is Null)" : "'%" + tbBillAddr1.Text + "%')") + " AND (BillAddr2 Like " + (tbBillAddr2.Text == "" ? "'%' OR BillAddr2 Is Null)" : "'%" + tbBillAddr2.Text + "%')") + " AND (BillCity Like " + (tbBillCity.Text == "" ? "'%' OR BillCity Is Null)" : "'%" + tbBillCity.Text + "%')") + " AND (BillCounty Like " + (tbBillCounty.Text == "" ? "'%' OR BillCounty Is Null)" : "'%" + tbBillCounty.Text + "%')") + " AND (BillState Like " + (ddlBillState.SelectedItem.Value == "%" ? "'%' OR BillState Is Null)" : "'" + ddlBillState.SelectedItem.Value + "')") + " AND (BillPost Like " + (tbBillPost.Text == "" ? "'%' OR BillPost Is Null)" : "'%" + tbBillPost.Text + "%')") + " AND (BillCountry Like " + (tbBillCountry.Text == "" ? "'%' OR BillCountry Is Null)" : "'%" + tbBillCountry.Text + "%')") + " AND (PhoneHome Like " + (tbPhoneHome.Text == "" ? "'%' OR PhoneHome Is Null)" : "'%" + tbPhoneHome.Text + "%')") + " AND (PhoneWork Like " + (tbPhoneWork.Text == "" ? "'%' OR PhoneWork Is Null)" : "'%" + tbPhoneWork.Text + "%')") + " AND (PhoneOther Like " + (tbPhoneOther.Text == "" ? "'%' OR PhoneOther Is Null)" : "'%" + tbPhoneOther.Text + "%')") + " AND (PhoneFax Like " + (tbPhoneFax.Text == "" ? "'%' OR PhoneFax Is Null)" : "'%" + tbPhoneFax.Text + "%')") + " AND (Contact Like " + (tbContact.Text == "" ? "'%' OR Contact Is Null)" : "'%" + tbContact.Text + "%')") + " AND (EmailHome Like " + (tbEmailHome.Text == "" ? "'%' OR EmailHome Is Null)" : "'%" + tbEmailHome.Text + "%')") + " AND (EmailWork Like " + (tbEmailWork.Text == "" ? "'%' OR EmailWork Is Null)" : "'%" + tbEmailWork.Text + "%')") + " AND (EmailOther Like " + (tbEmailOther.Text == "" ? "'%' OR EmailOther Is Null)" : "'%" + tbEmailOther.Text + "%')") + " AND (Ssn Like " + (tbSsn.Text == "" ? "'%' OR Ssn Is Null)" : "'%" + tbSsn.Text + "%')") + " AND (SsnSpouse Like " + (tbSsnSpouse.Text == "" ? "'%' OR SsnSpouse Is Null)" : "'%" + tbSsnSpouse.Text + "%')") + " AND (AllowSpecialPri Like " + (ddlAllowSpecialPri.SelectedItem.Value == "%" ? "'%' OR AllowSpecialPri Is Null)" : "'" + ddlAllowSpecialPri.SelectedItem.Value + "')") + " AND (NotId Like " + (tbNotId.Text == "" ? "'%' OR NotId Is Null)" : "'%" + tbNotId.Text + "%')") + " AND (CusMisc1 Like " + (tbCusMisc1.Text == "" ? "'%' OR CusMisc1 Is Null)" : "'%" + tbCusMisc1.Text + "%')") + " AND (CusMisc2 Like " + (tbCusMisc2.Text == "" ? "'%' OR CusMisc2 Is Null)" : "'%" + tbCusMisc2.Text + "%')") + " AND (CusMisc3 Like " + (tbCusMisc3.Text == "" ? "'%' OR CusMisc3 Is Null)" : "'%" + tbCusMisc3.Text + "%')") + " AND (CusMisc4 Like " + (tbCusMisc4.Text == "" ? "'%' OR CusMisc4 Is Null)" : "'%" + tbCusMisc4.Text + "%')") + " AND (CusMisc5 Like " + (tbCusMisc5.Text == "" ? "'%' OR CusMisc5 Is Null)" : "'%" + tbCusMisc5.Text + "%')"); sdsRDK.SelectCommand = lblSQL.Text; sdsRDK.Select(new DataSourceSelectArguments()); } </script> <asp:content id="contentHeader" contentplaceholderid="cphHeader" runat="server"><img src="../../images/headercustomers.gif" width="185" height="30"></asp:content> <asp:content id="contentSubNav" contentplaceholderid="cphSubNav" runat="server"> </asp:content> <asp:content id="contentHome" contentplaceholderid="cphMainContent" runat="server"> <form id="frmCustomers" runat="server"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td><table width="100%" border="0" cellpadding="3" cellspacing="0" class="tablefilter"> <tr> <td><strong><a onClick="javascript:ShowHide('tdFilter','imgFilterShow');" style="cursor:hand"><img id="imgFilterShow" src="../../images/buttonshow.gif" width="11" height="11" border="0"></a> Filter</strong></td> </tr> <tr> <td id="tdFilter" style="display:none;"><table width="100%"> <tr> <td width="20"> </td> <td><strong>Company Info </strong></td> </tr> <tr> <td> </td> <td><table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td align="right">Customer ID:</td> <td><asp:TextBox ID="tbCusId" runat="server" /></td> <td align="right">Company Name:</td> <td><asp:TextBox ID="tbName" runat="server" /></td> </tr> <tr> <td align="right">Address 1:</td> <td><asp:TextBox ID="tbAddr1" runat="server" /></td> <td align="right">Address 2:</td> <td><asp:TextBox ID="tbAddr2" runat="server" /></td> </tr> <tr> <td colspan="4"><table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td align="right">City:</td> <td><asp:TextBox ID="tbCity" runat="server" /></td> <td align="right">County:</td> <td><asp:TextBox ID="tbCounty" runat="server" /></td> <td align="right">State:</td> <td><RDK:StateDropDown ID="ddlState" runat="server" /></td> <td align="right">Postal Code:</td> <td><asp:TextBox ID="tbPost" runat="server" /></td> <td align="right">Country:</td> <td><asp:TextBox ID="tbCountry" runat="server" /></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td> </td> <td><strong>Billing Info</strong></td> </tr> <tr> <td> </td> <td><table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td align="right">Billing Customer ID:</td> <td colspan="3"><asp:TextBox ID="tbBillCusId" runat="server" /></td> </tr> <tr> <td align="right">Address 1:</td> <td><asp:TextBox ID="tbBillAddr1" runat="server" /></td> <td align="right">Address 2:</td> <td><asp:TextBox ID="tbBillAddr2" runat="server" /></td> </tr> <tr> <td colspan="4"><table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td align="right">City:</td> <td><asp:TextBox ID="tbBillCity" runat="server" /></td> <td align="right">County:</td> <td><asp:TextBox ID="tbBillCounty" runat="server" /></td> <td align="right">State:</td> <td><RDK:StateDropDown ID="ddlBillState" runat="server" /></td> <td align="right">Postal Code:</td> <td><asp:TextBox ID="tbBillPost" runat="server" /></td> <td align="right">Country:</td> <td><asp:TextBox ID="tbBillCountry" runat="server" /></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td> </td> <td><strong>Phone Numbers </strong></td> </tr> <tr> <td> </td> <td><table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td align="right">Home:</td> <td><asp:TextBox ID="tbPhoneHome" runat="server" /></td> <td align="right">Work:</td> <td><asp:TextBox ID="tbPhoneWork" runat="server" /></td> </tr> <tr> <td align="right">Other:</td> <td><asp:TextBox ID="tbPhoneOther" runat="server" /></td> <td align="right">Fax:</td> <td><asp:TextBox ID="tbPhoneFax" runat="server" /></td> </tr> </table></td> </tr> <tr> <td> </td> <td><strong>Contact Info</strong></td> </tr> <tr> <td> </td> <td><table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td align="right">Name:</td> <td><asp:TextBox ID="tbContact" runat="server" /></td> <td align="right">SSN:</td> <td><asp:TextBox ID="tbSsn" runat="server" /></td> <td align="right">Spouse SSN: </td> <td><asp:TextBox ID="tbSsnSpouse" runat="server" /></td> </tr> <tr> <td align="right">DOB:</td> <td><asp:TextBox ID="tbDateBirth" runat="server" /></td> <td align="right">Spouse DOB: </td> <td><asp:TextBox ID="tbDateBirthSpouse" runat="server" /></td> <td align="right">Allow Special Price: </td> <td><RDK:AllowSpecialPriDropDown ID="ddlAllowSpecialPri" runat="server" /></td> </tr> </table></td> </tr> <tr> <td> </td> <td><strong>Email Addresses</strong></td> </tr> <tr> <td> </td> <td><table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td align="right">Home:</td> <td><asp:TextBox ID="tbEmailHome" runat="server" /></td> <td align="right">Work:</td> <td><asp:TextBox ID="tbEmailWork" runat="server" /></td> <td align="right">Other:</td> <td><asp:TextBox ID="tbEmailOther" runat="server" /></td> </tr> </table></td> </tr> <tr> <td> </td> <td><strong>User Info</strong></td> </tr> <tr> <td> </td> <td><table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td align="right"> </td> <td> </td> <td align="right">Date Created:</td> <td><asp:TextBox ID="tbDateCreate" runat="server" /></td> <td align="right">Date Updated: </td> <td><asp:TextBox ID="tbDateUpdate" runat="server" /></td> </tr> <tr> <td align="right">Note ID: </td> <td><asp:TextBox ID="tbNotId" runat="server" /></td> <td align="right"> </td> <td> </td> <td align="right">Date Invoice:</td> <td><asp:TextBox ID="tbDateInvoice" runat="server" /></td> </tr> </table></td> </tr> <tr> <td> </td> <td><strong>Miscellaneous</strong></td> </tr> <tr> <td> </td> <td><table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td>1</td> <td>2</td> <td>3</td> <td>4</td> <td>5</td> </tr> <tr> <td><asp:TextBox ID="tbCusMisc1" Rows="5" TextMode="MultiLine" runat="server" /></td> <td><asp:TextBox ID="tbCusMisc2" Rows="5" TextMode="MultiLine" runat="server" /></td> <td><asp:TextBox ID="tbCusMisc3" Rows="5" TextMode="MultiLine" runat="server" /></td> <td><asp:TextBox ID="tbCusMisc4" Rows="5" TextMode="MultiLine" runat="server" /></td> <td><asp:TextBox ID="tbCusMisc5" Rows="5" TextMode="MultiLine" runat="server" /></td> </tr> </table></td> </tr> <tr> <td> </td> <td align="right"><asp:Button ID="btnRefresh1" Text="Refresh" runat="server" CssClass="formbutton" OnClick="btnRefresh_Click" /></td> </tr> </table></td> </tr> <tr> <td><a onClick="javascript:ShowHide('tdDisplay','imgDisplayShow');" style="cursor:hand"><img id="imgDisplayShow" src="../../images/buttonshow.gif" width="11" height="11" border="0"></a> <strong>Display </strong></td> </tr> <tr> <td id="tdDisplay" style="display:none;"><table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td align="right">Results Per Page:</td> <td><RDK:RPPDropDown ID="ddlRPP" runat="server" /></td> </tr> <tr> <td colspan="2" align="right"><asp:Button ID="btnRefresh2" Text="Refresh" runat="server" CssClass="formbutton" OnClick="btnRefresh_Click" /></td> </tr> </table></td> </tr> </table> </td> </tr> <tr> <td> </td> </tr> <tr> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td><table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td> </td> <td align="center"><asp:Label ID="lblTotal" runat="server" /> Customers</td> <td align="right"> </td> </tr> </table></td> </tr> <tr> <td> <asp:GridView ID="gvCustomers" runat="server" AutoGenerateColumns="False" DataSourceID="sdsRDK" AllowPaging="True" AllowSorting="True" BackColor="#000000" BorderWidth="0px" CellPadding="1" CellSpacing="2" Width="100%" OnSorting="gvCustomers_Sorting" OnPageIndexChanging="gvCustomers_PageIndexChanging"> <Columns> <asp:HyperLinkField DataNavigateUrlFields="CusId" DataNavigateUrlFormatString="editcustomer.aspx?CusId={0}" Text="Edit" /> <asp:BoundField DataField="CusID" HeaderText="Customer ID:" SortExpression="CusId" /> <asp:BoundField DataField="Name" HeaderText="Company Name:" SortExpression="Name" /> <asp:BoundField DataField="Contact" HeaderText="Contact Name:" SortExpression="Contact" /> <asp:BoundField DataField="PhoneWork" HeaderText="Business Phone:" SortExpression="PhoneWork" /> <asp:BoundField DataField="Address" HeaderText="Address:" SortExpression="Addr1" /> <asp:BoundField DataField="EmailWork" HeaderText="Email:" SortExpression="EmailWork" /> </Columns> <RowStyle CssClass="tableitem" /> <PagerStyle CssClass="tableitem" /> <HeaderStyle CssClass="tableheader" /> <AlternatingRowStyle CssClass="tablealtitem" /> <PagerSettings Mode="Numeric" /> </asp:GridView> <asp:SqlDataSource ID="sdsRDK" runat="server" OnSelected="sdsRDK_Selected" ConnectionString="<%$ ConnectionStrings:TestConnection %>" /> </td> </tr> <tr> <td align="center"><table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td> </td> <td align="center"> </td> <td align="right"> </td> </tr> </table></td> </tr> <tr> <td align="center"><asp:Label ID="lblSQL" runat="server" Visible="false" /></td> </tr> </table></td> </tr> </table> </form> </asp:content> Are you trying to get behavior like this? http://www.hugetiger.com/dbexplore/TechNotes.html Navigate to a table view and play with the sort links at the top of each column. Best John >i have a gridview and sqldatasource control on a page > i also have a bunch of textboxes and dropdownlists to filter the data. [quoted text clipped - 497 lines] > </form> > </asp:content> Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.