hey all
I have my form with a combo box that displays the names of staff members when you drop it down. I want to be able to select the name from the drop down and then click my button and have it return only the records in the DB that have that name in the assigned to field. I have added a data grid view control to the form and want to display the results in that. not really sure how to get it to do this. Any help would be greatly appreciated. I have included the little bit of code I have so far.
CODE
Public Class frmmain
Private Sub NewRecordToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles NewRecordToolStripMenuItem.Click
frmRecord.Show()
End Sub
Private Sub QuitToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles QuitToolStripMenuItem.Click
Environment.Exit(1)
End Sub
Private Sub frmmain_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
'TODO: This line of code loads data into the 'DS_BHIPTrack.DLA_STAFF' table. You can move, or remove it, as needed.
Me.DLA_STAFF_TA.Fill(Me.DS_BHIPTrack.DLA_STAFF)
End Sub
Private Sub Label1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label1.Click
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
End Sub
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
End Sub
End Class
| 