1-) C# - sql veritabanında verilerin istatistiklerini alma

 baglanti.Open();

            SqlCommand komut1 = new SqlCommand("Select count(*) From Tbl_Personel", baglanti);

            SqlDataReader sqlDataReader = komut1.ExecuteReader();

            while (sqlDataReader.Read())

            {

                lbltoplampersonel.Text = sqlDataReader[0].ToString();

            }

            baglanti.Close();

            //evli personel sayısı

            baglanti.Open();

            SqlCommand komut2 = new SqlCommand("Select Count(*) From Tbl_Personel where PerDurum=0",baglanti);

            SqlDataReader sqlDataReader1 = komut2.ExecuteReader();

            while (sqlDataReader1.Read())

            {

                lblbekarpersonel.Text = sqlDataReader1[0].ToString();

            }            

            baglanti.Close();

            //evli personel sayısı

            baglanti.Open();

            SqlCommand komut3 = new SqlCommand("Select Count(*) From Tbl_Personel Where Perdurum=1", baglanti);

            SqlDataReader sqlDataReader2 = komut3.ExecuteReader();

            while (sqlDataReader2.Read())

            {

                lblevlipersonel.Text = sqlDataReader2[0].ToString();

            }

            baglanti.Close();

            //şehir sayısı  distinct kullanımı

            baglanti.Open();

            SqlCommand komut4 = new SqlCommand("Select Count(Distinct(PerSehir)) From Tbl_personel", baglanti);

            SqlDataReader sqlDataReader3 = komut4.ExecuteReader();

            while (sqlDataReader3.Read())

            {

                lblsehırsayısı.Text = sqlDataReader3[0].ToString();

            }

            baglanti.Close();

            //toplam maaş sum kullanımı

            baglanti.Open();

            SqlCommand komut5 = new SqlCommand("select Sum(Permaas) from Tbl_Personel", baglanti);

            SqlDataReader sqlDataReader4 = komut5.ExecuteReader();

            while (sqlDataReader4.Read())

            {

                lbltoplammas.Text = sqlDataReader4[0].ToString();

            }

            baglanti.Close();

            //ortalama maaş avg kullanımı

            baglanti.Open();

            SqlCommand komut6 = new SqlCommand("Select Avg(PerMaas) From Tbl_Personel", baglanti);

            SqlDataReader sqlDataReader5 = komut6.ExecuteReader();

            while (sqlDataReader5.Read())

            {

                lblortlamamaas.Text = sqlDataReader5[0].ToString();

            }

            baglanti.Close();