know how to get the count of male and females members from the database

In this blog we will know how to get the count of male and females members from the database.

 

 

Table creation

 

Create table employee(empid varchar(50),empname varchar(50),sal int,gender varchar(50))

 

 

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

 

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title>Untitled Page</title>

</head>

<body>

    <form id="form1" runat="server">

    <div>

   

    </div>

    <asp:GridView ID="GridView1" runat="server">

    </asp:GridView>

    <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label><br />

    <asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>

    </form>

</body>

</html>

 

 

 

using System;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

    string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

    SqlCommand com;

    SqlDataAdapter sqlda;

    DataSet ds;

    string str;

    int count;

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            BindGrid();

        }

        male();

        female();

    }

 

    void male()

    {

        SqlConnection con = new SqlConnection(connStr);

        str = "select count(gender) from employee where gender='male'";

        com = new SqlCommand(str, con);

        con.Open();

        count = Convert.ToInt16(com.ExecuteScalar());

        Label1.Text = "No of Males::"+count.ToString();

    }

 

    void female()

    {

        SqlConnection con = new SqlConnection(connStr);

        str = "select count(gender) from employee where gender='female'";

        com = new SqlCommand(str, con);

        con.Open();

        count = Convert.ToInt16(com.ExecuteScalar());

        Label2.Text = "No of Females::"+count.ToString();

    }

 

    void BindGrid()

    {

        SqlConnection con = new SqlConnection(connStr);

        con.Open();

        str = "select * from employee";

        com = new SqlCommand(str, con);

        sqlda = new SqlDataAdapter(com);

        con.Close();

        ds = new DataSet();

        sqlda.Fill(ds, "employee");

        GridView1.DataSource = ds;

        GridView1.DataMember = "employee";

        GridView1.DataBind();

       

    }

}

 

Ebook Download
View all
Learn
View all