I have the following code:-
SQL = "Select * from Locations"
Dim da As New SqlClient.SqlDataAdapter(SQL, oConn)
da.Fill(ds, "Locations") ' populate data set "da" with the data returned from sql command "ds" and set dataset name to "Rigs"
DataGridView1.DataSource = ds.Tables("Locations")
Basically it returns 3 columns - locationID, Stock_Location and Location_Description and places the retrieved data into a datatable. I am trying to find out how I can check if the string in textbox1.text is already in the column Stock_Location please in the datatable