Hi,
you can try this out:
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[] { new DataColumn("Name", typeof(string)), new DataColumn("Amount", typeof(int)), new DataColumn("Date", typeof(DateTime)) });
dt.Rows.Add(new object[] { "Sam", 1000, new DateTime(2013, 06, 12) });
dt.Rows.Add(new object[] { "Derk", 2000, new DateTime(2013, 07, 1) });
dt.Rows.Add(new object[] { "Rohan", 4000, new DateTime(2013, 08, 16) });
string myfilter = "Date > #" + dt.Rows[1][2].ToString() + "# AND Date <=#" + dt.Rows[2][2].ToString() + "#";
dt.Select(myfilter);
DataRow[] drTemp = dt.Select(myfilter);
DataTable dtTemp = drTemp.CopyToDataTable();