C# Corner

Resources  
  • A GridView Component in C#Apr 05, 2000. This example shows you how I've wrapped a ListView in a UserControl and turned it into a simple grid control.
  • cwTab - A Tab Control in C#May 18, 2001. cwTab is a control written in C# that gives you the ability to add Visual Studio.Net, Excel, and InterDev tabs to any application. The control is fully customizable.
  • Realtime Stock Quotes into Excel using .NETSep 03, 2001. I may seem a little Bullish on .NET, but I was able to create this application fairly quickly in C#.
  • How To Open and Read an Excel Spreadsheet into a ListView in .NETNov 26, 2001. The Interoperability services make it very easy to work with COM Capable Applications such as Word and Excel.
  • Data Transfer from SQL Server to ExcelDec 26, 2001. In this application, we will see how we can transfer data from Microsoft SQL Server into Excel spreadsheet.
  • Creating an Excel Spreadsheet ProgrammaticallyJan 22, 2002. The Interoperability services make it very easy to work with COM Capable Applications such as Word and Excel. This article reveals using Excel from a managed application. Excel is the spreadsheet component of Microsoft Office 2000.
  • Creating an Excel Spreadsheet ProgrammaticallyJan 22, 2002. The Interoperability services make it very easy to work with COM Capable Applications such as Word and Excel. This article reveals using Excel from a managed application. Excel is the spreadsheet component of Microsoft Office 2000.
  • N-Tier Development with Microsoft .NET : Part IIIFeb 25, 2002. The last installment in this series detailed more on the middle tier – business – façade and how to create a Web Service Export Proxy to have a physically separated middle tier.
  • An Editable GridView Control in C# and .NET - Part 1May 28, 2002. I've gotten a lot of e-mail about my GridView control Article, so I've decided to write a follow up article on a more powerful control that allows you to edit the cells within the control and change the colors of the cells.
  • An Editable GridView Control in C# and .NET - Part IIJun 19, 2002. In this article we will take advantage of the XML classes available to us to persist the GridView control that we talked about in our first article in this series. The two classes we utilize in our code are XmlTextWriter and XmlTextReader.
  • An Editable GridView Control in C# and .NET - Part II Persisting in XMLJun 19, 2002. In this article we will take advantage of the XML classes available to us to persist the GridView control that we talked about in our first article in this series. The two classes we utilize in our code are XmlTextWriter and XmlTextReader.
  • Editable GridView Control in C# and .NET - Part-III Printing the GridViewJun 24, 2002. In our last two articles, we talked about how to create an editable GridView and how to make it persistent in XML.
  • Editable GridView Control in C# and .NET - Part IV Exporting the GridView to ExcelJun 27, 2002. In this article we will take the contents of our GridView control and spill it into an Excel spreadsheet using this wrapper mechanism.
  • Accessing Text Files using ODBC Data ProviderNov 12, 2002. In this article, I will show you how to access Access database files using ODBC data provider.
  • Using C# .NET in Excel 2003May 08, 2003. This article shows how you can take advantage of Visual Studio 2003 tools to write .NET applications that work with Office 2003.
  • Talking to the Outside World in Excel 2003May 14, 2003. This code sample shows how to connect to the internet inside of Excel 2003. The idea is when the workbook opens the code behind the workbook searches for quotes on NASDAQ and then populates the spreadsheet with the data.
  • Export Managed Code as UnmanagedAug 05, 2003. The following Article explains in detail how to use any .NET Assembly from BlitzPlus/Blitz3D.
  • Export ASP.NET DataGrid to ExcelSep 08, 2003. Export to Excel is one of the most common functionality required in ASP.NET pages. Users can download the data from the DataGrid into an Excel spreadsheet for offline verification and/or computation.
  • Stock Paper Trader in C# and .NETNov 11, 2003. The attached source code project is a paper trading application that allows you to place imaginary trades on real data. I thought this would be fairly easy to duplicate having already written a stock capturing program into Excel.
  • Office11 Solution using .NET - A White PaperNov 25, 2003. This detailed white paper contains the information about Office 11 support for Microsoft .NET. It also explains Office 11 object model and how to access Word and Excel documents using Visual Studio .NET.
  • DataTable in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataSet in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataView in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • Data Binding in DataGrid Control using C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataTable Events in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • Constructing a DataTable using C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataReader in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataAdapter in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • Generating Microsoft Excel Reports in .NETMar 01, 2004. Microsoft Excel is installed on most computers these days since it is part of Microsoft office, and you can create detailed reports with Excel, but it will take some doing. I will attempt to show you how to create a simple report in Excel and some of the problems you may encounter along the way, this will work with Excel 97-2000.
  • Grid View Control V - Sizing and Tabbing in the GridViewMay 05, 2004. This article is in response to forums question how do I resize and use tabbing in GridView control.
  • How to Export Crystal Report in ASP.NETMay 06, 2004. When using Crystal Reports in ASP.NET, the CrystalReportViewer control does not have the export or the print buttons like the one in Windows Form. We can still achieve some degree of export and print functionality by writing our own code to handle exporting.
  • Accessing Excel Spreadsheet in C#Jun 01, 2004. Most of the time you will use SQL, Oracle, Access or some other database to store data. But it is possible to use Excel spreadsheet much like a database to stored data. This article and code will explain how to do this in C#.
  • Query Tool to Excel using C# and .NETFeb 03, 2005. This article show how to use .NET's interoperability feature to pull the data directly into the spreadsheet.
  • Mapping Microsoft Excel columns with XML data (XML data integration) programmatically using a .Net Application.Apr 21, 2005. Using this program you can map Excel columns programmatically and generate an XML file containing the cell values that you had in your Excel document. After generating the XML file we can read it into a dataset.
  • Windows Forms 2.0 ActiveDocumentHost ControlNov 10, 2005. The ActiveDocumentHost control provides the ability to host OLE Documents within your application. This enables you to create applications that allow in-place editing of documents such as Microsoft Word and Excel.
  • Generating Excel Reports using ASP.NET and C#Dec 29, 2005. This article and code snippet shows how to generate Excel reports from ASP.NET using Excel objects in .NET Framework.
  • Security Setting for ExcelJan 04, 2006. To run the excel report, security settings are required for excel application because while working with the excel application we are going to use some of the classes for manipulating the data inside the file. This article shows how to grant access or rights to those files.
  • Writing Dataset to Excel in ASP.NETMar 01, 2006. This article is helpful for those who would like to write dataset contents to a excel file and try to display it in the browser.
  • Play with the Excel Object Library using .NETMar 02, 2006. In this article we will see usage of several things like how to use WebBrowser control, manipulating Excel object libarary.
  • Introducing ASP.NET 2.0Jun 14, 2006. In this article, the author examines the fundamentals of ASP.NET 2.0 with the help of code snippets.
  • Inserting new row in GridView in ASP.NET 2.0Sep 04, 2006. The GridView was not designed to insert new rows, but there is a way to accomplish this with very little code. This article shows how to do that.
  • Flashing Stock Alert Application using C# and the Basic Stamp IISep 15, 2006. This article describes an application for reading stock quotes into an excel spread sheet and alerting the user when the stock quotes have exceeded or dropped below a certain price threshold. The project uses the SerialPort class to send commands to the Parallax Basic Stamp Microcontroller.
  • Read and write Open XML files (MS Office 2007)Sep 22, 2006. This article shows how to read and write Open XML files (MS Office 2007).
  • Tip: How to Export a Crystal Report to a PDF file Programmatically in ASP.NET?Oct 23, 2006. You can export a Crystal Report to various formats using CrystalReportViewer’s Export option. However, there are occasions when you want your users to see the report direct in PDF format in the browser as soon they click the Report button in your application.
  • ASP.Net 2.0: Export GridView to Excel Nov 06, 2006. This article describes how to Export an ASP.Net 2.0 GridView to Excel.
  • A guide to ObjectDataSource controlNov 17, 2006. One of the best new features of the forthcoming ASP.NET 2.0 will be the ObjectDataSource control. However, as I found out in my experimentation what seems like a simple control has some complex behaviours to master to get it working properly. If (like me) you have an existing data access layer you may have to make changes to be able to use ObjectDataSource.
  • Excel Automation in .NetJan 08, 2007. This article explains how to achieve excel automation in .Net.
  • Creating a Context Menu on a DataGridView Mouse Click Jan 17, 2007. This article describes how to create a context menu when you mouse click on a DataGridView control in Windows Forms.
  • Using a Web User Control inside the GridView controlFeb 21, 2007. In this article I will share how a Web User Control can be used in the GridView control. The examples are written using C# .
  • Import data from Excel to Access using ADO.netMar 05, 2007. Data interoperability with Microsoft office applications has become easier with ADO.net.
  • ASP.Net 2.0 AJAX Extension 1.0 ApplicationMar 21, 2007. This article will explain you in dept of creating AspNet Ajax-Enabled Application I have explained with the help of product management example, where you can add new product, edit, update & cancel the product related activity.
  • ASP.Net 2.0: Export GridView to Excel - Part IIApr 04, 2007. In this version of the article, we will include the handling the Hyperlink columns in the GridView export to Excel and also re-factor our original logic to use more general features of Reflection.
  • How Do I Bring a Microsoft Word Table into a DataGridView?Jun 12, 2007. This Article will answer the question: "How do I import a table in MS Word into a DataGridView using Visual Studio's built in Tools for Office.
  • Color Syntax Editor Part II - Exporting a RichTextBox to a Microsoft Word DocumentAug 14, 2007. This article is part II of a color syntax editor created back in 2003. It describes how to export the contents of the RichTextBox to Word and Open the Word Document Programmatically.
  • Creating a Dynamic Excel Using HTMLAug 30, 2007. This article includes some sample programs to show how to implement various excel functionalities with the help of HTML.
  • Selecting multiple Checkboxes inside multiple GridViewsOct 04, 2007. Ths article describes how to check/ uncheck multiple Checkboxes inside two or more GridViews on same page with Masterpage and usercontrols.
  • Create your music player in c# using gridview with simple logicDec 05, 2007. This article gives you an idea how to create your own mp3 player in asp.net 2.0.
  • Filter Data to Display in a Crystal Report Viewer ProgrammaticallyDec 10, 2007. This article describes how to filter data to display, export or print programmatically using the selection formula property of the crystal reports viewer control.
  • Database Connectivity using WebServiceJan 17, 2008. This article shows how to use Web Service and how to get data from database using Web Service.
  • Selecting Checkboxes inside the GridView ControlFeb 27, 2008. This article explains about how to select checkboxes inside the GridView control using javascript.
  • How to Convert XLS File into CSV File in C#Feb 27, 2008. The article shows you a simple way to convert an XLS file into a CSV file by using a small C# program
  • Export Dataset Data To XML FileFeb 27, 2008. This article will provides you how can you export DataSet in Asp.Net 2.0 to an XMl File.
  • Client Side Validation of GridView control with javascriptMay 21, 2008. This article shows how to use client side validations in GridView control with JavaScript.
  • Connect to an Excel file as a data source via OBDCJun 30, 2008. This article provides answer to questions asked about how to connect to an excel file as a data source for a given application, I provide the solution via this ten steps walkthrough.
  • The Concept of Shopping Cart in ASP.NET with C#Jul 16, 2008. This article will just give you the brief idea how to make simple shopping cart with dropdown GridView and data table.
  • GridView with DataPager in ASP.NET 3.5Aug 01, 2008. To page through data in a control that implements the IPageableItemContainer interface, DataPager control can be used. GridView has its own paging and does not implement IPageableItemContainer interface.
  • Integrate WPF Control in your Excel SolutionsAug 11, 2008. In this article, I will show that it is possible to host a WPF control in a excel solution even that Visual studio and the .Net framework doesn’t provide us a way to host directly a given WPF control in an Excel application. To know how to realize such task, then follow this walkthrough.
  • GridView Examples for ASP.NET 2.0Sep 15, 2008. In this article, I am going to show how you can display and edit data in an ASP.NET 2.0 GridView control without writing a single line of code.
  • Using Filter Expressions with an SQL Data Source in ASP.NET C#Oct 07, 2008. This article describes the use of filter expressions in junction with an SQL Data Source.
  • Select, Add, Update, and Delete Data in a ASP.NET GridView ControlNov 23, 2008. This articles describes you how to view, add, update, and delete data using an ASP.NET 2.0 GridView Control in SQL Server database and C#.
  • ASP.NET ObjectDataSource Control OverviewDec 04, 2008. This post explains how to represent business objects with the ObjectDatasource control. It allows you to bind DataBound controls such as GridView, DetailsView and FormView. It also enables you to separate your business logic and data access logic from presentation layer.
  • Demonstration of ListView Contents in WPFJan 14, 2009. This article shows how to create a ListView control that uses a GridView view mode to display the contents.
  • Import Data from Excel to a SQL Server databaseJan 16, 2009. This article mainly describes about how to import the data from Excel sheet to the SQL Server database.
  • Customizing GridView Control For Data ModificationsJan 28, 2009. This article is intended to illustrate how to customize GridView controls for data modification.
  • Simple & Complete GridView Functionality in .Net 2.0Feb 18, 2009. This article provides a single GridView which is capable of Displaying Data from database, Updateing it if required, Deleting the existing records from database based on a Confirmation Message and Inserting a new record(which is beyond the implicit usage of GridView).
  • Creating Excel/Word/HTML Document Using C#Feb 24, 2009. This article describes a simple approach to create Excel/Word/HTML document using C#, ADO.Net dataset without using interop/excel assemblies reference.
  • An easy way to view reports through Excel Mar 09, 2009. In this article, we are going to see an easy way to generate report using c# and view it through excel
  • Office automation with VS 2008Mar 17, 2009. Outlook automation has become integral part of any LOB application. MS Excel, work, outlook are getting used by most of the enterprise applications today. This article provides quick view on how to integrate outlook with .net application
  • Query Analyzer for OracleMar 23, 2009. Query Analyzer allows you to connect to an Oracle database and create any query, see the results, and import results to text or excel files.
  • GridView Paging and Sorting using AjaxMar 27, 2009. In this article i am going to demonstrat how to enable browser back button. You will also learn gridview control and how to use paging, sorting using AJAX.
  • Customizing codeplex frozen header gridviewApr 13, 2009. This article depicts the customization of codeplex frozen header gridview to retain its scroll position across postbacks.
  • Data-binding in ASP.NET 2.0 using GridView controlApr 22, 2009. In this article, I will cove the principles and techniques of data binding with ASP.NET 2.0 and SQL Server 2005.
  • Customizing GridView control for data modificationsApr 29, 2009. This article is intended to illustrate how to customize GridView controls for data modification.
  • Validation Controls within GridView control in ASP.NET 2.0May 05, 2009. This article is intended to show how to add customized validation features to GridView control in order to avoid mistakes when the users enter data and violates the underlying business rules.
  • Calender Control in an ASP.NET 2.0 GridView ControlMay 08, 2009. The code attached in this article shows how to integrate a Calender control in the GridView control using ASP.NET 2.0.
  • Import Data from SQL Server 2005 to Excel Sheet and ViceversaMay 11, 2009. This Article Shows How to Use SQL Server to Export Data from SQL Server to Excel Sheets and Viceversa.
  • Cell Merging In GridViewMay 19, 2009. In many asp.net applications, we use the GridView control for displaying data. It is a very helpful control and powerful indeed. Many operations can be done using the grid view control but the UI presentation is more important as it is the look-n-feel that matters a lot. In this small article, I will demonstrate how the cells of the grid can be merged as I have been asked to do the same in one of my recent projects.
  • Export Data Grid in Excel Word And Text FileJul 03, 2009. In this article I am going to show how we can export data grid in excel, word and notepad file.
  • GridView FormattingJul 06, 2009. In this article we will discuss about some of GridView formats.
  • Populating DataView from DataReaderJul 08, 2009. This article will illustrate how to populate DataView from DataReader in C#. In many scenarios we may have the data in DataReader which is required to be bind to GridView or some other control. In this scenario we can populate a DataView from DataReader and then provide the populated DataView to our Control.
  • GridView Multicolumn sortingJul 09, 2009. GridView's built-in sorting can be enabled by setting a data source and AllowSorting property to true. Click on column header to sort based on the SortExpression specified in the Gridview column. However, Gridview does not support multi column sorting which is required in day to day application. So here is how I tried to create one:
  • How to read and write ODF/ODS files (OpenDocument Spreadsheets)Jul 25, 2009. This article will explain basics of ODF format, and specifically its implementation in spreadsheet applications (OpenOffice.org Calc and Microsoft Office Excel 2007 SP2). Presented is a demo application which writes/reads tabular data to/from .ods files.
  • Select, Update, and Delete Data in a ASP.NET GridView Control.Aug 06, 2009. This articles describes you how to view, update, and delete data using an ASP.NET 2.0 GridView Control in SQL Server database and C#.
  • Export Grid to ExcelAug 13, 2009. In this article we are going to read and understand how in a web application we can export a grid data in the excel file.
  • Gridview paging and multiple row delete using checkboxAug 14, 2009. This article describes how to bind GridView using LINQ, dynamic paging and how to delete multiple rows using checkbox selection.
  • Swapping GridView rows Up and DownAug 22, 2009. In this article I am posting code about swapping GridView rows Up and Down using Data Tables.
  • Sub report in GridView using AJAXAug 31, 2009. This article explains about the sub report in the Gridview using Ajax. It will load the subreport content dynamically at the time of view the report. The ajax have used to implement this part.
  • How to use AJAX HoverMenuExtender control using Grid ViewOct 28, 2009. This article will show how to use Ajax HoveMenuExtender control with Grid View.
  • Adding CheckBoxes in SharePoint GridView (SPGridView)Oct 29, 2009. In this article, I am going to show how to add a checkboxes in SPGRidVIew. I will iterate through the SPGridView to find out the selected rows.

About export-gridview-to-excel

NA
File APIs for .NET
Aspose are the market leader of .NET APIs for file business formats – natively work with DOCX, XLSX, PPT, PDF, MSG, MPP, images formats and many more!
VSLive! Anaheim