Query Returns nothing
<p>I had a datagrid table tblpaymentview and i want to get the values from a database 
i had declared concstring 
and write code as </p>

<pre><code>private void btnsearch_Click(object sender, EventArgs e)
{
  try
  {
    DateTime time = dtpfromDate.Value;
    String query = "Select jobcode,companyName,vehicleno,shipmentdate,totalamount,advance,drivername,fromPlace,destination from jobmastertable  where (shipmentdate='"+time+"')";
    OleDbDataAdapter dAdapter = new OleDbDataAdapter(query, connString);
    DataSet ds = new DataSet();
    dAdapter.Fill(ds);
    tblpaymentview.DataSource = ds.Tables["tblpaymentview"].DefaultView;
  }
  catch (Exception)
  {
    MessageBox.Show("The application had met with some errors please restart  the application :\n error:closer MSAccess files");
  }
}
</code></pre>

<p>Please can anyone help me. I also tried (Datepicker)dtpfromdate.value.toshortdateString() also</p>
