I build Form1.cs,in the form I build a DataGrid witch linked to Dataset of Ms. Access database.
I built also the dataAdapter.
The SelectCommand SQL is with two parameters:
"Select * From tblX where(XDate Between ? AND ?);"
In Form1.cs I have two dateTimePickers (1,2)
I want to set the query parameters with the dateTimePickers valuesin run time.
My target to display only the records their date between the dataTmePickers.
The code is:
//The code to set the dataAdapter query parameters
this.oleDbDataAdapter1.Fill(dateDataSet1); // with th eproper parameters