SQL Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am running the following SQL query:

OleDbDataAdapter.SelectCommand.CommandText = "SELECT * FROM Locations WHERE LOCATION_ID= '" & editLOCATION_ID.Text & "'

Does anyone know how to display the result of this query in a textbox? Could you please provide an example or details

Thanks in advance
 
Create a datareade

Dim MyReader As OleDbDataReader = MyCommand.ExecuteReader(

MyReader.Rea
tempstr1 = MyReader("Field name in DB").ToStrin
textbox.text = tempstr

Hope this helps.
 
Back
Top