title: How to add date in dd/MM/yyyy to mysql in asp.net?
body: <p>I've used an ajax calendarExtender tool and set Format to dd/MM/yyyy while inserting the date 21/12/2013 to mysql its giving error </p>
  
  <pre><code>MySqlConnection conn = new MySqlConnection(cnnstring);
  
  string cmdText = "INSERT INTO trydate(Dob) VALUES ('" + TextBox1.Text + "')";
  
  MySqlCommand cmd = new MySqlCommand(cmdText, conn);
  conn.Open();
  int a = cmd.ExecuteNonQuery();
  Label1.Text = "Data Saved";
  TextBox1.Text = "";
  </code></pre>
  
  <p>please help me to overcome from this.</p>