Query DataTable to get records between Start and End Dates

        DataTable dt = new DataTable();
        dt.Columns.Add("Name");
        dt.Columns.Add("DOB");
        dt.Rows.Add();
        dt.Rows[0]["Name"] = "John";        
        dt.Rows[0]["DOB"] = new DateTime(1996, 1, 31);

        dt.Rows.Add();
        dt.Rows[1]["Name"] = "Mark";
        dt.Rows[1]["DOB"] = new DateTime(1986, 11, 22);

        dt.Rows.Add();
        dt.Rows[2]["Name"] = "Sarah";
        dt.Rows[2]["DOB"] = new DateTime(1998, 6, 12);

        DateTime startDate = new DateTime(1995, 1, 1);
        DateTime endDate = new DateTime(2000, 1, 1);
        DataRow[] rows = dt.Select("DOB >= #" + startDate + "# AND DOB <= #" + endDate + "#");