Combobox add items

Question

0.00/5 (No votes)

See more:

Thank you for answer. Yes, it was my mistake but after changing field name to exact field name as "item Name". Now, it displays syntax error at line dr = cmd.ExecuteReader().
Please help me!!!

VB

cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\panchani\Documents\Visual Studio 2005\Transport.mdb")
cmbName.Items.Clear()
cmd.Connection = cn
cmd.CommandText = "select Item Name from item_master"
cn.Open()
dr = cmd.ExecuteReader()
cmbName.Items.Clear()
While (dr.Read)
    cmbName.Items.Add(dr("Item Name"))
End While

dr.Close()

Posted 1-Jul-10 0:40am

Npanchasara

Updated 3-Jul-10 7:58am

Laxman Auti

v2

Add a Solution

2 solutions

Add a Solution

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

Shining Legend · Answer 1 · 2010-07-01T01:13:00

Solution 1

Please change the following line as follows.

SQL

cmd.CommandText = "select [Item Name] from item_master"

If the columnname of contains a space then it should be in square brackets i.e., [Item Name].

http://dotnetforbeginner.blogspot.com/[^]

Posted 1-Jul-10 1:13am

Shining Legend

Updated 3-Jul-10 4:59am

v2

Comments

William Winner 1-Jul-10 12:28pm

Reason for my vote of 5
yep...definitely the problem!

AnnieMacD · Answer 2 · 2010-07-03T06:32:00

You need to declare the Data Reader as follows:

Dim cn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\panchani\Documents\Visual Studio 2005\Transport.mdb")
        Dim cmd As OleDbCommand = New OleDbCommand
        cmd.Connection = cn
        cmd.CommandText = "select [Item Name] from item_master"
        cn.Open()
        Dim dr As OleDbDataReader = cmd.ExecuteReader()
        cmbName.Items.Clear()
        While (dr.Read)
            cmbName.Items.Add(dr("Item Name"))
        End While
        dr.Close()

Combobox add items

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Combobox add items

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us