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.
]. 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
event of your
. Combining that with the Method used in the example linked to above, in the event handler
private void myTextBox_Leave(object sender, EventArgs e)
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. :)