Odtnhj

I am creating a program that uses a table of karate members from a database that allows the user to select a date from a DateTimePicker control. The program displays the first name, last name, phone #'s and dates joined of all members who joined before the selected date. I need to use a a parameterized query to retrieve the matching table rows and display them in a DataGridView Control. After that, I need add radio button that allows the user to choose before this date or on or after this date.

So far, I created the DateTimePicker control from Dates_Joined in the members data set and included the data grid view. I then added two radio buttons from the Dates_Joined in the members data set, and tried creating a query for each. It is not working properly for getting the filtered rows after specifying the date from the picker and then clicking on either the before or on or after this date radio button.

Public Class Form1
 Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
 'TODO: This line of code loads data into the 'KarateDataSet.Members' table. You can move, or remove it, as needed.
 Me.MembersTableAdapter.Fill(Me.KarateDataSet.Members)

 End Sub

 Private Sub BeforeToolStripButton_Click(sender As Object, e As EventArgs) Handles BeforeToolStripButton.Click
 Try
 Me.MembersTableAdapter.Before(Me.KarateDataSet.Members, New System.Nullable(Of Date)(CType(Date_JoinedToolStripTextBox.Text, Date)))
 Catch ex As System.Exception
 System.Windows.Forms.MessageBox.Show(ex.Message)
 End Try

 End Sub

 Private Sub FillByToolStripButton_Click(sender As Object, e As EventArgs) Handles FillByToolStripButton.Click
 Try
 Me.MembersTableAdapter.FillBy(Me.KarateDataSet.Members, New System.Nullable(Of Date)(CType(Date_JoinedToolStripTextBox1.Text, Date)))
 Catch ex As System.Exception
 System.Windows.Forms.MessageBox.Show(ex.Message)
 End Try

 End Sub
End Class