SqlDataAdapter adapter1 = new SqlDataAdapter("select count(id) as SONUC from firmalar INNER JOIN elemanlar ON id= md.firmaID ", baglantim);