Member Avatar for HunainHafeez

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 ?

  • 3 Contributors
  • 2 Replies
  • 206 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by JorgeM
Member Avatar for spectra

It is simple:

value1 = mydropdown.DataValueField;

and use it in the query:

sqlQuery = "INSERT INTO table_name (column1, column2, column3)
VALUES (" & value1 & ", value2, value3)";
Edited by spectra because: code use
Member Avatar for JorgeM

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.