C# Corner

Resources  
  • Read Microsoft Access Database in C#Jan 01, 2000. How to connect and read data from a Microsoft Access (.mdb) database using ADO.NET and C#.
  • Read a file using C#Jan 15, 2000. This program just demonstrate the use of FileStream & StreamReader.
  • How to read a value from Console?Oct 07, 2000. This article explains how to get the input from the console using ReadLine.
  • FileStream : Read or Write Data StreamsDec 13, 2000. FileStream class can be used to read/write data to a file with the help of StreamReader and StreamWriter classes.
  • Reading and Wtiting XML DocumentsJan 16, 2001. In this article you will see how to read and write XML documents using XML API available in .NET Framework class library.
  • How to read Windows Registry?Jan 26, 2001. In .NET, the Registry and RegistryKey classes can be used to read and write registry ...
  • Schedule Program Using C#Feb 22, 2001. The Scheduling program consists of three main classes. The Form, the DatabaseController used to read and write scheduled events into the database and RowData which corresponds to data extracted from a row in the database.
  • Reading and Writing to the RegistryFeb 28, 2001. This is a class that both reads and writes to the registry that I made while converting some applications to use C#.
  • View Relational Data in a DataGridMar 15, 2001. This article explains you how easy is reading a database and displaying in a grid using DataSet.
  • Mail Merge ProgramMar 16, 2001. This is a simple mail merge program. This program reads from 3 different text files (by default) and merge all the info to produce mail documents.
  • Programming in ADO.NETMar 19, 2001. A simple example shows you how to read a database table in a dataset and display in a list view control.
  • Mail Merge Program - Part 2Mar 21, 2001. This is a simple mail merge program (Part 2). This program reads from the access database (by default) from a specified table.
  • Reading XML FilesMar 28, 2001. In this article, I will show you how to use the XmlTextReader class to read an XML document and write data to the console.
  • Rotation SampleApr 24, 2001. After reading Mike Golds article on transforms I thought I would get things moving a bit!
  • Reading XML File using XmlDocumentApr 26, 2001. In this article Reading XML File using XmlDocument.
  • Line numbering utility in C# and JavaMay 08, 2001. After reading this article Java programmers should be able to decipher and de-jargonize the .NET architecture and relate it with the proposed ECMA standard.
  • 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#.
  • Live News feed For Mobile SiteSep 05, 2001. Current News are read from a text file, which is being updated regularly after certain interval time.
  • Mouse and Key EventsSep 11, 2001. This article explains the usage of key and mouse events. The following code shows you how you can read mouse position on mouse move.
  • Working with Windows RegistrySep 25, 2001. In this small tutorial, I'll show you how to read, write and delete Windows Registry.
  • Encapsulation in C#Oct 12, 2001. In Object Oriented programming Encapsulation is the first pace. Encapsulation is the procedure of covering up of data and functions into a single unit (called class).
  • TextReader and TextWriter in C#Oct 16, 2001. This article covers the information of how to read or write (Unicode) character based data through TextReader and TextWriter.
  • Reading and Writing XML in C#Oct 29, 2001. In this tutorial, you will learn how to read and write XML documents in Microsoft .NET using C# language.
  • FlashCards Language Program : How to read and save Images in a Sql Server Database using ADO.NETNov 09, 2001. I thought it would be fun to write a simple program that displayed flashcards from a database and at the same time, show you how to read and write images to the database. This program is a simple flashcard program that talks to a single table in a Sql Server Database.
  • 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.
  • FlashCards Language Program : How to read and save Images in a Sql Server Database using ADO.NETFeb 19, 2002. I thought it would be fun to write a simple program that displayed flashcards from a database and at the same time, show you how to read and write images to the database. This program is a simple flashcard program that talks to a single table in a Sql Server Database.
  • Multi-threaded Web Applications - Case II: Port ScannerMar 12, 2002. This article continues the 4-parts series of Multi-threaded Web Applications. In the first part, I have demonstrated how you can use multi-threading with ASP.NET to make a web based search engine more responsive, and to reduce the time required to compose the result. In this article, I will demonstrate how you can apply the same technique to a web based port scanner.
  • Saving and Reading Object to/from a DatabaseMar 25, 2002. An object is a memory stream, which is hard to write using the normal methods. In this article, I show how you can save objects in a database and read back from the database.
  • Tracking Time in a Window ApplicationApr 15, 2002. The program reads from an XML file to get the data about names and birth dates, so it is easy to add or remove names without changing the code in case my son decides the program should include his pet dog or turtle.
  • Understanding Destructors in C#Jun 18, 2002. This article is about understanding the working concept of destructor in C#. As you read this article you will understand how different is C# destructor are when compared to C++ destructors.
  • 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.
  • Editable ListBox ControlJul 01, 2002. A ListBox is a read-only list of items. But let us suppose your application needs to edit an item in a listbox at runtime.
  • Writing a Single Event Handler for Multiple ControlsJul 22, 2002. Writing a Single Event Handler for Multiple Controls by Giuseppe Russo. Jul 22, 2002. I have noticed that in many articles, I read, people use a longer method of clearing many textboxes, as well as handling more than one control at the same time.
  • PDF ConverterAug 26, 2002. This is a PDF converter tool which can reads text documents and converts them to PDF documents.
  • TWINXBASE ServiceSep 09, 2002. This service scans in a directory by using FileWatcher component and when a file arrives, then the service will check the extension of the file, if the file has the extension .DBX then it will read the contents of the file and communicate with the database (C:\FILESERVICE\DB\MyDB.mdb) and insert / update / delete the records in the database -table.
  • MAPI Explorer in .NETSep 24, 2002. This code presents a simple MAPI explorer. You could read a mail messages from Exchange 2000 server using MAPI.
  • Alternative Simplified C# Property Syntax Dec 19, 2002. When I first read about properties in C#, I was a bit excited and a bit confused. I was glad to see so many inventions, including properties, designed to help programmers be more productive.
  • Hash Password GeneratorFeb 10, 2003. This visual tool generates the hashed password using either SHA1 or MD5 hashing algorithm depending on the choice you make. It will display the hashed password in the read only text box, it can also copy the hashed password to clipboard on your choice for easy paste operation.
  • Using C# and COM Interoperability to Extract from a UML tool into a Microsoft Word DocumentFeb 18, 2003. This article allows you to read the classes contained inside of WithClass 2000 into a Word Document using COM Interoperability for Word and COM Interoperability for WithClass and presents your classes in a kind of report.
  • 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.
  • C# Coding TechniquesSep 05, 2003. I wrote this article for novice programmers who needs to grasp the concepts of "What's C# code?" and "How we can write code?". To read this article you must have an overview of the .NET Framework and Visual Studio.NET (VS. NET).
  • 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.
  • Creating Word Find Pzzules in C# and GDI+Sep 30, 2003. In the past I have been guilty of trying a few of word find puzzles myself, so I figured why not give it a go it .NET. The Word Find creator reads a MSDE database of Words and Categories.
  • 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.
  • Reading and Display Source of Web PagesDec 30, 2003. This sample project is made to help ASP.NET developers. This projects highlights how to add HTML page inside your ASP.NET page which is hosted on same or different webserver. This page can still run on that server and only output is included in the ASP.NET page.
  • Real Life SQL and .NET: Part IIIJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET : Using SQL with C#: Part IXJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET: Part IVJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET: Part VIJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET : using SQL with C#: Part XJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET: Part XIIJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET: Part VJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET: Part IIJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET : SQL Subqueries: Part VIIJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET : using SQL with C#: Part XIJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET :Using SQL with C#: Part VIIIJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET: Part IJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • 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.
  • Implementing Security Access Rights in ASP.NET ButtonMar 24, 2004. In Web based Application, each of the users have different privileges and access rights based on their roles. Each of these roles can have read or write access for different Web pages.
  • 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#.
  • Multithreaded XML Document for Read/Write AccessJul 21, 2004. This article describes a process for using a ThreadPool within a windows service that monitors other services. It also shows how to allow multithreaded read/write access to an XmlDocument, that acts as persistent storage, using a Mutex.
  • How to Write and Read a Color in C#Dec 09, 2004. This article shows how to transform a color in hexadecimal representation.
  • 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.
  • Tip Of the Day DialogJun 30, 2005. This is a Tip of the Day Dialog for C# and .NET that gives users of your application a tip each time they launch your app.
  • ASP.NET Session StateSep 21, 2005. Session state is nothing more than memory in the shape of a dictionary or hash table, e.g. key-value pairs, which can be set and read for the duration of a user's session.
  • How do I use Memory Stream in C# Oct 27, 2005. This article shows how to use memory stream to read byte[] array and can use to write some file in memory.
  • 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.
  • How to Overcome Error "Access to the Path Containing 'hash.web' is Getting Denied."Jan 08, 2006. The article is about how to overcome with the error that reads "Access to the path containing 'hash.web' is getting denied."
  • Generics in C# 2.0Feb 02, 2006. In this article we will see how we can use generics in C#, we have read this concept as templates in C++.
  • How to Read and Write System Registry Keys using C# (VS.Net 2005)Feb 09, 2006. Most of the time while working with the Enterprise Application will need to store the user preferences inside the windows system registry. In a general term Windows Registry is the database that holds all the settings Windows needs to function.
  • Reading a word document using C#Feb 27, 2006. This tutorial is basically for C# beginners. It describes how to read a word document using C#.
  • Download Word Documents from Server Using ASP.Net and C#Feb 28, 2006. Again, this is for beginners to have a method of downloading and reading word documents from server.
  • 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.
  • Multi Threaded File Reader and GeneratorMar 07, 2006. The attached source code with this article is a multithreaded application written using .NET 2.0 that shows how to use the background worker threads to read a text file, generate reports and show report progress and completed events.
  • Deploying ASP.NET 2 Web Site to Production Server: Part IIApr 10, 2006. On the first part we discussed in detail how to move our database which contains the membership tables from the default aspnetdb Database to our database. On this part we will show how to change the default settings of asp.net membership and role providers to read from tables which stored on our database.
  • 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).
  • 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.
  • Excel Automation in .NetJan 08, 2007. This article explains how to achieve excel automation in .Net.
  • Strategy for querying Microsoft Access as an In-Memory Database using DataSets and ADO.NETJan 09, 2007. This article describes how you can read tables in from MSAccess up front in your application and then query the tables in-memory using some powerful features of the DataSet and ADO.NET
  • WPF Application for Importing ESRI ShapefilesFeb 26, 2007. A standalone application for reading ESRI shapefiles and displaying them on a WPF Canvas.
  • 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: 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.
  • C# Asynchronous, Multi Threaded Development... Digging In. Part IIMay 13, 2007. In this article we'll dig a bit deeper into what is actually happening when we use the asynchronous calls using C#. Just as in my previous article, we'll simulate a long running I/O bound process as if we were fetching records from a database, making a web service call or reading or writing from a file and see how we can write more performant code by letting the main thread continue on and not wait for the results. 
  • Multi-threaded Asynchronous Programming in C#... Event-Driven Architecture. Part IV.May 14, 2007. This is a continuation of a set of articles on Asynchronous multi-threaded development using C#. In this article we'll cover the basics of building an event-driven architecture which will be a basis for most multi-threaded apps. Also we'll cover async read/write operations on a file.
  • Reading and Writing XML using XLinqJun 21, 2007. XLinq is a new API to work with XML using LINQ. XLinq is more flexible, simple, and faster programming model to read, write, manipulate, and traverse XML documents.
  • Difference between Composition and Aggregation Jul 27, 2007. Apart from programming, a lot of my spare time sat at the computer is spent reading group, blog postings, etc from other developers. One particular posting that caught my eye recently provoked a lot of response and mixed answers to a question posed by a poster. This question was, ‘What is the difference between composition and aggregation and how would I express it in my programs?’
  • A Scrollable MessageBox in C#Jul 30, 2007. This article demonstrates how to create a message box that contains messages that scroll. This message box also allows you to read the message in from a file as well as change fonts and color properties.
  • Whose Online in ASP.NET 2.0Aug 06, 2007. I had problem in one of the project to show who is onlne & how to track multiple login/prevent from multiple login. I had gone back and forth so many time and finally am here with small snippet of code, I guess eveyone should read this article!
  • 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.

About Read-Excel

NA

SPONSORED BY

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!
Download Free eBooks