{
tools.conn.Open();
DataTable dt = new DataTable ();
if (txt_Aranan_Kelime.Text.Trim() == "")
{
dt.Clear();
SqlDataAdapter adp = new SqlDataAdapter ("Select * From Uyeler", tools.conn);
adp.Fill(dt);
dataGridView1.DataSource = dt;
}
else
{
SqlDataAdapter adp = new SqlDataAdapter ("Select * From Uyeler Where KullaniciAdi Like'%" + txt_Aranan_Kelime.Text + "%' or Telefon Like '%" + txt_Aranan_Kelime.Text+ "%'", tools.conn);
dataGridView1.DataSource = dt;
}
tools.conn.Close();
}
Hiç yorum yok:
Yorum Gönder