Advertisement
Ortund

Untitled

Feb 27th, 2014
179
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 0.58 KB | None | 0 0
  1. txtAearchResult.Text = ""
  2. Dim vSearch As String = InputBox("Enter Integer number to search name:")
  3. If vSearch <> "" Then
  4. cmdOLEDB.CommandText = "SELECT Au_ID, Author FROM Authors WHERE Au_ID= @auid"
  5. cmd.OLEDB.Parameters.AddWithValue("@auid", CInt(vSearch))
  6. cmdOLEDB.Connection = cnnOLEDB
  7.  
  8. Dim rdrOLEDB As OleDbDataReader = cmdOLEDB.ExecuteReader
  9. If rdrOLEDB.HasRows Then
  10.     Do While rdrOLEDB.Read
  11.         txtAearchResult.Text &= rdrOLEDB.Item(0).ToString & " " & rdrOLEDB.Item(1).ToString
  12.     Loop
  13.     rdrOLEDB.Close()
  14. Else
  15.     MsgBox("Record not found")
  16.     Exit Sub
  17. End If
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement