Gridview Checkbox event handling

Note:  The code below will help to understand gridview checkbox field event handling operations like check-uncheck single row and check-uncheck all (header row).

1.       For adding checkbox field in gridview (gridUsser) we are using template field as follows :

<asp:TemplateField>

       <HeaderTemplate>

<asp:CheckBox ID="chkHeader" runat="server" OnCheckedChanged="chkHeader_CheckedChanged" AutoPostBack="true" />

       </HeaderTemplate>

       <ItemTemplate>

<asp:CheckBox ID="chkData" runat="server" OnCheckedChanged="chkData_CheckedChanged" AutoPostBack="true" />

       </ItemTemplate>

</asp:TemplateField>

2.        For individual rows checked – unchecked events following code is used

 

    protected void chkData_CheckedChanged(object sender, EventArgs e)

    {

        //check/uncheck specific

        CheckBox chb = (CheckBox)sender;

        if (chb.Checked == true)

       {

//code here

       }

        else

        {

           //code here

        }

    }

 

 

3.       For All row checked – unchecked operation following code is used

 

protected void chkHeader_CheckedChanged(object sender, EventArgs e)

    {

        //check/uncheck all

 

        CheckBox chbAll = (CheckBox)sender;

        if (chbAll.Checked == true)

        {

            for (int i = 0; i < gridUsser.Rows.Count; i++)

            {

                try

                {

                    CheckBox cb = (CheckBox)gridUsser.Rows[i].Cells[0].Controls[1];

                    cb.Checked = true;

                  

                    //Code here;

                }

                catch (Exception)

                {

  
                    //throw;

                }

            }

           

        }

        else

        {

            for (int i = 0; i < gridUsser.Rows.Count; i++)

            {

                try

                {

                    CheckBox cb = (CheckBox)gridUsser.Rows[i].Cells[0].Controls[1];

                    cb.Checked = false;

                   

                    //throw;

                }

                catch (Exception)

                {

                    //throw;

                }

            }

        }    

    }

 

Connection String Example

Connection String

ASP.NET, SQL Server

1.      Assuming we have a database “Test” on SQL Server and we have to access data from this “Test” database to our ASP.NET website. For this we need a connection between database and our website.

2.      So to access data to/from database (SQL SERVER) we need, connection string to the database.

3.      All database connection properties can be provided in web.config file as follows :

 

<connectionStrings>

<add providerName="System.Data.SqlClient" name="dbConnect"

connectionString="Initial Catalog=Test;

Server=ComputerName\SQLSEVER;

Pooling=Yes;

Integrated Security=True;"/>   

    </connectionStrings>

 

Details:

providerName : name of the data provider for data connection

name : name given to the connection string for accessing in code

connectionString

Initial Catalog=name of the database

Server=Machine name\SQL server ;

Pooling=Yes; (when a new connection is requested by application, if connection is present in pool use it instead of creating new one. Max Pool Size/Min Pool Size can be set i.e. maximum / minimum connections allowed in a Pool)

Integrated Security=True (Windows Authentication)

                                 False (SQL Authentication) 

4.      To access this connection string from our code, we write following :

string  connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["dbConnect"].ConnectionString;

 

5.      Complete sample Code to access data :

using System.Data.SqlClient;

using System.Data;

 

public class clsConnect

{

    //Variable Declarations

    string connectionString = "";

    DataSet ds;

      public clsConnect()

      {

        connectionString = System.Configuration.ConfigurationManager.ConnectionStrings  

                                       ["dbConnect"].ConnectionString;

      }

    public DataSet getUserData()

    {

        ds = new DataSet();

        try

        {

            SqlConnection con=new SqlConnection(connectionString);

            con.Open();

            SqlDataAdapter da = new SqlDataAdapter("select * from [dbo].[tbl]", con);

            da.Fill(ds);

            con.Close();

        }

        catch (Exception ex)

        {

                  throw;

 

  }

        return ds;   

    }

}

 

We can use this dataset data to perform several data operations.