i want to grab "DataValueField" of dropdownBox and want to use it in INSERT statement , so how ?

i have already filled my Dropdownbox in grid view now want to get DataValueField and using it in insert statement , how ?

Recommended Answers

All 2 Replies

It is simple:

value1 = mydropdown.DataValueField;

and use it in the query:

sqlQuery = "INSERT INTO table_name (column1, column2, column3)
VALUES (" & value1 & ", value2, value3)";

Are you sure you are not asking for the "Selected Value" that is chosen by the user in the dropdown control?

If so, it would be dropdown1.selectedValue

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.