I want filter dataset using two dates

Adhikar Patil

dt2 = ds.Tables[0].Select().Where(p => (Convert.ToDateTime(p["SignupDate"]) >= Convert.ToDateTime(txtFMinDate.Text)) && (Convert.ToDateTime(p["SignupDate"]) <= Convert.ToDateTime(txtFMaxDate.Text))).CopyToDataTable();

I want Above statement in the below format(This is not working).

DataView dataView = ds.Tables[0].DefaultView;

string where="";

where = "SignupDate >='" + Convert.ToDateTime(txtFMinDate.Text) + "'" + " AND SignupDate <='" + Convert.ToDateTime(txtFMaxDate.Text) + "'";

dataView.RowFilter = where;

DataTable dt = dataView.ToTable();

Filterds.Tables.Add(dt);

So, i want the perfect format.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke8y ago
And have you ensured that your where clause is having dates in yyyy-MM-dd format?

Using values directly from the user input controls and using them in the code is not a good practise.

I suggest you create two dedicated / separate dateTime variables, assign values to them and then use these variables while constructing queries.
Vincent Maverick Durano8y ago
What's not working? are you getting error? Have you tried using the debugger to verify the Date values from your TextBox?
Adhikar Patil8y ago
I have an Table StudentMaster
FirstName nvarchar(50)
LastName nvarchar(50)
SignupDate date
And Records in that table is
FirstName LastName SignupDate
Adhikar Patil 2018-05-10
Sunny Patil 2018-03-25
Shastri Patil 2018-07-28
And now i want to filter dataset using between two dates
Jignesh Kumar8y ago
Hi,
Could you please tell all dates datatype in SQL what types are there for all three coulmns ?