Sorry, John. If I knew what I were doing, I'm probably not be asking for
help.
[quoted text clipped - 15 lines]
2.) How do I tell my query to take what is in my text box and filter by
it?
I've been playing around with VS2008 and VB.Net, and now I can answer your
questions.
If you haven't already done so, create a TableAdapter and a DataSet. Add
your query to the table adapter, leaving a parameter, identified by a
question mark, in the WHERE condition, so that the WHERE clause now looks
like this:
WHERE ([Check_in].[S/N]=?)
If you test that query using the Preview Data option, you should see that
you are prompted for a parameter, and when you fill it in and click the
Preview button, the preview data grid (not the one you've designed) fills in
with the matching records.
Save those changes. Now you need to set up an event of the your text box to
fill the data grid with the results of that query, supplying the value of
the text box to the query. Suppose you use the KeyPress event for this,
only running the query when the user presses the Enter key. Your code might
look something like this:
'----- start of example code -----
Private Sub txtYourTextbox_KeyPress( _
ByVal sender As System.Object, _
ByVal e As System.Windows.Forms.KeyPressEventArgs) _
Handles txtYourTextbox.KeyPress
If e.KeyChar = Chr(13) Then
Try
Me.Check_InTableAdapter.qryFillGrid( _
Me.TestDataSet.Check_In, _
CType(Me.txtYourTextbox.Text, String))
Catch ex As System.Exception
System.Windows.Forms.MessageBox.Show(ex.Message)
End Try
End If
End Sub
'----- end of example code -----
In the above, "txtYourTextbox" is the name of your text box,
"Check_InTableAdapter" is the name of the table adapter, "qryFillGrid" is
the name of the query, "TestDataSet" is the name of the dataset, and
"Check_In" is the name of the Data Table in the dataset.
That works for me. I'm not reallty conversant with the ins and outs of
VB.Net for Windows Forms, so there may be better or easier ways to do it.
