insert values from the dropdown list into sql

[meera nandhini]

hi
could you please tell me the command to insert values from the dropdown list into sql using c# coding

[sknake]

The currently selected value, or all values available in the dropdown? You would also need to post your database schema. You can't just write a query to stick data in to SQL Server without knowing where the data is going. Post the code you're using and indicate where you are having problems.

[skmishra1986]

cmd.Parameters.AddWithValue("@ProductName", DropDownListDDL.Text);