Filter Dataset value

[jebin k]

I need to filter a value in Dataset. My code is string ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=\"Text;HDR=No;FMT=Delimited\\\""; System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(ConStr); System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter("Select * from " + file, conn); da.Fill(ds, "TextFile"); Here i have not defined any column value, Still Can i filter the dataset.

[Sandeep Kumar]

yes i think you can still filter the column values....

Regards, Sandeep Kumar.V

[jebin k]

Can you please give me some clue or syntax

[John ph]

you can use RowFilter property of Dataview to filter rows from the dataset... something like this... Dim view As New DataView view = DataSet1.Tables("TableName").DefaultView view.RowFilter = "Column = 'FilterValue'"

Regards
 - J O N -

---