populate ComboBox from DataSet or DataReader with a default value in ComboBox

Question

0.00/5 (No votes)

See more:

, +

Out of no help in Google, I came here to ask this.

I have a table named Agent with columns AgentId and AgentName in Sql Server DB. Using Visual Studio 2008(VB.NET), I am developing a windows based app. I have a ComboBox control in a windows form. I need this ComboBox control to be filled with the Agent Table. I used the following code, but still am not able to set "Select Agent" as the default selected value.

VB

ComboBox.DataSource = DataSet1.Tables(0)
ComboBox.DisplayMember = "AgentName"
ComboBox.ValueMember = "AgentId"

When I add "Select Agent" using,

VB

ComboBox.Items.Add("Select Agent")

, I get the Error, "Items collection cannot be modified when the DataSource property is set."

Any help is highly appreciated. Thanks!

Posted 31-Oct-13 1:10am

arunrk87

Updated 31-Oct-13 1:11am

v2

Add a Solution

3 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)

prashant patil 4987 · Answer 1 · 2013-10-31T01:19:00

Solution 1

try below:

C#

ComboBox.Items.Add("Select Agent")
ComboBox.DataSource = DataSet1.Tables(0)
ComboBox.DisplayMember = "AgentName"
ComboBox.ValueMember = "AgentId"
ComboBox.DataBind() // Add This Line into Your Code

ComboBox.SelectedValue = "Select Agent"

Posted 31-Oct-13 1:19am

prashant patil 4987

Comments

arunrk87 11-Nov-13 3:17am

I dont get the DataBind() keyword. Because it is VB.NET?

prashant patil 4987 12-Nov-13 5:54am

ok lets refer below link
http://vb.net-informations.com/dataset/bind-combobox.htm

arunrk87 18-Nov-13 7:57am

but Prashant, ders no idea about DataBind() or default ComboBox value in the link you posted

prashant patil 4987 · Answer 2 · 2013-11-11T23:55:00

Solution 2

Refer below link
http://code.msdn.microsoft.com/windowsdesktop/ComboBox-Databinding-ab61d9d5[^]

Posted 11-Nov-13 23:55pm

prashant patil 4987

Comments

arunrk87 18-Nov-13 8:05am

no dis dint help out...

arunrk87 · Answer 3 · 2013-11-20T20:12:00

Solution 4

Got it! check the link below

http://stackoverflow.com/a/14868976/194276

Posted 20-Nov-13 20:12pm

arunrk87