How to search or find the record & display it in the DataGrid?

[SushmitaP]

Hi,

I am completing my project with SQL as back-end & VB.NET as front-end.
Till now every thing i got OK!
But now I don't understand how to find & sort a particular record in the field of my table from the database? Since i want to make a query to fetch the record & display in the same datagrid.

[madjack]

Well i don't think you need SQL query for find or search!
If yes then

select * from tablename 

ie. Dim cmd As SqlCommand = new SqlCommand("SELECT * FROM Tablename")

I hope this is what you want!

[Ubimia]

This is how I search a Dataset...

'Create a dataview
dim dv as new dataview

'Associate the dataview to _oDs (Dataset table)
dv.Table = _oDs.Tables("tblCapitalCategory")

Dim drv As DataRowView 'Data Row View object to query DataView object

'Filter based on a combo box value selected
dv.RowFilter = "[pkCapitalCategoryID] = " & CInt(cboComboBox.SelectedValue)

'Retrieve my values returned in the result
For Each drv In dv
     _dteDateModified = drv("dteDateModified")
Next

Hopefully you get some use of this. I use this method to search for any values in my datasets.

dv.RowFilter is the key to the search. It is kind of like a SQL where statement on the results of the dataset.

The nice thing about this method is the original dataset is not manipulated in any way. You do everything based on a manipulated view of the datasets results.