title: how to insert date(long format) into access database using datetimepicker in c# ? (error is in date part only)
body: <p><a href="http://i.stack.imgur.com/yKT4k.jpg" rel="nofollow">Error image is here</a><br>
    the error is in query line , its shows syntax error</p>
  
  <p>try 
  {</p>
  
  <pre><code>    string zero = "0";
      DateTime dat = this.dateTimePicker1.Value.Date;
      connection1.Open();
      OleDbCommand command = new OleDbCommand();
      command.Connection = connection1;
      command.CommandText = "insert into client_table(CLIENT, DATE,BILL_AMOUNT, PAID_AMOUNT, BALANCE, CONTACT, ADDRESS )VALUES ('" + txt_client.Text + "', #" + dat.ToLongDateString() + "# ,'" + zero + "','" + zero + "','" + zero + "','" + txt_contact.Text + "','" + txt_address.Text + "')";
  
      command.ExecuteNonQuery();
      connection1.Close();
      MessageBox.Show("New Client Registration done Successfully.");
      connection1.Dispose();
      this.Hide();
      employee_form f1 = new employee_form("");
      f1.ShowDialog();
  }
  </code></pre>
  
  <p>thank you in advance</p>