i am using ajax calender extender
here is my html code
<cc1:CalendarExtender ID="txt_student_birthdate_CalendarExtender"
runat="server" Enabled="True" Format="dd/MM/yyyy"
TargetControlID="txt_student_birthdate">
</cc1:CalendarExtender>
here is code
a.filldata("insert into student_registration_table values('" + txt_student_id.Text + "','" + txt_student_firstname.Text + "' , '" + txt_student_middlename.Text + "' , '" + txt_student_lastname.Text + "', '" + txt_student_address.Text + "' , '" + txt_student_city.Text + "', '" + txt_student_gender.SelectedValue + "' , '" + txt_student_emailid.Text + "' , '" + txt_student_landline.Text + "' , '" + txt_student_mobileno.Text + "' , '" + Convert.ToDateTime(txt_student_registrationdate.Text)+ "' , '" + Convert.ToDateTime(txt_student_birthdate.Text)+ "' , '" + txt_student_batch.SelectedValue + "' , '" + student_photo_path + "' , '" + txt_student_isactive.SelectedValue + "' ) ");
when i am entring date between 2009-2010 it will work perfactly.
but when i am entering date between 1980-90 it will show following error.
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.