I am creating an asp.net website using VB with a Datagrid view that links to a SQL Database. The databse Includes a number column and a description column. I've created a Searchbox that changes the Select Statement of the query of the Datagrid view to show what the user has posted in the textbox, when the user presses the search button.
Dim searchword As String searchword = "select * from Parts where (PartNumber Like '%" + TextBox1.Text.ToString() + "%')" SqlDataSource1.SelectCommand = searchword
This Querys out the table to show only what the user has posted in the text box. What I want to do is change the textbox to a multiline textbox so users can dump multiple numbers into it at once, and get back all matching numbers. How would I go about doing this would it be using this same method?