how to filter data from data table to compair with date.

You can store data table in data view and apply filter on that and that bind object of data view at the place of data table.

DataView dv;
dv = ds.Tables[0].DefaultView;
dv.RowFilter = "Date < '"+DateTime.Now.ToString()+"'"; 

Don't forget to mark as answer if it helps. :)

Dim x = From y In dt _
Where y("Date") = DateTime.Now _
                Select y("column1"), y("column2")

X will your I enumerable

to support the answer of Anuj please refer to this link: http://msdn.microsoft.com/en-us/library/bb669073.aspx[^] for the linq practices.

I want records of particular date only. Not to give time in condition criteria.
Please guide...

Dim fndRows() As DataRow

fndRows = DataSet1.TransactionTestMaster.Select("trandate='15/02/2014'")

TextBox4.Text = fndRows.Length


3 Records are in TransactionTestMaster table
TranDate ( Column Name)
1) 2014-02-15 16:51:00
2) 2014-02-15 17:45:00
3) 2014-04-16 17:48:00


I want records of particular date only. Not to give time in condition criteria.

Please guide...