How to insert date from asp page textbox to sql server

[joanseoul]

I have a button within my web page to inserts a few values into sql server columns. One of these values happens to be of data type Date. The following is my code for my asp.net page: \[code\] protected void Button1_Click(object sender, EventArgs e){ con.Open(); SqlCommand cmd1 = new SqlCommand("insert into dbo.FillTable values ('TextBox2.Text', 'TextBox1.Text', 'FA0005')",con); SqlDataAdapter dr = new SqlDataAdapter(cmd1); con.Close(); DataSet dl = new DataSet(); dr.Fill(dl); //Label5.Text = dl.Tables[0].Rows[1][9].ToString();}\[/code\]I want to be able to have the user enter the date in the format (yyyy-MM-dd), which is the date format for my sql server. "TextBox2" is the textbox that holds the date input. Whenever I simply hard code the date as for ex. '2010-01-01', '50', 'FA0005', it works well and inserts the record. However, when I code is as 'TextBox2.Text', 'TextBox1',etc. It gives me an error saying "Conversion failed when converting date and/or time from character string". Can someone help me with this? Its confusing me because having the date in 'yyyy-mm-dd' format works well, which is same as the textbox.