hello all
i have installed windows 7 operating system.
In this OS i have installed visual studio 2008 and sql server 2005.
when i fire INSERT query with the values name,password and date field.
i am taking date from dateTimePicker ,but it gives error in datatype problem of date in sql server.
i have set datetime datatype for date field.
please help..
the error is about datatype of date field..
and the query is sqlcommand cmd=new sqlcommand("insert into tblLogin values('" + txtUName.Text + "','" + txtPass.Text + "','" + dateTimePicker.Text + "')",con);