Populate Unbound Data Grid View via Text Box values

[mcupito]

I am trying to populate a data grid view based off of two text boxes, Start date and End date.

I am not sure how to work with DataGridViews or DataSets.
So if textbox1.text = x/x/2013 and textbox2.text = y/y/2014, then clicking a button will filter the records and display only those records with corresponding date values in the data grid view.

The biggest part I am struggling with is getting the records via search button. Here's what I have so far:

                Dim SQLConnection As New SqlConnection("Data Source=SQLTEST_HR,4000\SQLEXPRESS;Integrated Security=True")
        Dim SqlCommand As New SqlCommand
        Dim SQLReader As SqlDataReader
        Dim dt As New DataTable
 
        'Dim SqlCommand As New SqlCommand("Select * FROM PARTICIPANT WHERE FIRST_NM_TXT = " & Trim(SearchFirsttxt.Text) & "'", SQLConnection)
 
        SqlCommand.Connection = SQLConnection
        SQLConnection.Open()
        SqlCommand.CommandText = "Select * FROM PARTICIPANT WHERE FIRST_NM_TXT = '" & Trim(SearchFirsttxt.Text) & "' and LAST_NM_TXT = '" & SearchLastTxt.Text & "'"
        Dim myAdapter As New SqlDataAdapter(SqlCommand)
        myAdapter.Fill(dt)
        DataGridView1.DataSource(dt)
 
        SQLConnection.Close()

Any ideas on what should follow?

Thanks

[mcupito]

I figured it out. Here is my solution for anyone wondering how to do the same thing.

        Dim SQLConnection As New SqlConnection("Your Connection String Here")
        Dim SqlCommand As New SqlCommand
        'Dim SQLReader As SqlDataReader
        Dim dt As New DataTable
 
        SQLConnection.Open() 'Opens database Connection
        SqlCommand.Connection = SQLConnection 'Assigns command to the connection
        SqlCommand.CommandText = "Select * FROM PARTICIPANT WHERE FIRST_NM_TXT = '" & SearchFirsttxt.Text & "' and LAST_NM_TXT = '" & SearchLastTxt.Text & "';"
        'SQL Command returns rows where values in database and textboxes are equal
        Dim myAdapter As New SqlDataAdapter(SqlCommand) 'holds the data
        myAdapter.Fill(dt) 'datatable that is populated into the holder (DataAdapter)
        DataGridView1.DataSource = dt 'Assigns source of information to the gridview (DataTable)
        SQLConnection.Close() 'Closes Connection for security measures