Have a problem with asp... please advice

Is it a SQL exception.If yes,what is the datatype of the column PROB_DATE ?
Also try using Calendar1.SelectedDate.ToString instead of Calendar1.SelectedDate.

Vikram

DiscountASP.NET
www.DiscountASP.NET

 

Hi All,


I have a problem in taking and inserting the Date of a Calndar object in the database:

Whenever I execute the following scripy I get "not a valid month"



uatSupportSource4x.InsertCommand = "INSERT INTO SUPPORT(TESTER_NAME, ACTIVITY, PROBLEM, SOLUTION, RELATED_EXCEPTION, PROB_DATE) VALUES ('" + TextBox1.Text + "', '" + DropDownList1.SelectedItem.Value.ToString + "', '" + TextBox2.Text + "' , '" + TextBox3.Text + "', '" + TextBox4.Text + "', '" + Calendar1.SelectedDate + "')"


Please assist,


Mahdi