Dim connectionString As String
Dim cnn As OleDbConnection
Dim cmd As OleDbCommand
Dim sql As String
connectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = d:\sprrg\scm\scm\sprrg.mdb"
sql = "insert into mr_detail select job_Code,mr_no,item_code,qty,addl_description"
cnn = New OleDbConnection(connectionString)
cnn.Open()
cmd = New OleDbCommand(sql, cnn)
cmd.ExecuteNonQuery()
cmd.Dispose()
cnn.Close()
I am getting eror as No value given for one or more required parameters in the line cmd.ExecureNonQuery().
Kindly advice...