üç farklı Datagridview İlk datagridview ıdsıne tıklayınca diğer iki datagridview o Id göre bilgi getirme
private void Form1_Load(object sender, EventArgs e)
{
SqlDataAdapter adapter=new SqlDataAdapter("Select ID from OKUL",bag);
DataSet ds=new DataSet();
adapter.Fill(ds);
dataGridView1.DataSource=ds.Tables[0];
}
int ID;
private void dataGridView1_DoubleClick(object sender, EventArgs e)
{
SqlDataAdapter adapter=new SqlDataAdapter("Select AdSoyad,Memleket from OKUL where ID='"+ dataGridView1.SelectedCells[0].Value.ToString()+"'",bag);
DataSet ds=new DataSet();
adapter.Fill(ds);
dataGridView2.DataSource=ds.Tables[0];
SqlDataAdapter adapter2= new SqlDataAdapter("Select OKUL,DERS from OKUL where ID='" + dataGridView1.SelectedCells[0].Value.ToString() + "'", bag);
DataSet ds2 = new DataSet();
adapter2.Fill(ds2);
dataGridView3.DataSource = ds2.Tables[0];
}
Yorum Gönder