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.
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.