search mysql database with textbox in asp.net

[rajsrmc]

Hello pals
i have connected mysql table in gridview, how to do search by using the particular word from the text box and suggest any ways to get the result in grid view
Please send some pseudocodes(vb codes)
any sorts of help will be really useful
Thanks in advance

[Frinavale]

This is a SQL question, not a VB question. What you need to do is retrieve the text entered by the user from the TextBox and then use that in the WHERE part of your SQL query.

Check out this article on the SqlCommand.Para meters Property...

For example (please note that this code is just an example....it will Not work without modification and some additional code):

Dim connectionStr As String = "....the connectionString..."
Dim sqlCommandText As String = "SELECT * FROM my_table WHERE the_table_id = @theValue"

Dim command As New SqlCommand(sqlCommandText, connectionStr)

command.Parameters.Add("@theValue", SqlDbType.Int)
command.Parameters("@theValue").Value = myTextBox.Text

-Frinny

[tlhintoq]

Database How-to parts 1 and 2
Database tutorial Part 1
Database tutorial Part 2