Yazı Font Küçült Yazı Font Büyült

GridView da Seçili CheckBox Sütun Değerlerini Toplamak

 

Merhaba arkadaşlar bu makalemizde GridView nesnesine CheckBox ekleyeceğiz. Bu örnekte seçili  CheckBox ın bulunduğu Fiyat sütunundaki değerleri toplayacağız. Projenize GridView, Label ve Button ekleyin.

 

 

Screenshot

Resim1 

Şekil 1

Default.aspx.cs

using System;

using System.Collections.Generic;

using System.Data;

using System.Data.SqlClient;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

 

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

{

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            bindList();

        }

 

    }

 

    protected void bindList()

    {

 

        SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\kategori.mdf;Integrated Security=True");

        {

            con.Open();

            SqlCommand cmd = new SqlCommand("select * from [dbo].[Table]", con);

            SqlDataAdapter da = new SqlDataAdapter(cmd);

            DataSet ds = new DataSet();

            da.Fill(ds);

            con.Close();

            GridView1.DataSource = ds;

            GridView1.DataBind();

        }

    }

 

    protected void Button1_Click(object sender, EventArgs e)

    {

       

        int topla = 0;

        foreach (GridViewRow row in GridView1.Rows)

        {

            CheckBox cb = (CheckBox)row.FindControl("chkSelect");

            if (cb != null && cb.Checked)

            {

                topla = topla + Convert.ToInt32(row.Cells[4].Text);

            }

        }

 

        lblTotal.Text = "Seçili Toplam Tutar= " + topla.ToString() + "TL";

    }

}   

 

Default.aspx

 

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

 

<!DOCTYPE html>

 

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

<head runat="server">

    <title></title>

 

   

</head>

<body>

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

    <div>

   

        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="id" CellPadding="4" ForeColor="#333333" GridLines="None">

             <AlternatingRowStyle BackColor="White" ForeColor="#284775" />

             <Columns>

              <asp:TemplateField HeaderText="Select">

                  <ItemTemplate>

                      <asp:CheckBox ID="chkSelect" runat="server" />

                  </ItemTemplate>

              </asp:TemplateField>

                  <asp:BoundField DataField="Id" HeaderText="Id" />

                  <asp:BoundField DataField="Yazar" HeaderText="Yazar" />

                  <asp:BoundField DataField="Kitap" HeaderText="Kitap" />

                  <asp:BoundField DataField="Fiyat" HeaderText="Fiyat" />

              

          </Columns>

             <EditRowStyle BackColor="#999999" />

             <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />

             <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />

             <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />

             <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />

             <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />

             <SortedAscendingCellStyle BackColor="#E9E7E2" />

             <SortedAscendingHeaderStyle BackColor="#506C8C" />

             <SortedDescendingCellStyle BackColor="#FFFDF8" />

             <SortedDescendingHeaderStyle BackColor="#6F8DAE" />

      </asp:GridView>

      <asp:Label ID="lblTotal" runat="server" />

      

   

        <br />

        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Topla" />

   

   

    </div>

    </form>

</body>

</html>

   

     

Bir makalenin daha sonuna geldik. Bir sonraki makalede görüşmek üzere. Bahadır ŞAHİN