Filter OleDB Results

[tikki]

I have an ACcess database I connected to via an OleDBConnection & have it show the values of an entire table in a DataGrid. I want to be able to filter this DataGrid to show only the values that have the value of the date the user selects via a MonthCalendar.

What would be the best way of achieving this?

 

[Robby]

which method are you using to open the connection?

 

[tikki]

I am using an OleDbConnection control connecting to the Access DB w/ Jet.

 

[Derek Stone]

Associate a DataView object with your connection. The DataView class allows you filter which rows are displayed.

 

[tikki]

Problem solved!

Thanks to all for the help.