CODEWITHSUNDEEP
asp.netvb.netfilterdatatabledataset
comkalp
comkalp

Reputation: 63

Search data from dataset

I want to search record based on following fields

    P_num ,P_name, P_dob,P_code

I am using more than 4 tables to retrive data, I have created dataset called P_search and i want to fill data into dataset and thsn display it according to which field is selected for search purpose.

Suggest me to write code by creating own function in which all fields and a boolean variable will be taken as parameters

Please help me to write code using VB.net.

I am very new to VB.net. Is ther anyone who can help me giving above code.

Thank You In advance

Upvotes: 0

Views: 2719

Answers (1)

Muhammad Akhtar
Muhammad Akhtar

Reputation: 52241

You use DataTable.Select Method

Private Sub GetRowsByFilter()

    Dim table As DataTable = DataSet1.Tables("Orders")

    ' Presuming the DataTable has a column named Date.
    Dim expression As String
    expression = "Date > #1/1/00#"
    Dim foundRows() As DataRow

    ' Use the Select method to find all rows matching the filter.
    foundRows = table.Select(expression)

    Dim i As Integer
    ' Print column 0 of each returned row.
    For i = 0 to foundRows.GetUpperBound(0)
       Console.WriteLine(foundRows(i)(0))
    Next i
End Sub

Upvotes: 1

Related Questions