Hi ,
am using visual studio 2010 with MS ACCESS ,, wen i try to insert values into the table,, i got this error,,, "No value given for one or more required parameters",,, But actually all fields have the values.. and also Some times it will work without any error,,,
Can anyone help me out Plzzzzzzzzzzzzzzzz,, Its little urgent,,
My Code is :
Dim dr As OleDb.OleDbDataReader
myOleDbConnection = New OleDb.OleDbConnection(c.con())
str = "SELECT Fileno,Name,MobileNo,Site,Division,Date1,Plans,Remarks,Category FROM Report WHERE Division='" & ComboBox1.Text & "'"
Dim cmd As New OleDb.OleDbCommand(str, myOleDbConnection)
myOleDbConnection.Open()
dr = cmd.ExecuteReader()
If dr.HasRows = True Then
While dr.Read()
str1 = "INSERT INTO Rpt1 VALUES('" & dr.Item(0) & "','" & dr.Item(1) & "','" & dr.Item(2) & "','" & dr.Item(3) & "','" & dr.Item(4) & "','" & dr.Item(5) & "'," & dr.Item(6) & ",'" & dr.Item(7) & "','" & dr.Item(8) & "' )"
Dim cmd1 As New OleDb.OleDbCommand(str1, myOleDbConnection)
cmd1.ExecuteNonQuery()
End While
End If
dr.Close()
myOleDbConnection.Close()
Dim obj As New Form18()
obj.Show()
Me.Hide()