ASP.NET

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

TextFieldParser fp = new TextFieldParser("mycsv.txt");
fp.Delimiters = {"\t"};
while (!fp.EndOfData)
{
// Fill your DataTable
}
// Bind your DataTable to the GridView

Rinki Mukheraji wrote:

I have a txt file save on server inculde 'n' no of lines.

Rinki Mukheraji wrote:

when client upload txt file. then show message file not found.

Sneha Bisht wrote:

Use This Code:
protected void bttbexcel_Click(object sender, EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter stringWrite);

GridView1.RenderControl(htmlWrite);
this.EnableViewState = false;
GridView1.AllowPaging = false;
GridView1.AllowSorting = false;
GridView1.Attributes["runat"] = "server";
Response.Write(stringWrite.ToString());
Response.End();

}
public override void VerifyRenderingInServerForm(Control control)
{

}