Mar 18, 2011
I have written a code which adds some information to a database. No problem with that since the records get inside the database. My problem is that the record I added always shows up on my Search. I tried changing the variables so that none will have the same names between the two forms but it still shows.Example:
View 2 Replies
1. I added a record of a book which has an id of 1, name of Cisco, and total of 50. I added it thru the debug function.
2. I added a record of a book which has an id of 2, name of Link, and total of 30. This time, I added it directly on the database file itself.
2. I created a search button which will show records depending on the input of the user.If I type "1" for the ID, the first record will appear on the datagrid. If I type "2" for the ID, both records will appear. If I type "3" which I doesn't have any record with, the FIRST record will still appear. To summarize it, the record that I added through the program itself will always show up on the query results, no matter what I type into.
Dim command As New OleDb.OleDbCommand
Dim adapter2 As New OleDb.OleDbDataAdapter
Dim bkId, bkTtl As Integer