[zoe]

Private Sub Search_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Search.Click
		'The OleDbDataReader is a forward-only data reader used for speed and efficiency.
		Dim SQLReader As OleDbDataReader
		'Dim Searchstr As String = ""
		Dim Searchstr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\NRaqa\Desktop\TestD.mdb"
		Dim conn As OleDbConnection

		conn = New OleDbConnection(Searchstr)

		Dim query As String = "Select NAME FROM KonkeQuery where NAME like '%storename.text%'"

		Dim command As New OleDbCommand(query, conn)

		If storename.Text = "" Then
			MsgBox("Please Enter Strore name", MsgBoxStyle.Exclamation)
			Exit Sub
		Else
			conn.Open()
			SQLReader = command.ExecuteReader()


			If SQLReader.HasRows Then
				While SQLReader.Read

					storename.Text = SQLReader.Item(query)
				End While
			Else
				MsgBox("There were no matches found, please try again", MsgBoxStyle.Information)
			End If

			conn.Close()
		End If


	End Sub

I'm trying to select a query on the database where by it uses like ie. '%storename.text%.. i want it to display all the storenames with the entered data so that i can select which eva 1 i want

Thanks in advance

Regards
Noks

[Amadeus]

Can you describe the problem you are encountering? Is it generating an error message?

[tody4me]

Looks like you are trying to grab the data, and put the last one found into the text box. Is this correct? If not, are you wanting to maybe add the values to a drop down box or display in a data grid? You may end up getting an error when you are retrieving the data because when you get the data back, you should be retrieving the data from the index of the column number that you want (in this case 0, there is only one field being returned, so column (or field) 0 would be the only valid one) instead of using the query string again.

[Jayman]

You need to concatenate the information form your textbox into the SQL statement.

Dim query As String = "Select NAME FROM KonkeQuery where NAME like '%" & storename.text & "%'"

[zoe]

Thanks guys (u've been a huge help).. the problem has been solved... Now i wanna mark dis issue as done & don't know how to... Anyhelp on that pls

Regards
Noks

[Jayman]

You just did it. Leave the posts as they are so that other members can benefit from your solution if they are having a similar problem.

Glad you were able to resolve the problem.