combobox, DTP, search button

Question

visual studio 2015, C#, MS Access Database. I want to select from combobox as SuspenceAccount, datetimepicker1(dtpStartDate) and datetimepicker2(dtpEndDate) as PaymentDate. When I press Search button then data grid view will show the result.

 

Database:

ID	PaymentDate	SuspenceAccount	Name	FatherName	City
1	10 Feb 2017	A	asdf	wer	tgju
2	15 Mar 2017	B	wert	as	dfg
3	20 Mar 2017	B	asdf	hedr	we
4	07 Apr 2017	C	dfh	sdfg	rty

 

 For result: I shall select B from combobox(SuspenceAccount), dtpStartDate(01 Mar 2017), dtpEndDate(31 Mar 2017). When I shall press Search Button then I want to get result in datagridview as:

ID	PaymentDate	SuspenceAccount	Name	FatherName	City
2	15 Mar 2017	B	wert	as	dfg
3	20 Mar 2017	B	asdf	hedr	we

 

I have tried as: 

private void btnSearch_Click(object sender, EventArgs e)

{

con = new OleDbConnection(conString);

string query = "SELECT * FROM LalData WHERE PaymentDate " +

"BETWEEN @startDate AND @endDate" ;

con.Open();

OleDbCommand cmd = new OleDbCommand(query, con);

cmd.Parameters.AddWithValue("@startDate ", DbType.Date).Value =

dtpStartDate.Value.ToShortDateString();

cmd.Parameters.AddWithValue("@endDate ", DbType.Date).Value =

dtpEndDate.Value.ToShortDateString();

adapter = new OleDbDataAdapter(cmd);

adapter.Fill(dt);

dataGridView1.DataSource = dt;

dataGridView1.CurrentCell = dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[0];

con.Close();

}

 

I could not able to use combobox value for searching. Please help me with code or example that I can use combobox value, dtp(Start, End) value for searching database.