How to Filter a Datagrid in VB 2010

OK, I'm pretty new at this and I don't need anything complex. I'm trying to take small steps. I have a query built that works when I hard code data in it. I would like more flexibility so I created a toolstrip with a textbox for the query. If I could just find out how to write the SQL so it can run the query based on the string in the toolstrip textbox, that would do nicely, I think. I just don't know how to make the SQL look in the toolstrip textbox for the string to search for in the SQL builder.

After your latest post:

What you need is called a Parameterized Query.

Which is basically the query you currently use but with a special marker in place of the changeable data. The marker gets replaced with whatever the user types into the textbox.

An example[^]. I don't think that this is the best example out there, it is simply the first hit on google from a search on parameterized queries vb.net.

One way to use this would be to hook up to the Leave event of your TextBox. Combining that with the Method used in the example linked to above, in the event handler

private void myTextBox_Leave(object sender, EventArgs e)
{
    ' obviously for your situation you would only need one string here
    DisplayPersonData(myTextBox.Text, someotherstring)
}

If you have problems understanding the link above then please search for yourself. There are loads of good examples out there.

Good Luck. :)

If you need more help, rather than add an answer, click on the 'Add Comment' widget at the bottom of this answer. That way I'll get notified (as it is I only found your second point by accident). Or if you would rather have someone else, start a new question and link to this one. :)