Parameterized query

Feb 8 2005 11:45 AM
Hi, I prepared DataAdapter with SQL query with two parameters. The Query is: "Select * from tblX where (XDate between ? And ?); I built a date grid to bind it with the dataset of the dataAdapter. The two parameters come from two dateTimePickers controles. My problem is how to set to the adapter command the two perameters. I want something like: Select * from tblX where (XDate between dateTimePicker1.Value And dateTimePicker2.Value ); Please help. Regards...

Answers (4)