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!

it didn't help me much.... I can't understand what is being done :\ — André Gomes
– André Gomes, Commented Jun 26, 2017 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
– oerkelens, Commented Jun 26, 2017 at 16:47

ISHIDA · Accepted Answer · 2017-06-26 16:50:34Z

0

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();

answered Jun 26, 2017 at 16:50

ISHIDA

4,8882 gold badges18 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related