Tuesday, 28 January 2014

Value add dynmanically in Grid view Item template

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

<!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></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <asp:GridView ID="gvGrade" runat="server" AutoGenerateColumns="false"
            DataKeyNames="RollNo" onrowdatabound="gvGrade_RowDataBound"
           >
    <Columns>
    <asp:TemplateField HeaderText="Name">
    <ItemTemplate>
    <asp:Label ID="lblName" runat="server" Text='<%#Bind("Name") %>'/>
    </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="RollNo">
<ItemTemplate>
<asp:Label ID="lblRollNo" runat="server" Text='<%#Bind("RollNo") %>'/>
</ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Sub1" >
    <ItemTemplate>
 <asp:Label ID="lblSub1" runat="server" Text='<%#Bind("Sub1") %>'></asp:Label>
    </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Sub2">
   
    <ItemTemplate>
    <asp:Label ID="lblSub2" runat="server" Text='<%#Bind("Sub2") %>'/>
    </ItemTemplate>
   
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Sub3">
    <ItemTemplate>
    <asp:Label ID="lblSub3" runat="server" Text='<%#Bind("Sub3") %>'/>
    </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Sub4">
    <ItemTemplate>
    <asp:Label ID="lblSub4" runat="server" Text='<%#Bind("Sub4") %>'/>
    </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Sub5">
    <ItemTemplate>
    <asp:Label ID="lblSub5" runat="server" Text='<%#Bind("Sub5") %>'/>
    </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="TotalMarks">
    <ItemTemplate>
    <asp:Label ID="lblTotal" runat="server" Text='<%# Bind("Total") %>'></asp:Label>
    </ItemTemplate>
        </asp:TemplateField>
    </Columns>
  
        <EditRowStyle HorizontalAlign="Left" VerticalAlign="Bottom" />
  
    </asp:GridView>
    </div>
    </form>
</body>
</html>

Code Behind

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;


public partial class GradeCard : System.Web.UI.Page
{
    DataSet ds = new DataSet();
    SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Y"].ToString());
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Marksheet();
            Label sub1 = (Label)gvGrade.Rows[0].FindControl("lblSub1");
          Label sub2 = (Label)gvGrade.Rows[0].FindControl("lblSub2");
          Label sub3 = (Label)gvGrade.Rows[0].FindControl("lblSub3");
          Label sub4 = (Label)gvGrade.Rows[0].FindControl("lblSub4");
          Label sub5 = (Label)gvGrade.Rows[0].FindControl("lblSub5");
            int s = Convert.ToInt32(sub1.Text) + Convert.ToInt32(sub1.Text) + Convert.ToInt32(sub2.Text) + Convert.ToInt32(sub3.Text) + Convert.ToInt32(sub4.Text) + Convert.ToInt32(sub5.Text);
           ds.Tables[0].Columns.Add("Total");
           DataRow dr = ds.Tables[0].NewRow();
            dr["Total"] = s;
           ds.Tables[0].Rows.Add(dr);
           Marksheet();
        }

    }

    private void Marksheet()
    {
        string sql = "Select * From MCA";
        SqlCommand cmd = new SqlCommand(sql, con);
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
       
        sda.Fill(ds);
        if (!ds.Tables[0].Columns.Contains("Total"))
        {
            ds.Tables[0].Columns.Add("Total");
        }
        gvGrade.DataSource = ds;
        gvGrade.DataBind();
       
    }
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)