hi all,
i have a dropdown list that retrive data from table and i add this drop dwon list to a form.
my question is how to save the data from drop down list into a table in sql server?

do You want to save all content from the drop down or only the selected value from the dropdown?

Om Prakash

i would like to save the selected item from the drop down list only

1. Make use of a SqlCommand object to insert the value from dropdown into DB.
2. Get the choosen value from dropdown make use of "SelectedValue"

For example,

SqlCommand InsertCmd = new SqlCommand("Insert into Table1 values ( @FName," +
         " @City)" ;
InsertCmd .Parameters.Add("@FName",FName.Text);
InsertCmd .Parameters.Add("@City",City.SelectedValue);


Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com