Loading

about date datatype and mysql query

sachi vasishta

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 id,name, and dateofbirth as

dateofbirth date not null

plz help

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Soniya Wadhwa17y ago
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 !!