problem saving date to mysql from asp.net
<p>I m trying to save the date to <em>mysql</em> from <em>jquery</em> *DatePicker* from <em>C#</em></p>

<pre><code>string datetime = txtDate.Text + " " + time;//05/11/2011 5:30 pm                    

string getSQL1 = 
   "INSERT into tblconcertdetail 
   (Address, City, Pincode, Country, Concert_Date) 
   VALUES ('" + addr + "','" + txtCCity.Text + "','" + txtCpincode.Text + "','" +
   ddlCCountry.SelectedItem.Text + "','" + Convert.DateTime(datetime) + "')";
</code></pre>

<p>Here <code>getsql1</code> shows me the date field filled but in database it stores <em>0000-00-00 00:00</em> value.
I m not getting why it is so.</p>

<p>I also try <code>convert.ToString(datetime)</code> to.</p>
