I would like to know if it would be possible to add the "WHERE" clause in the Dataset.Table.Select Method as I keep on getting exceptional errors while trying to run this?

You don't need to include the "WHERE" in your select criteria. You just provide the criteria:

"id = 5"

"price between 5 and 10 and color='blue'"

etc.

Here's the System.Data.DataTable.Select() method documentation:
http://msdn.microsoft.com/library/en...electtopic.asp

-Peter

Hi,

Row filter may be the good solution.
Just check it

My sample coding is

' dim _dt as new DataTable
' Hi I assumed that _dt is DataTable.
Dim strRowFilter As String
strRowFilter = _dt.Columns("Date").ColumnName & " = '" & dtpSearch.Value.Date & "'"
_dt.DefaultView.RowFilter = strRowFilter

This will filter the records.

Difficult can be done immediately. But Impossible will take some more time.