Browse by Tags

Related Posts

  • Gridview formatstrings ignored after publishing

    I created a page with VS 2005 Professional Edition which allows me to upload an Excel workbook and display it's contents in a gridview. I put DataFormatStrings of {0:0##} example--> 001 {0:MM/dd/yyyy} example--> 05/26/2009 {0:N} example--> -23,456.78 The remaining columns were strings and...
    Posted to Data Presentation Controls (Forum) by ka_Dargo on 05-26-2009, 12:00 AM
    Filed under: asp .net 2. 0, IIS 6, Windows 2003 Server, Windows 2000 Client, GridView, Excel
  • Controlling new data from an imported Excel Spreadsheet

    Hello all. Hopefully someone can help me out here. Here is my current situation. I currently have code (in C#) that imports Excel Spreadsheet data into SQL Server using OleDb and the SQLBulkCopy class. While that works perfectly, the problem is the spreadsheet is updated with new data multiple times...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by jbbates on 02-04-2008, 12:00 AM
    Filed under: sql, c#, GridView, Excel
  • Re: Saving GridView data to a local XL file

    The following will pop-up a File Download window asking the user to Open, Save or Cancel. In your Source Code - avoid EnableEventValidation --------------------------------------------------------------------------------- <%@ Page Language="C#" EnableEventValidation="false" .....
    Posted to Data Presentation Controls (Forum) by pixelsyndicate on 12-20-2007, 12:00 AM
    Filed under: C# 2005, GridView, Excel
  • Gridview to Excel using application/vnd.ms-excel

    We have been using this in classic ASP and I wanted to continue using it in ASP.NET. It works fine but I had to adjust the routine from what I found described at MSDN and all over the net. Here is what you find typically, for instance at MSDN: ' Set the content type to Excel. Response.ContentType...
    Posted to Data Presentation Controls (Forum) by RickInHouston on 07-09-2007, 12:00 AM
    Filed under: Export GridView to Excel, grid view, GridView, Excel, asp.net 2.0, export to excel
  • Ajax Update Panel and Export to Excel Functionality

    Hello all, I've run into an issue here. I have a gridview control that I want to export to Excel. All is well when it's on a simple page. The problem lies once I add it to the page I want it on. When I place it under an UpdatePanel it completely stops working. I've search the net and still have not found...
    Posted to ASP.NET AJAX UI (Forum) by axeman420 on 03-14-2007, 12:00 AM
    Filed under: enableeventvalidation, Update Panel, updatepanel, verifyrenderinginserverform, export to excel, GridView, excel, ajax
  • Export data to Excel (Not HTML Tables)

    I have been searching for a way to do this but to no avail. I need to export a GridView to an Excel spreadsheet in the actual XLS format. Not HTML tables saved to a file with XLS extension. The reason being, I need to reimport the data using the OleDbConnection (so I can query it and such) and it does...
    Posted to Enterprise Services Integration (Forum) by phokus on 01-09-2007, 12:00 AM
    Filed under: asp.net 2.0, c#, GridView, Excel
  • Datatable to Excel, converting a long string of numbers to exponential

    I am exporting a datatable to excel, the conversion is all fine except that I have 12 character string of numbers that gets converted to exponential. How do I avoid that. The issue is resolved if I generate a gridview and then export to excel by handling in the RowDataBound event. But I dont want to...
    Posted to Data Presentation Controls (Forum) by abhims on 06-24-2009, 12:00 AM
    Filed under: GridView, Excel, DataTable, export
  • Re: Help me on how to Export datagrid data to Excel?

    public static void ConvertDstoExcel(DataSet ds ,HttpResponse response) { response.Clear(); response.Charset = ""; response.ContentType = "application/vnd.ms-excel"; StringWriter stringWrite = new StringWriter(); HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); DataGrid...
    Posted to Data Presentation Controls (Forum) by waqas_w on 12-08-2009, 12:00 AM
    Filed under: GridView, Excel, dataset
  • Custom export gridview to excel

    I have an editable gridview and want to eliminate the first column from exporting to Excel. I'm using this article for reference http://mattberseth.com/blog/2007/04/export_gridview_to_excel_1.html
    Posted to Data Presentation Controls (Forum) by mcp111 on 02-20-2008, 12:00 AM
    Filed under: export, GridView, Excel, .net
  • gridview export to excel stop working after updatepanel added

    I've added an updatepaqnel for my gridview and the export to excel functionality stop working. System tell me that gridview must be placed in form tag with runat="server" What can I do? Please help! Thank you
    Posted to ASP.NET AJAX UI (Forum) by giovazza on 04-05-2007, 12:00 AM
    Filed under: updatepanel, AJAX, Export GridView to Excel, GridView, Excel
Page 1 of 1 (10 items)