DropDown List

Question

User-1499457942 posted

Hi

 I have below code . I want to save dropdown value in Database . DataValue Field DataType is int

ddl_Category.DataTextField = "Description";
ddl_Category.DataValueField = "No";

Thanks

Answer 1

User2103319870 posted

I want to save dropdown value in Database . DataValue Field DataType is int

You can use Dropdownlist SelectedItem property to get the selected value from dropdownlist

DropDownList1.SelectedItem.Value

To save the value in database, you just need to add the value to command property like below

//Add the value from dropdownlist to parameter
cmd.Parameters.AddWithValue("@YourParameter", Convert.ToInt32(DropDownList1.SelectedItem.Value));
//Your code to save value in database

Answer 2

User475983607 posted

 I have below code . I want to save dropdown value in Database . DataValue Field DataType is int

ddl_Category.DataTextField = "Description";
ddl_Category.DataValueField = "No";

I'm a bit confused... Clearly in other posts you have saved data in a table.  Why are you having an issue at this time?  

Is the problem that the field named "No" is not an integer?  Are you receiving an error?  Can you post the code that is causing the problem?  Lastly, and most importantly please describe in detail the troubleshooting steps you have performed up to this point.