Take data from 3 different DropdownList's into an SQL Database

Question

So I'm trying to create the following: I have 3 Dropdowns (one for the day, another for the month and other for the year) and I want to concatenate these three elements on the SQL Database.

Basically, it's a Birthday date I want to save.

Pictures:

Thank you for your help!

Check out this link https://stackoverflow.com/questions/1032495/insert-datetime-value-in-sql-database-with-c-sharp — Matthew Wherry, Jun 26 '17 at 16:23
it didn't help me much.... I can't understand what is being done :\ — André Gomes, Jun 26 '17 at 16:41
If your database wants a DateTime (and I hope it does), simply use `var dateOfBirth = new DateTime(year, month, day);` and insert that into your database. — oerkelens, Jun 26 '17 at 16:47

score 0 · Accepted Answer · answered Jun 26 '17 at 16:50

Get the date and using following snippet to store the value to database.

var date = new DateTime(year, month, date);


        SqlCommand cmd = new SqlCommand("INSERT INTO <table> (<column>) VALUES (@value)", connection);
        cmd.Parameters.AddWithValue("@value", date);

        cmd.ExecuteNonQuery();

Take data from 3 different DropdownList's into an SQL Database

1 Answers1