ASP.NET

<connectionStrings>
    <clear />
    <add name="LocalSqlServer" connectionString="your connection string"
      providerName="System.Data.SqlClient" />
  </connectionStrings>

VijayVishwakarma wrote:

Configuration configurationFile = WebConfigurationManager.OpenWebConfiguration("/web.config");

Configuration configurationFile = WebConfigurationManager.OpenWebConfiguration("~");

MailSettingsSectionGroup mailSettings = configurationFile.GetSectionGroup("system.net/mailSettings") as MailSettingsSectionGroup;

<asp:GridView ID="gv_Transaction" runat="server" AutoGenerateColumns="False" Width="80%" HorizontalAlign="Center" CellPadding="4" GridLines="None" ShowFooter="True">
        <FooterStyle  HorizontalAlign="Center"/>
                            <asp:BoundField HeaderText="Employee Name" DataField="Ename" SortExpression="Ename">
                                <ItemStyle Width="100px" />
                            </asp:BoundField>
                            <asp:BoundField HeaderText="SSN" DataField="ssn" SortExpression="ssn" >
                                <ItemStyle Width="80px" />
                            </asp:BoundField>
                            <asp:TemplateField HeaderText="Amount" >
                                <ItemTemplate>
                                     $ <asp:TextBox ID="txt_dollar" runat="server" Width="60px" MaxLength="12" style=" text-align:right;" CausesValidation="true" onChange="Add()" /b>gt;</asp:TextBox>
                                    <asp:RegularExpressionValidator ID="reg_dollar" runat="server" ValidationExpression="^\d*\.?(\d{2})$" ErrorMessage="<b>Incorrect Format</b>" SetFocusOnError="true" Display="Dynamic" ControlToValidate="txt_dollar">
                                        <asp:ImageButton ID="img_amt" runat="server" ImageUrl="~/Images/error.gif" AlternateText="Incorrect Format" />
                                    </asp:RegularExpressionValidator>
                             </ItemTemplate>
                                <ItemStyle Width="80px" />
                            </asp:TemplateField>                          
                                                      
                               
                            <asp:BoundField HeaderText="Status" DataField="status" SortExpression="status">
                                <ItemStyle Width="60px" />
                            </asp:BoundField> 
                        </Columns>
    </asp:GridView>

<td style="width:10%; text-align:right; color:#2572a7;">Total Dollar Amount:</td> 
            <td style="width:15%;color:#2572a7; "><asp:Label ID="lbl_TotAmount" runat="server"></asp:Label></td>

var obj = window.event.srcElement;
 var tBox;

 // clear the sum variable
var sum = 0;

 if(obj.tagName == "INPUT" && obj.type == "text" )
 {
     // Iterate through all the TextBoxes

     tBox = document.getElementsByTagName("INPUT");

     for(i = 0; i< (tBox.length - 2) ; i++)
     {
        if(tBox[i].type == "text")
        {
             if ((parseFloat(tBox[i].value)) && tBox[i].id !="ctl00_ContentPlaceHolder1_payDate_txt_Date" )
             {
                 // The Number function forces the JavaScript to recognizes the input as a number

                 sum += Number(tBox[i].value);

             }
         }
     }

 }
// To Round to Nearest Decimal (i,e to avoid values like 34.999999)
 sum=sum.toFixed(2).toString(10)
  // set the value to the Label Text
 document.getElementById("ctl00_ContentPlaceHolder1_lbl_TotAmount").innerText = sum;