ASP.NET DataTable To Excel


   EXPORT DATA FROM DATATABLE TO EXCEL IN ASP.NET
VB - Code

Public Sub ExportExcel(ByVal Datadt As DataTable)
        Dim dt as new datatable
        dt = Datadt       
        Dim attachment As String = "attachment; filename=" & System.DateTime.Now.[Date].ToShortDateString() & "_SalesReport.xls"
        Response.ClearContent()
        Response.AddHeader("content-disposition", attachment)
        Response.ContentType = "application/vnd.ms-excel"
        Dim tab As String = ""
        For Each dc As DataColumn In dt.Columns
            Response.Write(tab + dc.ColumnName)
            tab = vbTab
        Next
        Response.Write(vbLf)
        Dim i As Integer
        For Each dr As DataRow In dt.Rows
            tab = ""
            For i = 0 To dt.Columns.Count - 1
                Response.Write(tab & dr(i).ToString())
                tab = vbTab
            Next
            Response.Write(vbLf)
        Next
        Response.[End]()
    End Sub

C# - Code

    public void ExportExcel(DataTable Datadt)
    {
        DataTable dt = new DataTable();
        dt = Datadt;
        string attachment = "attachment; filename="+System.DateTime.Now.Date.ToShortDateString()+"_SalesReport.xls";
        Response.ClearContent();
        Response.AddHeader("content-disposition", attachment);
        Response.ContentType = "application/vnd.ms-excel";
        string tab = "";
        foreach (DataColumn dc in dt.Columns)
        {
            Response.Write(tab + dc.ColumnName);
            tab = "\t";
        }
        Response.Write("\n");
        int i;
        foreach (DataRow dr in dt.Rows)
        {
            tab = "";
            for (i = 0; i < dt.Columns.Count; i++)
            {
                Response.Write(tab + dr[i].ToString());
                tab = "\t";
            }
            Response.Write("\n");
        }
        Response.End();
    }

Comments

  1. tradeimexinfoFebruary 7, 2022 at 12:30 PM

    Great job for publishing such a nice article. Your article isn’t only useful but it is additionally really informative. Read more info about Philippines Import Customs Data. Thank you because you have been willing to share information with us.

    ReplyDelete

Post a Comment

Popular posts from this blog

Dynamically Creating Image in C#.Net

              As per the requirement from one of my client, an image should be generated dynamically by taking the necessary information from the user.  When I went on a search, I came to know that, my crazy DotNet framework provided my two namespaces System.Drawing and System.Drawing.Imaging.  It’s enough to learn three classes from these namespaces - Bitmap and Graphics for generating an image dynamically related to System.Drawing Namespace and FileFormat class is for saving the created image in different file formats and is related to System.Drawing.Imaging Namespace.             Bitmap class is useful to generate a new image and to save it different file formats.  Graphics class is useful to design the image using lines, curves, rectangles, text etc., with colors and everything.  FileFormat class is useful to save the file in a particular or in different formats like Jpeg, Png, Bmp etc.  The default format is png.                         Now lets jump into code.  After
Read more

SENDING MAIL USING OUTLOOK IN VB.NET

INTRODUCTION :-                 One of my clients required a desk top application that maintains contacts in a database and sends emails to the contacts in the database.  They have not provided the credentials and the details of mail server.  So I created an application that uses outlook for sending mails by using the credentials preconfigured by the outlook account.  This application can send email for multiple email accounts and with or without attachments. FEATURES :- ·          Sending mails to multiple email accounts at a time. ·          Using configured outlook credentials. ·          No need of configuring credentials every time. ·          Sending mails with attachments. CODE EXPLANATION :-                 Create new project and add references as follows.  These files can be downloaded or can be achieved by the sample project which is attached with this article. Interop.Microsoft.Office.Core.dll Interop.Outlook.dll Let’s go to code part.  Import the fo
Read more

READING MULTIPLE TEXT FILES AND SAVING THE CONTENT TO A SINGLE FILE

Image
First step is selecting the file paths and then read the file using Stream Reader and save the content to the string builder.  After doing this for all the files, now our content is in the string builder. Now create a file with the file stream (using file stream is easily can easily kill the process).  Now write the content of the string builder to the newly created file using the Stream Writer. I have done this in winforms.  You can download the demo here. Our UI looks like this.             UI consists of two buttons, one( btnBrowse) for browsing or selecting the text files and another( btnSaveResult) for saving the new file with the combined content.  One textbox for viewing the combined content.  Apart from these controls we have added one OpenFileDialog control and one SaveFileDialog control for selecting the files and saving the newly created file respectively. Now lets jump into the code. Using System; using System.Collections.Generic; using Sys
Read more