C# Corner

Resources  
  • Browse or Open a FileDec 15, 2000. This sample code show you how to use OpenFileDialog class to open or browse a file.
  • Word Pad in C#May 11, 2001. This application explores the Rich Text control in C#,its properties and methods. Explains the usage of common dialog boxes File open, File save and Font dialog box.
  • 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.
  • Mobile Fun with XMLMay 24, 2001. Here is something really wonderful in Mobile field .This example is for authenticating the Mobile Users against his settings stored in XML file. This is really good where all the ease of XML is applied. Function open the XML file and particular node data validate it against user inputs and do the specified.
  • Printing out your W2 Form using C# and .NETAug 07, 2001. This article covers a fairly practical aspect of using a computer - dealing with forms. The concepts in this article can be used to create any Form Application so that you can design forms that you can Fill Out, Open, Save, Print and Print Preview.
  • Web Services between .NET, Java and MS SOAP Toolkit: Part IAug 24, 2001. WinGhost 2.0 application allows you to show and hide applications running on your machine. I find this program useful at my work as I do lot of programming at any given time I can have a bunch windows open. I use it normally to hide just my windows I don't access that often.
  • 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#.
  • Image Shuffler Game in C#Oct 01, 2001. This game asks for a Image file to be Opened When the file is opened and shuffle button is clicked the image will be Shuffled ie rotated clockwise the task is rearrange the image in the Correct order using the button provided.
  • 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.
  • Image Viewer in C#Feb 01, 2002. This program allows you to open and view image files including JPEG, GIF, WMF and other images.
  • Creating and Opening Microsoft Word Document from .NET Using C#Mar 08, 2002. This article is being written in response to a couple inquiries on the question, "How do I open a word document from .NET?".
  • ExoEngine - A C# OpenGL 3D EngineApr 12, 2002. For my fourth year computer graphics course I wrote a little 3D engine using C# and the .NET platform.
  • C# Style-SheetMay 31, 2002. This article contains a C# style-sheet for the GNU a2ps print utility. The style-sheet keywords, comments, preprocessor directives, and [] style attributes are pretty-printed in the typical a2ps fonts.
  • 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.
  • Creating an Instance of Internet Explorer in C#Dec 19, 2002. I was trying to write a program that opened an instance of Internet Explorer in a separate window, rather than use the Browser control that comes with the .NET platform.
  • Recording Sheet Music Using C# and .NETFeb 07, 2003. This is a article that allow you to record and replay the music you performed on the piano.
  • Speedometer: Applying GDI+ TransformationsFeb 10, 2003. This zip file contains two folders - one folder contains speedometer control and the other contains the application that uses the control. Put both folders in the same location and open the application in VS and run it.
  • Opening and Viewing Text and Image FilesMar 08, 2003. We will start this article with a simple application where we will learn how to open and view text and image files using the OpenFileDialog class. In doing so, we will learn some basics of GDI+ drawing, menus and panel control.
  • Hotmail using C# - An HTTPMail Client under .NETMar 21, 2003. The great thing about the POP mail protocol is that it is a well-documented open standard and writing a mail client to collect mail from a POP box a relatively painless process.
  • Math Equation Editor in C#Apr 07, 2003. The Equation Editor I created in C# allows you to create a few simple equations using the keyboard. With the editor you can open and save files of your equations.
  • 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.
  • Part I: Simple Color Syntax Code Editor for PHP written in C# and .NETJun 18, 2003. The Application is a simple Windows Form program that allows you to open and save the text files edited in the rich edit control, as well as print them out. The program takes advantage of a “syntax” text file for PHP which lists the functions and keywords contained in the PHP language.
  • User Controls in Internet ExplorerAug 13, 2003. WinGhost 2.0 application allows you to show and hide applications running on your machine. I find this program useful at my work as I do lot of programming at any given time I can have a bunch windows open. I use it normally to hide just my windows I don't access that often.
  • 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.
  • 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.
  • Transforming Visual Studio .NET Projects into NANT files using XSLT and .NETApr 16, 2004. I was looking for a solution on how to execute an XSL transform on a C# project file and convert it to a Nant build file. Nant provides the xsl file to do the conversion under the open source license agreement, but Nant does not provide away of producing the transformation.
  • 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#.
  • Handling Oracle Max Open Cursor Error when Fetching Multiple Rows in ADO.NETAug 18, 2004. When working with Microsoft technologies, MS SQL Server comes out as a natural choice for the database. While it is a fact that .NET Framework has extensive support for SQL server, when you work with other databases like Oracle the situation might turn out to be a little more tricky than it is with SQL Server.
  • Microsoft Application Center TestOct 13, 2004. Application Center Test (ACT) stress tests Web servers and analyze performance and scalability problems of Web applications. ACT simulates a large group of users by opening multiple connections to the server and rapidly sending HTTP requests. It also supports several other authentication schemes and the SSL protocol, making it ideal for testing personalized and secure sites.
  • A comprehensive view of SharePoint: Part IINov 19, 2004. Enterprise portals are an important part of today's enterprise IT infrastructure. Portals are used as an entry point for a specific topic, organization, project or team. Many enterprises have an enterprise portal, opened by default when an employee opens up a browser, which shows general information about the enterprise, its strategy, its departments, etc.
  • 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.
  • M.S. Visio AutomationAug 19, 2005. This article demonstrates the flexibility of Visio products as a development platform by describing the customized business solutions.
  • 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.
  • Display a Web Page in a Windows FormsJan 31, 2006. In this article, we will see how we can display a web page on Windows Forms.
  • Introduction to the MagicAjax.NET - The Magic Ajax Engine for .NETFeb 11, 2006. MagicAjax.NET is a free open-source framework, designed to make it easier and more intuitive for developers to integrate AJAX technology into their web pages, without replacing the ASP.NET controls and/or writing tons of JavaScript code.
  • Programmatic Interaction with Control Panel Using VS.Net 2005Feb 21, 2006. This is simple sample on using Shell and some of its methods. Provided code will open windows that represent Control Panel’s applications. It’s just demonstration on shell usage.
  • 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.
  • Creating MS Word Document using C#, XML and XSLTMar 21, 2006. This simple program demostrate how to create well formatted MS Word documents using C#, XML and XSLT. Using XSLT to create Word documents requires the knowledge of RTF key words.
  • AI: Using Genetic Algorithms and NetSpell to Solve AnagramsMar 27, 2006. Remember the puzzles where you are given a jumble of letters and you have to unscramble a word? This article shows you how to use a genetic algorithm and NetSpell, an open source spell checker, to solve these anagram puzzles.
  • Using static variable and Activated Event for Building "Home" Button of Windows applicationApr 10, 2006. In this tutorial I will share experience how , just with the help of a few clicks and a few lines of code , to build a windows application with "Home" button, that allows to return to "Home" form (in fact to close all opened forms by one click) . The examples are written using C#.
  • Using Delegates to Communication Between Windows FormsSep 04, 2006. Delegates are one of the wonderful features of .Net Framework. Their primary use is focused on support event handling and callback mechanism. In this article we will explore how to use delegate as callback support to make simple communication between deferent opened windows forms
  • Image Conversion Utility in C#Sep 14, 2006. This article describes a very easy approach to building an image conversion utility that will permit the user to open a supported image type and convert it to another supported image type.
  • 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).
  • Creating and Opening Microsoft Word Documents from .NET Using C#Oct 25, 2006. This article answers "how do I open a word document from within a .NET 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.
  • Excel Automation in .NetJan 08, 2007. This article explains how to achieve excel automation in .Net.
  • HTTP:/1.1 500 Internal Server ErrorFeb 09, 2007. If you are running two versions of ASP.NET, you may get HTTP:/1.1 500 Internal Server Error when creating a new Web project or opening an existing Web project in Visual Studio.
  • Image Mapping UtilityFeb 23, 2007. This article describes an easy approach to building a simple image mapping utility that may be used to mark and store points as pixel based coordinates from an image file or directly from a web page.
  • 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.
  • Build a Simple Watermarking Utility in C#May 07, 2007. This article shall describe an approach to building a simple watermarking utility that may be used to add watermarks to any supported image file format. The resulting application shall permit the user to open any supported image file format into a scrollable picture box.
  • Error Opening SSIS PackageMay 30, 2007. I got a weird error when trying to open an SSIS package in VS2005.
  • Printing Text File in C#Jun 07, 2007. In this article, you will learn how to print a text file in C#. The attached project lets you browse and open a text file and print it to a printer.
  • Fill in PDF Form Fields Using the Open Source iTextSharp DLLJun 18, 2007. This article describes a quick and simple approach to programmatically completing a PDF document through the use of the iTextSharp DLL.
  • Connection PoolingAug 11, 2007. While performing any database activity it is necessary that every single connection need to be closed, but in case your application throws some exception in that case our connection wont’ get closed. And you will get error “Cannot open connection, it is already open” In this article I will be discussing what is connection pooling? Why connection polling & how we can enable connection pooling etc.
  • 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.
  • Writing Better Code - Keepin' it ExtensibleFeb 21, 2008. In a previous article I talked about how to keep code cohesive by applying the Single Responsibility Principle. I wanted to explore part of another principle of software engineering that will help our code be extensible and can handle growth and change.
  • 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
  • Save the application settings for subsequents sessionsApr 19, 2008. It is very important to save the application settings established by the user in the current session, in order to avoid the application pattern establishment for each time a new session is opened.
  • Manage Data in a Win Forms Application (without the Database)May 12, 2008. This article provides an approach to building an application that may be used to collect, store, and retrieve data without relying upon a database to get there.
  • Access the Same Instance of Internet Explorer WindowJun 26, 2008. This tip shows how to open an URL inside an Internet Explorer browser window from your C# application. Furthermore it shows how to update that specific window.
  • 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.
  • Opening Jars with C# Jul 07, 2008. This article shall describe an approach that may be used to extract Jar files. Jars are merely files compressed using zip compression; the primary difference between a standard trash zip file and a jar file is that the jar file includes a manifest; also a true jar files can be run as an executable on a machine equipped with the java runtime.
  • 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.
  • Image Viewer in WPFAug 12, 2008. ImageViewer is an open source project written in WPF and C# that allows users to view images and manipulate them.
  • Explore BrowserAug 13, 2008. The attached project is an advanced Web Browser application that open all web sites sites.
  • Adding FooTnotes to a Word Document Programatically (MS Office 2007 word)Oct 06, 2008. This is an article about adding footnotes to a word document programatically. I had this as one of my requirement while generating word documents dynamically, and i really struggled to acheive it, as well as find some help online.
  • Five minutes to cook ASP.NET Reporting Service sheetNov 11, 2008. ASP.NET Reporting Services introduce new version of Reporting Services with nicely interface features.
  • OpenFileDialog in SilverlightNov 30, 2008. The OpenFileDialog allows users to select one or more files on the local computer or on a networked computer. This article demonstrates how to create and use an OpenFileDialog control in Silverlight using XAML and C#.
  • MyCollegeMyFriend - An Open Source Project developed using ASP.NET 2.0Jan 14, 2009. MyCollegeMyFriend is an open source Website project developed using C# and ASP.NET 2.0. Anybody can download and make changes to this project and upload the changes.
  • 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.
  • 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.
  • RFC Architecture for Finance Project (The Invoicing Project)Feb 26, 2009. RFC is an open source initiative for Finance projects. It has reusable components like invoicing, accounting and purchase modules. In this section we will discuss about the Invoicing section of the RFC architecture.
  • Using NHibernateMar 04, 2009. NHibernate is an open source project for Object/Relational mapping to persist objects in a relational database. This article is a step by step tutorial on how to work with NHibernate.
  • 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
  • Hello WorldMar 16, 2009. The goal of this article is to teach and explain C# in such a way so that when you have finished it you will be able to program in C#.
  • 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.
  • 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.
  • Uploading XL Sheet data into SQL Server 2005 using C#May 19, 2009. Uploading XL Sheet data into SQL Server 2005 using C#
  • Using PostgreSQL from Microsoft.NETJun 04, 2009. PostgreSQL is one of the most important relational database systems in the open source world. It is released under a BSD style license. I’ve seen a few documents talking about the development of .NET application with PostgreSQL as the back-end server. That’s why I’m writing this article to illustrate how you can access to the PostgreSQL database system using C#.
  • 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.
  • Opening a Word Document in ASP.Net MVC ApplicationJul 23, 2009. This Article will explain , How to open or display a word document in ASP.Net MVC application.
  • 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.
  • Web Browser control in WPFJul 30, 2009. In this article, I am going to show you; how to work with Web Browser control in WPF? We will be opening a web site (even a Silverlight Enabled web site in WPF application) in the new Web Browser control.
  • OpenFileDialog in WPFAug 11, 2009. This article shows how to use an OpenFileDialog control in WPF and C# to browse files.
  • 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.
  • Applying CSS Layout in the Data ControlsSep 23, 2009. This article explains about the how to apply CSS layout in the data controls with sample codes.

About Open-Excel-Sheet-From-Cloud

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!
techbash 2016