ComboBox add item

See more:

VB

Hie!

I am trying to add item in combobox at runtime from database for that i am writing the following code :

Dim cn As OleDbConnection
Dim cmd As System.Data.OleDb.OleDbCommand
Dim da As OleDbDataAdapter
Dim dr As Data.OleDb.OleDbDataReader
Dim str As String
Dim icount As Integer
Dim ds As DataSet


in form_laod event


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 nature_of_good from item_master"
cn.Open()
dr = cmd.ExecuteReader()
cmbName.Items.Clear()
While (dr.Read)
cmbName.Items.Add(dr("name"))
End While

dr.Close()



but when i run this form it will dispaly error on line

dr=cmd.Excutereader()

Error : NO Value is given for one or more parameters

Please Help Me !..................Thank you