User475983607 posted
I recommend using SQL or you business layer to sum values as that's what SQL and your business layer are for. The GridView is for reading and writing records. You're moving business logic to the UI which clutters the UI and you end up with logic
all over the place.
Anyway, use the row data bound event to sum server control values found in the GridView if you want to code this the hard way.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="GridViewDemo3.aspx.cs" Inherits="WebFormsDemo.GridViewDemo3" %>
<!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="MyGridView" runat="server" AutoGenerateColumns="False" OnRowDataBound="MyGridView_RowDataBound">
<Columns>
<asp:TemplateField HeaderText="Col1">
<ItemTemplate>
<asp:TextBox ID="Col1Text" runat="server" Text='<%# Bind("Col1") %>'></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Col2">
<ItemTemplate>
<asp:TextBox ID="Col2Text" runat="server" Text='<%# Bind("Col2") %>'></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Col3">
<ItemTemplate>
<asp:TextBox ID="Col3Text" runat="server" Text='<%# Bind("Col3") %>'></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
<div>
</form>
</body>
</html>
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace WebFormsDemo
{
public partial class GridViewDemo3 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
MyGridView.DataSource = CreateDataTable();
MyGridView.DataBind();
}
}
protected DataTable CreateDataTable()
{
// Create a new table.
DataTable dt = new DataTable("Items");
// Create the columns.
dt.Columns.Add("Col1", typeof(int));
dt.Columns.Add("Col2", typeof(int));
dt.Columns.Add("Col3", typeof(int));
//Add data to the new table.
for (int i = 0; i < 10; i++)
{
DataRow tableRow = dt.NewRow();
tableRow["Col1"] = i;
tableRow["Col2"] = i + 3;
tableRow["Col3"] = 0;
dt.Rows.Add(tableRow);
}
return dt;
}
protected void MyGridView_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
TextBox col1 = e.Row.FindControl("Col1Text") as TextBox;
TextBox col2 = e.Row.FindControl("Col2Text") as TextBox;
TextBox col3 = e.Row.FindControl("Col3Text") as TextBox;
col3.Text = (int.Parse(col1.Text) + int.Parse(col2.Text)).ToString();
}
}
}
}
