RowFilter Multiple Expr

[Moishe]

Hi All

I have a textBoxName, startDate and endDate

 

What string should I put in the rowfilter so after it would give me the name rows for all days like between these days in my dataview.

 

this is how it is in the select comment

 

select textBoxName from table where [date] between startDate and endDate

 

Thanks for your help

[Nerseus]

Try something like:

ds.Tables["Table1"].DefaultView.RowFilter = "[date] BETWEEN '" + txtStart.ToString("mm/dd/yyyy") + "' AND '" + txtEnd.ToString("mm/dd/yyyy") + "'";

 

I haven't tried it, but I believe the RowFilter supports BETWEEN with Dates. The rest is just formatting...

 

If it doesn't support BETWEEN with dates, you can use a >= and <= solution.

 

-Nerseus

[Moishe]

Thanks for your reply.

 

I converted to vb.net and it didn't work not only BETWEEN but als AND keywords

and how can I also selec customer name in the same rowfilter

 

Thanks for your help

[Nerseus]

The between didn't work for me either, but you can use the AND method. Try this:

ds.Tables["Table1"].DefaultView.RowFilter = "[date] >= '" + txtStart.ToString("mm/dd/yyyy") + "' AND [date] <= '" + txtEnd.ToString("mm/dd/yyyy") + "'";

 

You can just add " AND name like 'jon%'" to the end (or however you want to code your customer name filter) to filter by customer name.

 

-Ner

[Moishe]

Thank you very much I got it!