Kod:
Private Sub button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles button2.Click
Call Suz()
End Sub
Private Sub Suz()
Dim strSQL As String = "SELECT Personel.personelid, yonetimler.yonetim, Personel.tc, " & _
"Personel.adi_soyadi, Personel.dogum_tar, Personel.ise_giris, Personel.statu " & _
"FROM " & _
"(Personel LEFT OUTER JOIN yonetimler ON Personel.yonetim = yonetimler.Kimlik) " & _
"WHERE (Personel.adi_soyadi like '%" & TextBox1.Text & "%') " & _
"AND (yonetimler.yonetim like '%" & IIf(ComboBox1.Text = "Hepsi", "", ComboBox1.Text) & "%' )"
baglanti.Open()
gecici_tablo.Clear()
Dim guc As New OleDbDataAdapter(strSQL, baglanti)
guc.Fill(gecici_tablo, "personel")
dataGridView1.DataSource = gecici_tablo
dataGridView1.DataMember = "personel"
guc.Dispose()
baglanti.Close()
End Sub