First put ur bindData() in "IF(!IsPostBack)" and clear the DataSet before binding second time.
On Sat, Jan 9, 2010 at 2:06 AM, nag <[email protected]> wrote: > hi friends > > i'm listing magazine upon category select from dropdown > my problem is i'm getting the records from previously selected page > number > that's if i select category from dropdown then click on page number (2 > or 3) > when i go and again select category from dropdown records are > displayed from page number to on datagrid. > please help me > here is my code > > > <body> > <form id="form1" runat="server"> > <div> > <asp:DropDownList > ID="DropDownList1" runat="server" AutoPostBack="true" > DataSourceID="ObjectDataSource1" DataTextField="Category_Name" > DataValueField="Category_Name" > OnSelectedIndexChanged="DropDownList1_OnSelectedIndexChanged"> > </asp:DropDownList><asp:ObjectDataSource > ID="ObjectDataSource1" runat="server" SelectMethod="LoadCategory" > TypeName="CategoryDetails"></asp:ObjectDataSource> > <asp:DataGrid ID="maglist" Runat="server" > BorderColor="Navy" BorderWidth="2px" > AutoGenerateColumns="False" > Width="50%" > HorizontalAlign="Center" > > OnPageIndexChanged="maglist_PageIndexChanged" > AllowPaging="True" > PageSize="15" > > > <HeaderStyle HorizontalAlign="Center" CssClass="tableHeader" > /> > <ItemStyle CssClass="tableCellNormal" /> > <AlternatingItemStyle CssClass="tableCellAlternating" /> > <Columns> > <asp:BoundColumn HeaderText="Magazine_name" > DataField="Magazine_name" /> > <asp:BoundColumn DataField="magazine_description" > HeaderText="magazine_description"> > </asp:BoundColumn> > </Columns> > <PagerStyle Mode="NumericPages" /> > > > </asp:DataGrid> > <br /> > > </div> > </form> > </body> > > C#.net > > <script runat="server"> > private void bindData() > { > SqlConnection myConn = null; > SqlDataAdapter da = null; > DataSet dSet = null; > String strConnection; > String strSQL; > > try > { > myConn = new SqlConnection > (ConfigurationSettings.AppSettings["wrs"]); > myConn.Open(); > string searchText = > DropDownList1.SelectedValue.ToString(); > if (DropDownList1.Text.Contains("'")) > { > searchText = DropDownList1.Text.Replace("'", > "\''"); > } > string query = "Select a.Category_Id, > a.Category_Name,b.umc,b.Magazine_Name,Magazine_Description From > [magazine_category] a Inner Join magazine b on a.Category_Id = > b.Category_Id and a.Category_Name = '" + searchText + "' ORDER BY > b.Magazine_Name ASC"; > da = new SqlDataAdapter(query, myConn); > dSet = new DataSet(); > da.Fill(dSet); > maglist.DataSource = dSet; > maglist.DataBind(); > } > finally > { > if (myConn != null) > { > myConn.Close(); > } > } > } > protected void DropDownList1_OnSelectedIndexChanged(object sender, > EventArgs e) > { > maglist.DataBind(); > bindData(); > } > protected void maglist_PageIndexChanged(object sender, > DataGridPageChangedEventArgs e) > { > maglist.CurrentPageIndex = e.NewPageIndex; > bindData(); > } > </script> >
