Getting values from an entire Collumn to a ComboBox

Question

0.00/5 (No votes)

See more:

Hi, im trying to fill a ComboBox with an entire Collumn from my database but I don't want it to do with a DataSet or something like that. I want it via Code

Can someone plz help
Don't know what to do

VB

 Dim combo As ComboBox
        combo = frmRD.cboNomCoop
frmRD.cboNomCoop.Items.Add("")

Posted 11-Apr-13 8:19am

TesterJSR

Updated 11-Apr-13 8:43am

Richard C Bishop

v3

Add a Solution

Comments

Richard C Bishop 11-Apr-13 14:22pm

DataSet is used in coding. It is just a collection(or an in-memory cache according to MSDN) of data retrieved from a datasource. DataTable is a table of retrieved data. How else are you going to get data?

Maciej Los 11-Apr-13 16:15pm

Why don't you put it as an answer?

Richard C Bishop 11-Apr-13 16:33pm

Well, I asked a question in my comment and did not want it to be misconstrued as abuse.

Maciej Los 11-Apr-13 16:44pm

Abuse? No, it's not abuse. It's very good answer and i uses your comment in my solution. I hope you're not angry for me...

Richard C Bishop 11-Apr-13 16:46pm

No worries, just as long as the information is out there.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2013-04-11T10:19:00

TesterJSR wrote:
im trying to fill a ComboBox with an entire Collumn from my database but I don't want it to do with a DataSet or something like that. I want it via Code

It's not work like that! Why? See Ryan comment.

richcb wrote:

DataSet is used in coding. It is just a collection(or an in-memory cache according to MSDN) of data retrieved from a datasource. DataTable is a table of retrieved data. How else are you going to get data?

beker_usa · Answer 2 · 2013-04-11T08:30:00

I d go with

Create A DataTable

VB

for each rows as Datarow in Gridview1.Datarow
Dim cValue as String=ctype(rows,"LabelorTextbox",textbox).text \\you are getting the cell value here

\\insert the value to your created Datatable here


Next


combobox.datasource=your created datatable
combobox.displaymember=your datatable column name or id 
combobox.valuemember=your datatable value column name or id 
combobox.databind

This code has not been tested but the logic tested in my own applications million times ;) i hope it helps you.

Getting values from an entire Collumn to a ComboBox

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0