Filling a combobox with data from a stored procedure!

Question

0.00/5 (No votes)

See more:

VB

<pre lang="vb">

I have a stored procedure that I mus fill in the combobox!
The procedure contains "SELECT ID, name from TblData" and below I will post my codei've done so far!
And I would like someone to help me continue :S Ehere is my error

VB

Dim n As New KonekcijaBaza
       Dim con As New SqlConnection
       con = n.GetCon()

       Dim cmd As New SqlCommand
       cmd.CommandText = "[AP245_IsplatniListi].[PolniComboDirekcii]"
       cmd.CommandType = CommandType.StoredProcedure


       Dim da As New SqlDataAdapter
       Dim ds As New DataSet

       da.SelectCommand = cmd
       da.Fill(ds)

and in teh foram load I have

VB

Dim dbl As New DBLevel
       Dim dv As New DataView
       dv = dbl.PolniCombodirekcija().Tables(0).DefaultView

       cmbDirekci.DisplayMemberPath = "direkcija""
       cmbDirekci.SelectedValue = "sifra_direkcija""

Posted 3-Jun-13 21:12pm

Voley

Updated 4-Jun-13 0:03am

v2

Add a Solution

1 solution

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)

Pheonyx · Answer 1 · 2013-06-03T21:19:00

The simplest solution is to set the ItemsSource on the combo box equal to the the data table you have just filled. Then define the DisplayMemberPath and SelectedValuePath properties as the names of the columns you wish to A) be the display member and b) be the selected value.

Alternatively (and my preferred approach), is to create a Class of your object type, then populate a collection of of your objects based on the results in the dataset. then use the object collection to populate the combo box.

However, that is generally because I am doing various things with the object that gets selected in my combo boxes.