title: How to convert DateTimepicker value to date datatype?
body: <p>My database is:</p>
  
  <pre><code>create table bus
  ( bus_no varchar(10),
    jdate date,
    source varchar(20),
    destination varchar(20),
    departtime varchar(10),
    primary key(bus_no,jdate));
  </code></pre>
  
  <p>C#</p>
  
  <pre><code>c.connect();
  comm = new OracleCommand(); /*Class OracleCommand  represents an SQL statement or stored procedure to execute against a database. OracleCommand() initializes a new instance of the OracleCommand. */
  comm.Connection = c.conn;
  //Console.Write(dateTimePicker1.Value.ToShortDateString());
  comm.CommandText = "INSERT INTO bus VALUES ('" + busno.Text + "','" + dateTimePicker1.Value.ToShortDateString() + "','" + source.Text + "','" + destination.Text + "','" + departtime.Text + "')";
  comm.CommandType = CommandType.Text;
  MessageBox.Show("Bus Added");
  comm.ExecuteNonQuery();
  c.conn.Close();
  </code></pre>
  
  <p>It's showing error as month is not recognized. Please help. </p>