title: how to insert a date from textbox to database
body: <p>please help me to insert a date from a text box in dd-mm-yyyy format to sql server.
  my code is as follows:-</p>
  
  <pre><code>        int prio = Convert.ToInt32(Priority.Text);
          string stdate = planstart.Text;
          string endate= planend.Text;
  
          string actst = actualstart.Text;
          string acten = actualend.Text;
  
  
  
              SqlConnection myconnection = new SqlConnection(constring);
              SqlCommand mycommand = new SqlCommand();
              DataSet mydataset = new DataSet();
              SqlDataAdapter mydataadapter = new SqlDataAdapter();
  
              myconnection.Open();
              mycommand.Connection = myconnection;
              mycommand.CommandText = " insert into project_status.dbo.Project_Status_Report values('" + projectcode.Text + "','" + projectname.Text + "',(select P_Code from project_status.dbo.Project_Type where Project_Type = '" + projecttype.Text + "')," + prio + ",'" + stdate + "','" + endate + "','" + actst + "','" + acten + "','" + currentstatus.Text + "','" + remark.Text + "','no');";
  
              mycommand.CommandType = CommandType.Text;
              mycommand.ExecuteNonQuery();
  </code></pre>
  
  <p>and it is throwing an exception saying:-
  Conversion failed when converting date and/or time from character string.</p>