Export GridView to CSV/Excel in C#

Step 1 : Bind GridView

            //This allows you to bind all data of GridView into ExcelSheet
            GridView1.AllowPaging = false;
            GridView1.DataSource = //List Object or DataTable
            GridView1.DataBind(); 

Step 2 : Export GridView To Excel

            HttpContext.Current.Response.ClearContent();
            HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename="                           + fileName + ".xls");   // fileNmae = Name of file
            HttpContext.Current.Response.ContentType = "application/excel";
            System.IO.StringWriter sw = new System.IO.StringWriter();
            HtmlTextWriterhtw = new HtmlTextWriter(sw);
            GridView1.RenderControl(htw);
            HttpContext.Current.Response.Write(sw.ToString());
            HttpContext.Current.Response.End();

 

Comments

Post a Comment

Popular posts from this blog

Display image from byte array in ASP.NET MVC

Image
There are many ways to display image from byte array in MVC as well as normal ASP.Net projects.In this post I'll explain couple of them. 1) Using BASE64 string of the image through ViewBag  The first way i s by sending a Base64 string as dataURL through ViewBag. As shown in b elow action method under consideration generates such a Base64 string of the image (often called Data URL) and then pass it to the view via a ViewBag property in MVC . public ActionResult Image() { string path = Server.MapPath("~/images/computer.png"); byte[] imageByteData = System.IO.File.ReadAllBytes(path); string imageBase64Data=Convert.ToBase64String(imageByteData); string imageDataURL= string.Format("data:image/png;base64,{0}", imageBase64Data); ViewBag.ImageData = imageDataURL; return View(); } The above code is a action method of Controller. In this action method it uses physical path of image and read all bytes of that image using ReadAllByte...
Read more

Export excel and Pdf with Kendo UI MVC c#

Image
Export to Excel and Pdf Export excel and pdf is now a days a basic needs of clients for saving reports or tables data. Kendo UI has build features for exporting table data to excel and pdf with Excel() and Pdf() functions. Functions are used as below. @(Html.Kendo().Grid(Model) .Name("timeGrid") .NoRecords() .Columns(columns => { columns.Bound(p => p.Field1).Title("Field1"); columns.Bound(p => p.Field2).Title("Field2"); columns.Bound(p => p.Field3).Title("Field3"); }).Groupable() .Sortable() .Excel(excel => excel .FileName("FileName.xlsx").AllPages(true) .Filterable(true) .ProxyURL(Url.Action("Excel_Export_Save", "Controller")) ) .Pdf(pdf => pdf .AllPages() .FileName("FileName.pdf").ForceProxy(true) .ProxyURL(Url.Action("Pdf_Export_Save...
Read more

Convert a color image to black and white image in C#

In this simple article you will learn that how we can convert colored image into black and white image in C#.net. This technique uses a ColorMatrix to perform the conversion. A ColorMatrix is a 5x5 matrix that can make just about any modifications to the color of an image. A ColorMatrix is pretty complicated and deserves a whole tutorial to itself. We're going to use GDI to draw the new black and white image. The benefit of this technique over the last one is that we don't need to know any information about the image's pixel format. The code here is pretty straight forward. First create the blank image and get a Graphics object from it. Next, create the ColorMatrix that will convert the original image to grayscale. Declare an ImageAttributes object that will use the ColorMatrix and use it to draw the new image using DrawImage . Below is code for your proble m      
Read more