naren7 -1 Newbie Poster

hi everybdy
im using this code for updating this feilds how i store th date value in database using datetimepicker in c#.

"update employemaster set sssnno='"
+txtssnno.Text+"',sinno='"+txtsinno.Text+"',otherid='"+txtotherid.Text+"',smoker_id='"+cmbsmoke.Text+"',driverlicesencenumber='"+txtdvrnumber.Text+"',militaryservice='"+txtmservice.Text+"',nationality_id='"+cmnation.Text+"',dob='"+dtm.Value.Date.ToString()+"',martialstatus_id='"+cmMstatus.Text+"',gender='"+rdgender.Text+"',licenseExpireddate'"+cmbxldat.Value.Date+"',ethnicrace_id='"+cmbethnicrace.Text+"'",con);


--------------------------------------------------------------------------------