binding combobox with datatable

Question

4.00/5 (1 vote)

See more:

VB

Private Sub ComboBox1_SelectedIndexChanged(sender As System.Object, e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
        If ComboBox1.SelectedValue.ToString <> "" Then
            ComboBox1.SelectedIndex = 0
        End If
    End Sub

    Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
        con.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\SHAKEE\AppData\Local\Temporary Projects\WindowsApplication1\sponsorship.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"


        Dim ds As New DataSet
        Dim adpt As New SqlDataAdapter
        cmd.CommandType = CommandType.Text
        cmd = New SqlCommand("SELECT name FROM child", con)
        adpt.SelectCommand = cmd
        cmd.Connection = con
        con.Open()
        adpt.Fill(ds, "child")
        con.Close()

        ComboBox1.DisplayMember = "countryname"
        ComboBox1.DataSource = ds.Tables(0).DefaultView



    End Sub
End Class

When I run this code I got a display in comboboxlist as system.data.datarowview

I need to display name.
How can I clear this error?

Posted 4-Jan-14 2:41am

shakeer mp

Updated 4-Jan-14 3:42am

André Kraak

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)

Vidyasagar Machupalli · Answer 1 · 2014-01-04T04:16:00

Solution 2

you are missing the DataTextField & DataValueField properties. As their names suggest, the first one correspond to the Text to show, and the second to the value one.

Posted 4-Jan-14 4:16am

Vidyasagar Machupalli

shakeer mp · Answer 2 · 2014-01-04T05:46:00

Solution 3

i have solved myself error is in

VB

ComboBox1.DisplayMember = "name"

Posted 4-Jan-14 5:46am

shakeer mp

Comments

Nelek 4-Jan-14 13:09pm

I suppose the error was: "countryname" and the solution is "name"

If not... please use the "improve solution" widget and explain it better, it could help other people in the future.

Karthik_Mahalingam 7-Jan-14 1:44am

please close this post by marking it as answer..

Uknownymous · Answer 3 · 2014-01-06T19:27:00

Solution 4

try this:

VB

With ComboBox1
   .DataSource=ds.tables(0).defaultView
   .DisplayMember="name"
   .Valuemember="name"
End With

Posted 6-Jan-14 19:27pm

Uknownymous