?
Solved

From ComboBox - Passing value to Database

Posted on 2010-08-27
4
Medium Priority
?
380 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 48

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 2000 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
SingleRun is a tool that ensures that only one instance of an application is started, running it again brings the application to focus.
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…
Watch the video to know the simple way to remove or recover or reset lost or forgotten passwords of Outlook PST file. With Kernel Outlook Password Recovery tool such operation is very easy to perform. It is a freeware with limitation to use with 500…

589 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