Solved

From ComboBox - Passing value to Database

Posted on 2010-08-27
4
343 Views
Last Modified: 2013-11-27


I need to Pass - ComboBox Text to the Database.

Not the Id .. i need to pass actual value to the database.

Whats the syntax for fetching the value from ComboBox
0
Comment
Question by:chokka
4 Comments
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 33548018
0
 
LVL 17

Expert Comment

by:Zhaolai
ID: 33548114
If you mean the value actually displayed in the combobox, use ComboBox1.Text.
0
 

Expert Comment

by:kimapacible
ID: 33548134
Dim strActualValue as string
strActualValue = ComboBox1.text
0
 
LVL 18

Accepted Solution

by:
John (Yiannis) Toutountzoglou earned 500 total points
ID: 33549417
"If"  Your ComboBox is databound to a datatable you can also define a datarowview....
Dim drv as DataroWview =Ctype(Me.Combobox.SelectedItem,DataRowView)
'And for The Selected Text'

Dim SelText as String=drv.Item("YouColumnTableName")   'And Pass SelText to the Database...

Open in new window

0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question