Forum guidelines
AuthorQuestion
updating total time value based on time value
Posted on: 14 Dec 2012
 

i have a gridview with columns task_no,date,university,spoken,medium ,time and a template field column - total_time.

the column 'time' has a label in the item template and a textbox in the edititemtemplate..

the column 'total_time' has a label in the item template..

what i need is :-

1) value of time should be the value of total_time..

2)as i change the value of time during EDIT,that value should be added up to the value of total_time..

this should be done for each row..

my source code and code behind is :

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

public partial class DisplayEntry : System.Web.UI.Page
{
 
    protected void Page_Load(object sender, EventArgs e)
    {
        GridView1.Visible = true;
        if (!IsPostBack)
        {

            ddlUniv_SelectedIndexChanged(sender, e);
            ddlMedium_SelectedIndexChanged(sender, e);
            ddlUnivv_SelectedIndexChanged(sender, e);
            ddlMediumm_SelectedIndexChanged(sender, e);

            ProCon p = new ProCon();
            try
            {
                DataTable dt = new DataTable();
                SqlDataAdapter adp = new SqlDataAdapter();

                p.cmd.CommandText = "select * from entry_mast";


                adp.SelectCommand = p.cmd;
                dt.Clear();

                adp.Fill(dt);
                // GridView1.DataSource = dt;
                GridView1.DataBind();


            }
            catch (Exception ex)
            {
                Response.Write(ex.ToString());
            }

        }
    }
  


    protected void btnSave_Click(object sender, EventArgs e)
    {
        GridView1.ShowFooter = true;
        long t;
        string dt, sp;
        decimal tt;

 

        TextBox tb = (TextBox)(GridView1.FooterRow.FindControl("txtTaskNo"));
        t = Convert.ToInt64(tb.Text);
        tb = (TextBox)(GridView1.FooterRow.FindControl("txtDate"));
        dt = tb.Text;
        tb = (TextBox)(GridView1.FooterRow.FindControl("txtSpoken"));
        sp = tb.Text;
        tb = (TextBox)(GridView1.FooterRow.FindControl("txtTime"));
        tt = Convert.ToDecimal(tb.Text);
      

        DropDownList ddlUniv = (DropDownList)GridView1.FooterRow.Cells[2].FindControl("ddlUniv");
        DropDownList ddlMedium = (DropDownList)GridView1.FooterRow.Cells[4].FindControl("ddlMedium");
        SqlDataSource1.InsertParameters[0].DefaultValue = t.ToString();
        SqlDataSource1.InsertParameters[1].DefaultValue = dt;
        SqlDataSource1.InsertParameters[3].DefaultValue = sp;
        SqlDataSource1.InsertParameters[5].DefaultValue = tt.ToString();
        SqlDataSource1.InsertParameters[2].DefaultValue = ddlUniv.SelectedValue;
        SqlDataSource1.InsertParameters[4].DefaultValue = ddlMedium.SelectedValue;

        SqlDataSource1.Insert();
        Response.Write("SAVED");
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        GridView1.DataBind();
    }
    protected void ddlUniv_SelectedIndexChanged(object sender, EventArgs e)
    {
        DropDownList ddlUniv = new DropDownList();
        Response.Write(ddlUniv.SelectedValue);
        ddlUniv.Items.Clear();
    }
    protected void ddlUnivv_SelectedIndexChanged(object sender, EventArgs e)
    {
        DropDownList ddlUniv = new DropDownList();
        Response.Write(ddlUniv.SelectedValue);
    }
    protected void ddlMediumm_SelectedIndexChanged(object sender, EventArgs e)
    {
        DropDownList ddlMedium = new DropDownList();
        Response.Write(ddlMedium.SelectedValue);
    }
    protected void ddlMedium_SelectedIndexChanged(object sender, EventArgs e)
    {

        DropDownList ddlMedium = new DropDownList();
        Response.Write(ddlMedium.SelectedValue);
    }
    protected void GridView1_RowDeleted(object sender, GridViewDeletedEventArgs e)
    {

    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
     ProCon p=new ProCon();
      p.cnn.Open();
        SqlCommand mydelete = new SqlCommand("delete from entry_mast where task_no=@task_no",p.cnn);
        mydelete.CommandType = CommandType.Text;


        mydelete.Parameters.Add("@task_no", SqlDbType.BigInt).Value = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0].ToString());
        mydelete.ExecuteNonQuery();
    }

  
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
      
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
    }

    protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e)
    {
    }
       
  decimal total_time;
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
     
       
 Label lblTime = (Label)e.Row.FindControl("lblTime");
           decimal time = Decimal.Parse(lblTime.Text);

        Label lblTOT = (Label)e.Row.FindControl("lblTOT");

            lblTOT.Text= time.ToString();

            total_time += time;
        }


       
    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }

    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
  
    }


    protected void txtTime_TextChanged(object sender, EventArgs e)
    {


    }
}using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Collections;
using System.Configuration;
using System.Data.SqlClient;
using System.Data.Sql;
using System.Data.SqlTypes;

public partial class DisplayEntry : System.Web.UI.Page
{
 
    protected void Page_Load(object sender, EventArgs e)
    {
        GridView1.Visible = true;
        if (!IsPostBack)
        {

            ddlUniv_SelectedIndexChanged(sender, e);
            ddlMedium_SelectedIndexChanged(sender, e);
            ddlUnivv_SelectedIndexChanged(sender, e);
            ddlMediumm_SelectedIndexChanged(sender, e);

            ProCon p = new ProCon();
            try
            {
                DataTable dt = new DataTable();
                SqlDataAdapter adp = new SqlDataAdapter();

                p.cmd.CommandText = "select * from entry_mast";


                adp.SelectCommand = p.cmd;
                dt.Clear();

                adp.Fill(dt);
                // GridView1.DataSource = dt;
                GridView1.DataBind();


            }
            catch (Exception ex)
            {
                Response.Write(ex.ToString());
            }

        }
    }
  


    protected void btnSave_Click(object sender, EventArgs e)
    {
        GridView1.ShowFooter = true;
        long t;
        string dt, sp;
        decimal tt;

 

        TextBox tb = (TextBox)(GridView1.FooterRow.FindControl("txtTaskNo"));
        t = Convert.ToInt64(tb.Text);
        tb = (TextBox)(GridView1.FooterRow.FindControl("txtDate"));
        dt = tb.Text;
        tb = (TextBox)(GridView1.FooterRow.FindControl("txtSpoken"));
        sp = tb.Text;
        tb = (TextBox)(GridView1.FooterRow.FindControl("txtTime"));
        tt = Convert.ToDecimal(tb.Text);
      

        DropDownList ddlUniv = (DropDownList)GridView1.FooterRow.Cells[2].FindControl("ddlUniv");
        DropDownList ddlMedium = (DropDownList)GridView1.FooterRow.Cells[4].FindControl("ddlMedium");
        SqlDataSource1.InsertParameters[0].DefaultValue = t.ToString();
        SqlDataSource1.InsertParameters[1].DefaultValue = dt;
        SqlDataSource1.InsertParameters[3].DefaultValue = sp;
        SqlDataSource1.InsertParameters[5].DefaultValue = tt.ToString();
        SqlDataSource1.InsertParameters[2].DefaultValue = ddlUniv.SelectedValue;
        SqlDataSource1.InsertParameters[4].DefaultValue = ddlMedium.SelectedValue;

        SqlDataSource1.Insert();
        Response.Write("SAVED");
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        GridView1.DataBind();
    }
    protected void ddlUniv_SelectedIndexChanged(object sender, EventArgs e)
    {
        DropDownList ddlUniv = new DropDownList();
        Response.Write(ddlUniv.SelectedValue);
        ddlUniv.Items.Clear();
    }
    protected void ddlUnivv_SelectedIndexChanged(object sender, EventArgs e)
    {
        DropDownList ddlUniv = new DropDownList();
        Response.Write(ddlUniv.SelectedValue);
    }
    protected void ddlMediumm_SelectedIndexChanged(object sender, EventArgs e)
    {
        DropDownList ddlMedium = new DropDownList();
        Response.Write(ddlMedium.SelectedValue);
    }
    protected void ddlMedium_SelectedIndexChanged(object sender, EventArgs e)
    {

        DropDownList ddlMedium = new DropDownList();
        Response.Write(ddlMedium.SelectedValue);
    }
    protected void GridView1_RowDeleted(object sender, GridViewDeletedEventArgs e)
    {

    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
     ProCon p=new ProCon();
      p.cnn.Open();
        SqlCommand mydelete = new SqlCommand("delete from entry_mast where task_no=@task_no",p.cnn);
        mydelete.CommandType = CommandType.Text;


        mydelete.Parameters.Add("@task_no", SqlDbType.BigInt).Value = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0].ToString());
        mydelete.ExecuteNonQuery();
    }

  
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
      
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
    }

    protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e)
    {
    }
       
  decimal total_time;
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
     
       
 Label lblTime = (Label)e.Row.FindControl("lblTime");
           decimal time = Decimal.Parse(lblTime.Text);

        Label lblTOT = (Label)e.Row.FindControl("lblTOT");

            lblTOT.Text= time.ToString();

            total_time += time;
        }


       
    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }

    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
  
    }


    protected void txtTime_TextChanged(object sender, EventArgs e)
    {


    }
}



source code:

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

<!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>

 

  

 

  <%--<script type="text/javascript">
      function UpdateLabel() {
          document.getElementById('lblTOT').innerText = document.getElementById('txtTime').value;
      }
</script>
--%>

</head>

 


<body>
    <form id="form1" runat="server">
   
    <div>
   
   <%-- <asp:Label ID="lblTOT" runat="server" Text="0"></asp:Label>
     <asp:TextBox ID="txtTime" runat="server" onblur="UpdateLabel();" onkeyup="UpdateLabel();">   
          </asp:TextBox>
--%>


    </div>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
        DataKeyNames="task_no" DataSourceID="SqlDataSource1"
        EnableModelValidation="True" ShowFooter="True"
       
        style="z-index: 1; left: 104px; top: 148px; position: absolute; height: 133px; width: 187px"
        onpageindexchanging="GridView1_PageIndexChanging"
        onrowdatabound="GridView1_RowDataBound" onrowdeleted="GridView1_RowDeleted"
        onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" OnRowCommand="GridView1_RowCommand"
        onrowupdated="GridView1_RowUpdated" onrowupdating="GridView1_RowUpdating"
        onselectedindexchanged="GridView1_SelectedIndexChanged" AllowPaging="True"
        BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px"
        CellPadding="3" GridLines="Horizontal" PageSize="3"
        >
      
      
      
      
      
        <AlternatingRowStyle BackColor="#F7F7F7" />
      
      
      
      
      
        <Columns>
            <asp:CommandField ShowDeleteButton="True" ShowEditButton="True"  DeleteText="Delete" EditText="Edit" />
           
           
           
            <asp:TemplateField HeaderText="task_no" SortExpression="task_no">
                <EditItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%# Bind("task_no") %>'></asp:Label>
                </EditItemTemplate>
                 <FooterTemplate>
                    <asp:TextBox ID="txtTaskNo" runat="server"></asp:TextBox>
                </FooterTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%# Bind("task_no") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
          
          
          
          
          
            <asp:TemplateField HeaderText="date" SortExpression="date">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("date") %>'></asp:TextBox>
                </EditItemTemplate>
                <FooterTemplate>
                    <asp:TextBox ID="txtDate" runat="server"></asp:TextBox>
                </FooterTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label2" runat="server" Text='<%# Bind("date") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            
            
            
            
            
            
            
            
             <asp:TemplateField HeaderText="university" SortExpression="university">
                 <EditItemTemplate>
                     <asp:DropDownList ID="ddlUnivv" runat="server" AutoPostBack="True"
                         SelectedValue='<%# Bind("university") %>'
                         onselectedindexchanged="ddlUnivv_SelectedIndexChanged">
                         <asp:ListItem>delhi</asp:ListItem>
                         <asp:ListItem>chennai</asp:ListItem>
                         <asp:ListItem>bombay</asp:ListItem>
                         <asp:ListItem>manipal</asp:ListItem>
                     </asp:DropDownList>
                 </EditItemTemplate>
               
               
                 <FooterTemplate>
                     <asp:DropDownList ID="ddlUniv" runat="server" AutoPostBack="True"
                         AppendDataBoundItems="True" EnableViewState="False"
                         OnSelectedIndexChanged="ddlUniv_SelectedIndexChanged"
                      >
                      <asp:ListItem>--select--</asp:ListItem>
                         <asp:ListItem>delhi</asp:ListItem>
                         <asp:ListItem>chennai</asp:ListItem>
                         <asp:ListItem>bombay</asp:ListItem>
                         <asp:ListItem>manipal</asp:ListItem>
                     </asp:DropDownList>
                     &nbsp;
                 </FooterTemplate>

                 <ItemTemplate>
                     <asp:Label ID="Label5" runat="server" Text='<%# Eval("university") %>'></asp:Label>
                 </ItemTemplate>

            </asp:TemplateField>
          
          
          
          
          
          
          
          
          
          
          
            <asp:TemplateField HeaderText="spoken" SortExpression="spoken">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("spoken") %>'></asp:TextBox>
                </EditItemTemplate>
                <FooterTemplate>
                    <asp:TextBox ID="txtSpoken" runat="server"></asp:TextBox>
                </FooterTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label3" runat="server" Text='<%# Bind("spoken") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            
            
            
            
            
            
            
            
            
                <asp:TemplateField HeaderText="medium" SortExpression="medium">
                   
                    <EditItemTemplate>
                        <asp:DropDownList ID="ddlMediumm" runat="server" AutoPostBack="True"  SelectedValue='<%# Bind("medium") %>'
                         AppendDataBoundItems="True"
                            onselectedindexchanged="ddlMediumm_SelectedIndexChanged" >
                            <asp:ListItem>Web</asp:ListItem>
                            <asp:ListItem>Mail</asp:ListItem>
                        </asp:DropDownList>
                    </EditItemTemplate>
                    <FooterTemplate>
                        <asp:DropDownList ID="ddlMedium" runat="server" AutoPostBack="True"  AppendDataBoundItems="True"
                        EnableViewState="False"
                            onselectedindexchanged="ddlMedium_SelectedIndexChanged">
                            <asp:ListItem>--select--</asp:ListItem>
                            <asp:ListItem>Web</asp:ListItem>
                            <asp:ListItem>Mail</asp:ListItem>
                        </asp:DropDownList>
                        &nbsp;
                    </FooterTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label6" runat="server" Text='<%# Eval("medium") %>'></asp:Label>
                    </ItemTemplate>
            </asp:TemplateField>
          
          
          
          
          
          
          
          
          
          
            <asp:TemplateField HeaderText="time" SortExpression="time">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("time") %>'></asp:TextBox>
                </EditItemTemplate>
                <FooterTemplate>
                    <asp:TextBox ID="txtTime" runat="server" ></asp:TextBox>
                    <asp:Button ID="btnSave" runat="server" onclick="btnSave_Click" Text="Save"
                        Width="64px" />
                </FooterTemplate>
                <ItemTemplate>
                    <asp:Label ID="lblTime" runat="server" Text='<%# Bind("time") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
          
           
            <asp:TemplateField HeaderText="tot_time">
                <ItemTemplate>
                    <asp:Label ID="lblTOT" runat="server" ></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
          
           
        </Columns>
        <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
        <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
        <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
        <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
        <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:con %>"
       
        SelectCommand="SELECT * FROM [entry_mast]"
        ConflictDetection="CompareAllValues"
        DeleteCommand="DELETE FROM [entry_mast] WHERE [task_no] = @original_task_no AND (([date] = @original_date) OR ([date] IS NULL AND @original_date IS NULL)) AND (([university] = @original_university) OR ([university] IS NULL AND @original_university IS NULL)) AND (([spoken] = @original_spoken) OR ([spoken] IS NULL AND @original_spoken IS NULL)) AND (([medium] = @original_medium) OR ([medium] IS NULL AND @original_medium IS NULL)) AND (([time] = @original_time) OR ([time] IS NULL AND @original_time IS NULL))"
        InsertCommand="INSERT INTO [entry_mast] ([task_no], [date], [university], [spoken], [medium], [time]) VALUES (@task_no, @date, @university, @spoken, @medium, @time)"
        OldValuesParameterFormatString="original_{0}"
       
       
       
       
        UpdateCommand="UPDATE [entry_mast] SET [date] = @date, [university] = @university, [spoken] = @spoken, [medium] = @medium, [time] = @time WHERE [task_no] = @original_task_no AND (([date] = @original_date) OR ([date] IS NULL AND @original_date IS NULL)) AND (([university] = @original_university) OR ([university] IS NULL AND @original_university IS NULL)) AND (([spoken] = @original_spoken) OR ([spoken] IS NULL AND @original_spoken IS NULL)) AND (([medium] = @original_medium) OR ([medium] IS NULL AND @original_medium IS NULL)) AND (([time] = @original_time) OR ([time] IS NULL AND @original_time IS NULL))">
        <DeleteParameters>
            <asp:Parameter Name="original_task_no" Type="Int64" />
            <asp:Parameter Name="original_date" Type="String" />
            <asp:Parameter Name="original_university" Type="String" />
            <asp:Parameter Name="original_spoken" Type="String" />
            <asp:Parameter Name="original_medium" Type="String" />
            <asp:Parameter Name="original_time" Type="Decimal" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="task_no" Type="Int64" />
            <asp:Parameter Name="date" Type="String" />
            <asp:Parameter Name="university" Type="String" />
            <asp:Parameter Name="spoken" Type="String" />
            <asp:Parameter Name="medium" Type="String" />
            <asp:Parameter Name="time" Type="Decimal" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="date" Type="String" />
            <asp:Parameter Name="university" Type="String" />
            <asp:Parameter Name="spoken" Type="String" />
            <asp:Parameter Name="medium" Type="String" />
            <asp:Parameter Name="time" Type="Decimal" />
            
            <asp:Parameter Name="original_task_no" Type="Int64" />
            <asp:Parameter Name="original_date" Type="String" />
            <asp:Parameter Name="original_university" Type="String" />
            <asp:Parameter Name="original_spoken" Type="String" />
            <asp:Parameter Name="original_medium" Type="String" />
            <asp:Parameter Name="original_time" Type="Decimal" />
        </UpdateParameters>
    </asp:SqlDataSource>
    </form>
</body>
</html>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DisplayEntry.aspx.cs" Inherits="DisplayEntry" %>

<!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>

 

  

 

  <%--<script type="text/javascript">
      function UpdateLabel() {
          document.getElementById('lblTOT').innerText = document.getElementById('txtTime').value;
      }
</script>
--%>

</head>

 


<body>
    <form id="form1" runat="server">
   
    <div>
   
   <%-- <asp:Label ID="lblTOT" runat="server" Text="0"></asp:Label>
     <asp:TextBox ID="txtTime" runat="server" onblur="UpdateLabel();" onkeyup="UpdateLabel();">   
          </asp:TextBox>
--%>


    </div>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
        DataKeyNames="task_no" DataSourceID="SqlDataSource1"
        EnableModelValidation="True" ShowFooter="True"
       
        style="z-index: 1; left: 104px; top: 148px; position: absolute; height: 133px; width: 187px"
        onpageindexchanging="GridView1_PageIndexChanging"
        onrowdatabound="GridView1_RowDataBound" onrowdeleted="GridView1_RowDeleted"
        onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" OnRowCommand="GridView1_RowCommand"
        onrowupdated="GridView1_RowUpdated" onrowupdating="GridView1_RowUpdating"
        onselectedindexchanged="GridView1_SelectedIndexChanged" AllowPaging="True"
        BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px"
        CellPadding="3" GridLines="Horizontal" PageSize="3"
        >
      
      
      
      
      
        <AlternatingRowStyle BackColor="#F7F7F7" />
      
      
      
      
      
        <Columns>
            <asp:CommandField ShowDeleteButton="True" ShowEditButton="True"  DeleteText="Delete" EditText="Edit" />
           
           
           
            <asp:TemplateField HeaderText="task_no" SortExpression="task_no">
                <EditItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%# Bind("task_no") %>'></asp:Label>
                </EditItemTemplate>
                 <FooterTemplate>
                    <asp:TextBox ID="txtTaskNo" runat="server"></asp:TextBox>
                </FooterTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%# Bind("task_no") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
          
          
          
          
          
            <asp:TemplateField HeaderText="date" SortExpression="date">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("date") %>'></asp:TextBox>
                </EditItemTemplate>
                <FooterTemplate>
                    <asp:TextBox ID="txtDate" runat="server"></asp:TextBox>
                </FooterTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label2" runat="server" Text='<%# Bind("date") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            
            
            
            
            
            
            
            
             <asp:TemplateField HeaderText="university" SortExpression="university">
                 <EditItemTemplate>
                     <asp:DropDownList ID="ddlUnivv" runat="server" AutoPostBack="True"
                         SelectedValue='<%# Bind("university") %>'
                         onselectedindexchanged="ddlUnivv_SelectedIndexChanged">
                         <asp:ListItem>delhi</asp:ListItem>
                         <asp:ListItem>chennai</asp:ListItem>
                         <asp:ListItem>bombay</asp:ListItem>
                         <asp:ListItem>manipal</asp:ListItem>
                     </asp:DropDownList>
                 </EditItemTemplate>
               
               
                 <FooterTemplate>
                     <asp:DropDownList ID="ddlUniv" runat="server" AutoPostBack="True"
                         AppendDataBoundItems="True" EnableViewState="False"
                         OnSelectedIndexChanged="ddlUniv_SelectedIndexChanged"
                      >
                      <asp:ListItem>--select--</asp:ListItem>
                         <asp:ListItem>delhi</asp:ListItem>
                         <asp:ListItem>chennai</asp:ListItem>
                         <asp:ListItem>bombay</asp:ListItem>
                         <asp:ListItem>manipal</asp:ListItem>
                     </asp:DropDownList>
                     &nbsp;
                 </FooterTemplate>

                 <ItemTemplate>
                     <asp:Label ID="Label5" runat="server" Text='<%# Eval("university") %>'></asp:Label>
                 </ItemTemplate>

            </asp:TemplateField>
          
          
          
          
          
          
          
          
          
          
          
            <asp:TemplateField HeaderText="spoken" SortExpression="spoken">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("spoken") %>'></asp:TextBox>
                </EditItemTemplate>
                <FooterTemplate>
                    <asp:TextBox ID="txtSpoken" runat="server"></asp:TextBox>
                </FooterTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label3" runat="server" Text='<%# Bind("spoken") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            
            
            
            
            
            
            
            
            
                <asp:TemplateField HeaderText="medium" SortExpression="medium">
                   
                    <EditItemTemplate>
                        <asp:DropDownList ID="ddlMediumm" runat="server" AutoPostBack="True"  SelectedValue='<%# Bind("medium") %>'
                         AppendDataBoundItems="True"
                            onselectedindexchanged="ddlMediumm_SelectedIndexChanged" >
                            <asp:ListItem>Web</asp:ListItem>
                            <asp:ListItem>Mail</asp:ListItem>
                        </asp:DropDownList>
                    </EditItemTemplate>
                    <FooterTemplate>
                        <asp:DropDownList ID="ddlMedium" runat="server" AutoPostBack="True"  AppendDataBoundItems="True"
                        EnableViewState="False"
                            onselectedindexchanged="ddlMedium_SelectedIndexChanged">
                            <asp:ListItem>--select--</asp:ListItem>
                            <asp:ListItem>Web</asp:ListItem>
                            <asp:ListItem>Mail</asp:ListItem>
                        </asp:DropDownList>
                        &nbsp;
                    </FooterTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label6" runat="server" Text='<%# Eval("medium") %>'></asp:Label>
                    </ItemTemplate>
            </asp:TemplateField>
          
          
          
          
          
          
          
          
          
          
            <asp:TemplateField HeaderText="time" SortExpression="time">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("time") %>'></asp:TextBox>
                </EditItemTemplate>
                <FooterTemplate>
                    <asp:TextBox ID="txtTime" runat="server" ></asp:TextBox>
                    <asp:Button ID="btnSave" runat="server" onclick="btnSave_Click" Text="Save"
                        Width="64px" />
                </FooterTemplate>
                <ItemTemplate>
                    <asp:Label ID="lblTime" runat="server" Text='<%# Bind("time") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
          
           
            <asp:TemplateField HeaderText="tot_time">
                <ItemTemplate>
                    <asp:Label ID="lblTOT" runat="server" ></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
          
           
        </Columns>
        <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
        <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
        <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
        <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
        <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:con %>"
       
        SelectCommand="SELECT * FROM [entry_mast]"
        ConflictDetection="CompareAllValues"
        DeleteCommand="DELETE FROM [entry_mast] WHERE [task_no] = @original_task_no AND (([date] = @original_date) OR ([date] IS NULL AND @original_date IS NULL)) AND (([university] = @original_university) OR ([university] IS NULL AND @original_university IS NULL)) AND (([spoken] = @original_spoken) OR ([spoken] IS NULL AND @original_spoken IS NULL)) AND (([medium] = @original_medium) OR ([medium] IS NULL AND @original_medium IS NULL)) AND (([time] = @original_time) OR ([time] IS NULL AND @original_time IS NULL))"
        InsertCommand="INSERT INTO [entry_mast] ([task_no], [date], [university], [spoken], [medium], [time]) VALUES (@task_no, @date, @university, @spoken, @medium, @time)"
        OldValuesParameterFormatString="original_{0}"
       
       
       
       
        UpdateCommand="UPDATE [entry_mast] SET [date] = @date, [university] = @university, [spoken] = @spoken, [medium] = @medium, [time] = @time WHERE [task_no] = @original_task_no AND (([date] = @original_date) OR ([date] IS NULL AND @original_date IS NULL)) AND (([university] = @original_university) OR ([university] IS NULL AND @original_university IS NULL)) AND (([spoken] = @original_spoken) OR ([spoken] IS NULL AND @original_spoken IS NULL)) AND (([medium] = @original_medium) OR ([medium] IS NULL AND @original_medium IS NULL)) AND (([time] = @original_time) OR ([time] IS NULL AND @original_time IS NULL))">
        <DeleteParameters>
            <asp:Parameter Name="original_task_no" Type="Int64" />
            <asp:Parameter Name="original_date" Type="String" />
            <asp:Parameter Name="original_university" Type="String" />
            <asp:Parameter Name="original_spoken" Type="String" />
            <asp:Parameter Name="original_medium" Type="String" />
            <asp:Parameter Name="original_time" Type="Decimal" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="task_no" Type="Int64" />
            <asp:Parameter Name="date" Type="String" />
            <asp:Parameter Name="university" Type="String" />
            <asp:Parameter Name="spoken" Type="String" />
            <asp:Parameter Name="medium" Type="String" />
            <asp:Parameter Name="time" Type="Decimal" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="date" Type="String" />
            <asp:Parameter Name="university" Type="String" />
            <asp:Parameter Name="spoken" Type="String" />
            <asp:Parameter Name="medium" Type="String" />
            <asp:Parameter Name="time" Type="Decimal" />
            
            <asp:Parameter Name="original_task_no" Type="Int64" />
            <asp:Parameter Name="original_date" Type="String" />
            <asp:Parameter Name="original_university" Type="String" />
            <asp:Parameter Name="original_spoken" Type="String" />
            <asp:Parameter Name="original_medium" Type="String" />
            <asp:Parameter Name="original_time" Type="Decimal" />
        </UpdateParameters>
    </asp:SqlDataSource>
    </form>
</body>
</html>


i am getting same value for both time and total_time..


 

and when i try to edit, i am gettin error:Object reference not set to instance of an object..

however delete is workin fine :)

and when i try to edit, i am gettin error:Object reference not set to instance of an object..

however delete is workin fine :)



 

plzz help..its very very urgent!!


AuthorReply
Re: updating total time value based on time value
Posted on: 16 Dec 2012  
Hi Archana,

It'll be good if you upload your source code in a zip archive including table and data script instead of writing your source code here. Actually it is hard to review/understand such large code snippet.

Also, give an overview of the data you're using. 3-4 rows are enough for each table.

Do an edit... you may got solution soon!

SPONSORED BY

Custom Software Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.