about date datatype and mysql query

Question

Hi I have a winform which contains three comboboxes respectively for mm dd yyyy how can i store these three comboboxe values into a single variable in c# and later insert that variable into the mysql database. In Mysql db i have a table called info with the fields idname and dateofbirth as dateofbirth date not null plz help

Soniya Wadhwa · Answer

i think this is what u are looking for http://www.fontstuff.com/access/acctut13a.htm http://www.fontstuff.com/access/acctut13b.htm once u get the date(month day  year) save it in a string Eg: dobDate and // passing to MYSQL dataset1.SelectParameters.Add( DOBDate  TypeCode.DateTime dobDate ) hope this helps !!