.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Code Snippets >> DataGrid >> Post New Resource Bookmark and Share   

 Subscribe to Code Snippets

GridView with CheckBox for Deleteing the checked Items..

Posted By:susant       Posted Date: November 14, 2008    Points: 10    Category: DataGrid    URL: http://www.dotnetspark.com  
 

Q: How to Create CheckBox inside GriedView and if the User is checked that record how to delete that record from GridView.

1; One gridView

2:  One button checkAll/UncheckAll 

3: One Button for Delete all the Checked CheckBox..


Lets see one by one how can we put checkbox inside GridView

SOURCE FILE:

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

<Columns>

   <asp:BoundField DataField="roll_no" HeaderText="Roll No" />

   <asp:BoundField DataField="s_name" HeaderText="Student Name" />

   <asp:BoundField DataField="class" HeaderText="Class" />

     <asp:TemplateField>

   <ItemTemplate>

       <asp:CheckBox ID="ch1" Text='<%# Eval("roll_no") %>' runat="server" />

     ItemTemplate>

      asp:TemplateField>

Columns>

  asp:GridView>

 

.CS FILE:    In your .cs file in the class level write this line of code

 

ArrayList alist = new ArrayList();

 

    protected void Page_Load(object sender, EventArgs e)

    {

       if (!Page.IsPostBack)

        {

         

        //Populate data and Bind in Gridview

      

       }

   }

//BTN UN-CHECK & Check all

protected void Button2_Click(object sender, EventArgs e)

    {

        //check all and un-checkAll

        if (Button2.Text == "Check All")

        {

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

            {

               CheckBox cbb = (CheckBox)GridView1.Rows[i].FindControl("ch1");              

                cbb.Checked = false; 

            }

            Button2.Text = "Un-Check"; 

        }

        else if (Button2.Text == "Un-Check")

        {

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

            {

             CheckBox check = (CheckBox)GridView1.Rows[i].FindControl("ch1");

                check.Checked = true ;

            }   

             Button2.Text = "Check All";           

        }

    }

//delete btn..here Button1 is your delete button to delete all selected rows inside gridview in your web page

protected void Button1_Click(object sender, EventArgs e)

    {

      

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

            {

                CheckBox cbb;

                cbb = (CheckBox)GridView1.Rows[i].FindControl("ch1");

                if (cbb.Checked == true)

                {

                    alist.Add(i);

                }

            }           

 

            string str = "select * from student";     

            SqlDataAdapter da = new SqlDataAdapter(str,con);

            DataSet ds = new DataSet();       

            da.Fill(ds);

 

        for (int j = 0; j < alist.Count; j++)

        {

            int index = Convert.ToInt32(alist[j]);

            string roll = ds.Tables[0].Rows[index][0].ToString();          

            string qry1 = "delete from student where roll_no='" + roll + "'";

            SqlCommand com1 = new SqlCommand(qry1, con);

            com1.ExecuteNonQuery();

 

        }

        Response.Redirect("default3.aspx");     // Note: re-direct SamePage..

       

    }

 

susant



     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More code samples in C#, ASP.Net, Vb.Net and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend