ASP.NET

coder@coder.org wrote:

There is search Technique in my page. When i click on search, Data is displayed on Datagrid. For Example there are two pages after search. When I click on the second page all the data is displayed again, althought i need only search Data

coder@coder.org wrote:

have called this event in Page Load Event.
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

If not isPostBack Then
   'call the function to load in pageload
End If

If !IsPostBack()
{
   BindGrd();     //private function
}

DataGrid.PageIndex = currentPageIndex;
BindGrid()