Paging in Data Grid
-
Hi All, I have paging property true in my Datagrid Page. Now ther is Search Creteria in that page.When I click on Search, the Records are Displayed. Now the Problem is that, For Example I have 10 Pages before Search, I got 2 Pages After Search. When I click on the Second Page, All the Pages are Displayed again, not only My Search Second Page. Any Idea. Thanks in Advance. Khan.
-
Hi All, I have paging property true in my Datagrid Page. Now ther is Search Creteria in that page.When I click on Search, the Records are Displayed. Now the Problem is that, For Example I have 10 Pages before Search, I got 2 Pages After Search. When I click on the Second Page, All the Pages are Displayed again, not only My Search Second Page. Any Idea. Thanks in Advance. Khan.
hi Safecom.cn, how are you ? well your problem is nothing...your code is working fine, but you have not handle paging properly.. first make one PagedDatasource oblect... then in one DataTable get your search result....give that DataTable to PagedDataSource as Datasource... Now bing this PagedDataSource to your DataGrid.... then when you clcik on search, result will be saved in paged data source and then to datagrid..so now your datasource is only searched result. also set "Paging" property of PagedDataSource to "true"... try it..if not working then reply me..i will help you.. Bye have a nice day...
Chirag Patel
-
hi Safecom.cn, how are you ? well your problem is nothing...your code is working fine, but you have not handle paging properly.. first make one PagedDatasource oblect... then in one DataTable get your search result....give that DataTable to PagedDataSource as Datasource... Now bing this PagedDataSource to your DataGrid.... then when you clcik on search, result will be saved in paged data source and then to datagrid..so now your datasource is only searched result. also set "Paging" property of PagedDataSource to "true"... try it..if not working then reply me..i will help you.. Bye have a nice day...
Chirag Patel
Thank u very much for Help. Here is my Load function Public Sub DgBound() Try If (Conn.State <> ConnectionState.Open) Then Conn.Open() End If strQry = "Select cust_order.order_id as order_id, cust_order.customer_id as cust_id, cust_order.order_date as order_date, customers.fname as fname, customers.lname as lname from cust_order, customers, cust_order_ship where cust_order.customer_id = customers.customer_id and cust_order.order_id = cust_order_ship.order_id" Command = New OleDbCommand With Command .Connection = Conn .CommandText = strQry .CommandType = CommandType.Text End With da = New OleDbDataAdapter(strQry, Conn) da.SelectCommand = Command ds = New DataSet da.Fill(ds, "cust") dgProfit.DataSource = ds dgProfit.DataBind() totalreclbl.Text = ds.Tables(0).Rows.Count Catch ex As Exception Response.Write(ex.ToString) Finally Conn.Close() End Try End Sub and Here is My Search Code Try If (Conn.State <> ConnectionState.Open) Then Conn.Open() End If strQry = "Select cust_order.order_id as order_id, cust_order.customer_id as cust_id, cust_order.order_date as order_date, customers.fname as fname, customers.lname as lname from cust_order, customers, cust_order_ship where cust_order.customer_id = customers.customer_id and cust_order.order_id = cust_order_ship.order_id and cust_order.order_date >=#" & ViewState("startDate") & "# and cust_order.order_date <=#" & ViewState("endDate") & "#" Command = New OleDbCommand With Command .Connection = Conn .CommandText = strQry .CommandType = CommandType.Text End With Command2 = New OleDbCommand(strQry, Conn) total = Command2.ExecuteReader() If Not total.Read() Then lblMsg.Visible = True Else lblMsg.Visible = False End If da = New OleDbDataAdapter(strQry, Conn) da.SelectCommand = Command ds = New DataSet da.Fill(ds) dgProfit.CurrentPageIndex = 0 dgProfit.DataSource = ds totalreclbl.Text = ds.Tables(0).Rows.Count dgProfit.DataBind()
-
Thank u very much for Help. Here is my Load function Public Sub DgBound() Try If (Conn.State <> ConnectionState.Open) Then Conn.Open() End If strQry = "Select cust_order.order_id as order_id, cust_order.customer_id as cust_id, cust_order.order_date as order_date, customers.fname as fname, customers.lname as lname from cust_order, customers, cust_order_ship where cust_order.customer_id = customers.customer_id and cust_order.order_id = cust_order_ship.order_id" Command = New OleDbCommand With Command .Connection = Conn .CommandText = strQry .CommandType = CommandType.Text End With da = New OleDbDataAdapter(strQry, Conn) da.SelectCommand = Command ds = New DataSet da.Fill(ds, "cust") dgProfit.DataSource = ds dgProfit.DataBind() totalreclbl.Text = ds.Tables(0).Rows.Count Catch ex As Exception Response.Write(ex.ToString) Finally Conn.Close() End Try End Sub and Here is My Search Code Try If (Conn.State <> ConnectionState.Open) Then Conn.Open() End If strQry = "Select cust_order.order_id as order_id, cust_order.customer_id as cust_id, cust_order.order_date as order_date, customers.fname as fname, customers.lname as lname from cust_order, customers, cust_order_ship where cust_order.customer_id = customers.customer_id and cust_order.order_id = cust_order_ship.order_id and cust_order.order_date >=#" & ViewState("startDate") & "# and cust_order.order_date <=#" & ViewState("endDate") & "#" Command = New OleDbCommand With Command .Connection = Conn .CommandText = strQry .CommandType = CommandType.Text End With Command2 = New OleDbCommand(strQry, Conn) total = Command2.ExecuteReader() If Not total.Read() Then lblMsg.Visible = True Else lblMsg.Visible = False End If da = New OleDbDataAdapter(strQry, Conn) da.SelectCommand = Command ds = New DataSet da.Fill(ds) dgProfit.CurrentPageIndex = 0 dgProfit.DataSource = ds totalreclbl.Text = ds.Tables(0).Rows.Count dgProfit.DataBind()
I works fine. But After Search When I click on a page, All the pages are loaded again. I need only search result pages, after search .
-
I works fine. But After Search When I click on a page, All the pages are loaded again. I need only search result pages, after search .
hi ... your problem is like ...your code is loading datagrid with total result..because ithink you have not write that "Public Sub DgBound()" function in "Page_Load" event... you should wirite page_load(...) { if(!Page.IsPostBack) { //then here you can call "Public Sub DgBound()" function... } } amd in search button click event write your search code... do remember use Dataset and datatable static and declare them public and globally...and use only one dataset or datatable to bing in "Public Sub DgBound()" function as well as in "Search" code... try this.. bye..
Chirag Patel