C# Corner

Resources  
  • ADO.NET Database ExplorerJan 20, 2001. The sample connects to the SQL server database and shows you a tree view like interface of all the tables.
  • Get a database table propertiesJan 22, 2001. Get a table properties such as column names, types etc using DataColumn and DataTable.
  • Database Explorer-IVJan 25, 2001. This is version IV of the Database Explorer, which include the support for Access Database with SQL Server.
  • Write Relational Data to an XML FileMar 15, 2001. This article shows you how you can write data from a database to an XML file using DataSet.
  • 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.
  • Text to HTML ParserApr 05, 2001. If you have been into developing Web Applications then you might have at many times experienced that when you display multiple lines of data from a database you loose the spacing or formatting between multiple lines of data.
  • Assemblies : The Ins and Out : Part IApr 13, 2001. In Part 1, I will cover what exactly an assembly is, and what an assembly contains.
  • Assemblies : The Ins and Out : Part IIApr 16, 2001. In this part, I will discuss both Private and Shared assemblies and how to create a "Shared Assembly".
  • Assemblies : The Ins and Out : Part IIIApr 20, 2001. In this part I will discuss in more detail than Part 2, the available utilities for manipulating assemblies.
  • Graphics Animator in C#May 26, 2001. This program will generate a html page with animated gif. You just need at least 2 gifs and use the program to set the time to display each image.
  • Mobile Device CapabilitiesAug 01, 2001. This article explains about mobile devices and their capabilities.
  • Populating and Editing a DataGrid in ASP.NETAug 17, 2001. I will show here , how to develop DataGrid, which is able to retrieve data from joined tables and editable.
  • Oracle Database ConnectivitySep 26, 2001. This is a GUI based data entry application which shows how to add, modify and delete records using Oracle Database.
  • Developing Mobile Web Application with .NETOct 17, 2001. This article presents a general idea of the WAP (Wireless Application Protocol) and developing mobile Web application with .NET.
  • Oracle Database ViewerOct 17, 2001. This is a GUI based application which connects to an Oracle database depending upon the DSN, username and password that you provide. It then shows the list of tables on the left hand side in the form of a treeview.
  • Mapping Objects to Relational DatabasesNov 01, 2001. The application generates C# Class files for each table in a relational database. I have used Mysql and ODBC.NET for this project. The application only supports MySQL right now.
  • 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.
  • Creating a User Control: .NET Toggle ControlNov 16, 2001. This is a C# User Control which re-creates the toggle used by XML, HTML, etc. files in the .NET Developer Studio. Just compile the control and drag it onto a form from the Windows Form Toolbox.
  • Using Interfaces in .NET RemotingNov 30, 2001. In this article, we will create a remote object that will return rows from a database table. For the sake of simplicity I have used the NorthWind database that is packed with the installation of the Microsoft SQL Server.
  • Web Enabled C# ApplicationJan 02, 2002. C# is a sharp-edged weapon for Microsoft Visual Studio Programmers. My article beneath presents a brief eye-catching vivid view of programming internet web-browser using C#(C Sharp), and solves today's need with tomorrow's software!
  • 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.
  • A Database Web ServiceFeb 22, 2002. This program is a Web service, which contains Web methods that return a dataset after querying a database (any database) given the connection string, the password, the database, the table, the user ID and the SQL commands.
  • Create a SQL Server Database dynamically in C#Mar 05, 2002. In this article, I’ll show you how to create a new SQL Server database and its objects such as table, stored procedures, views and add and view data. I’ll also show you how to change database table schema programmatically. You’ll see how SQL statement ALTER TABLE is useful when you need to change a database table schema programmatically.
  • Reflecting Data to .NET Classes: Part I - From HTML FormsMar 06, 2002. Reflection allows us to examine internal details of assemblies and classes at runtime (programmatically).
  • ASP.NET Naughts and CrossesMar 22, 2002. This article demonstrates the basic techniques used to build "ASP.net Noughts & Crosses" (tic tac toe to our American friends).
  • Space Remover UtilityMar 25, 2002. In this article, I want to show you how you can remove white spaces in a web page.
  • .NET Remoting: The Interface ApproachMar 26, 2002. In this article, we will create a remote object, and access this object using the Interface. The object returns rows from a database table.
  • Reflecting Data in .NET Classes - Part IV: From Database TableApr 08, 2002. In this article, we will be looking at how to "reflect" data from the most common data source - Database tables.
  • Performance Comparison of XslTransform InputsMay 02, 2002. To transform XML into HTML for use on a Web site or to transform it into a document that contains only the fields required you could use the XSLTransform class (found in the System.Xml.Xsl namespace).
  • Performance Comparison of XslTransform InputsMay 02, 2002. To transform XML into HTML for use on a Web site or to transform it into a document that contains only the fields required you could use the XSLTransform class (found in the System.Xml.Xsl namespace).
  • 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.
  • Working with COBOL Data Groups in C#Sep 11, 2002. In this article we will begin with a C# console application calling a COBOL DLL file. The C# application will pass it a number of occurrences to create in the table (much like a user requesting a specific number of months to report on).
  • 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.
  • ADO.NET, COBOL and Stored ProcedureDec 13, 2002. A stored procedure is basically a series of SQL statements that reside on the database. The procedure could create a new table, retrieve data from one or more tables, update one or more tables or perform many other tasks.
  • GalleryDotNetJan 02, 2003. This is a simple C# console application (source included) that takes a directory of images and creates a html gallery out of them.
  • Caution When Using SetParentRow of a DataSetJan 13, 2003. I had a serious performance killer when using SetParentRow in the creation of a DataSet in ADO.NET.
  • The "ins" and "outs" of Using Stored Procedures in C#Jan 27, 2003. This article reviews the creation of stored procedures with parameters using the Visual Studio IDE.
  • Comparison between PDA/Pocket PC and Workstation FeatureApr 07, 2003. Pocket PC ships with a version of Internet Explorer, affectionately known as PIE (Pocket Internet Explorer).
  • Basics of Extending Your Working Environment in Visual StudioApr 10, 2003. All of us have used Macros in Microsoft Office and Add-ins in Visual Studio 6 and I am very sure all of us have been impressed as well by their power to control their own working environment.
  • How to Display Data Vertically?May 08, 2003. This article explains how to display data vertically rather than typically horizontal rows.
  • Add Column Dynamically to DataGrid to Display CalculationMay 08, 2003. In this article we'll see how to create a DataGrid column which displays the calculation of more than one field in the database table. The calculation could be addition, multiplication or even filtering rows.
  • ColorFul Web DropDown List in ASP.NETJul 23, 2003. In this example we will build an ASP.NET User Control which provides a listing of colors with the list items displayed in the actual color that the list item represents.
  • Deleting a DataGrid Data Based on a Column ValueJul 24, 2003. In this article we'll see how to delete the records of a DataGrid based on a column value in the database table.
  • Output ASP.NET Page to HTMLJul 29, 2003. There are various reasons why it would be more appreciative to have the html page to be served to client.
  • User Controls In Internet ExplorerAug 13, 2003. ASP programmers have long been using ActiveX controls as part of their client-side programming techniques, but now we are able to easily render Windows User Controls (almost Windows Forms, but not quite) into our HTML.
  • Modal Popup Dialog Window in ASP.NETSep 15, 2003. This sample show you how to create modal popup dialog window in ASP.NET that passes and returns multiple parameters.
  • Image Resizing and FTPDec 24, 2003. I wanted a program to resize image and just FTP them to my site. After talking with friends, I realized they also had the same problems. So I built this simple .Net application.
  • 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 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 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: 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.
  • 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.
  • DataSets in Microsoft .NET - Part 2Mar 09, 2004. This article explains sorting, searching and filtering support provided by dataset and data table objects.
  • Dynamic SQL Server Database Creation in .NETMay 03, 2004. This article explains step by step dynamic creation of a SQL Server database, tables and stored procedure using Visual Studio codename Whidbey and VB.NET.
  • University Student Registration Application in ASP.NETMay 03, 2004. The aim of this project is to implement a Web application, where students can register for an online course. If the user is an administrator, he can add and remove courses and modify the student information.
  • HTML Client for Web Services using DHTML BehaviorMay 23, 2004. In this example we will access a Web Service created in C# from an HTML client.
  • Writing HTML Content to the Screen in Word Document Format In a ServerFeb 10, 2005. This article explains a smple way to create a Microsft Word document representation of some HTML in a server.
  • Insert Master-Detail Data using Transact-SQLJun 24, 2005. Microsoft SQL Server 2000 SQLXML allows among other things to manage batch operations in a database, which reduces significantly the need of more than one round-trip to a database. OpenXML is a Transact-SQL statement that allows to represent data in XML format and can be used to insert, update, and delete more than one row (represented by an element) in a table or group of tables.
  • IM Chat Interface for C# and .NETJun 26, 2005. This article describes a way to create a colorful chat interface for instant messaging. In this chat interface you can use html and emoticon tags to display colorful text and bitmaps in order to give you a richer chat experience.
  • 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.
  • Adding and retrieving Images from a SQL Server TableSep 23, 2005. This article describes the process to add and retrieve images from a SQL Server table using ADO.NET.
  • How To Get All Database Tables and TableColumns in Oracle Nov 08, 2005. In this article, I will show how can I fetch all tables and corresponding columns from an Oracle database using C# and Oracle .NET Data Provider.
  • Presenting Child Data along with Parent Row in Data GridNov 10, 2005. This article explains how we can bind the parent and child data to a Data Grid with minimum code effort using the Repeater control.
  • Hashtable in C#Nov 14, 2005. Hashtable is useful when you need to store data in a key and value pair. This article shows how to use hashtable in C#.
  • Smart HTML Editor in Visual Studio 2005Nov 16, 2005. If you have been writing Web applications using Visual Studio, at some point you would end up editing HTML file by hand. Now HTML Editor available in Visual Studio 2005 now supports Intellisense, which makes developers life much easier when editing HTML file by hand.
  • Displaying Single Table Database Hierarchy with DataSet and DataRelationsMar 03, 2006. Hierarchies can be difficult to store SQL tables and even more difficult to query and display. This Example will show you how you can use DataRelation to convert single table hierarchy in to nested XML and then use XSLT to transform it to nested list.
  • Customized Binding Using CollectionBaseMar 04, 2006. In this article I am trying to explain the use of CollectionBase class. In a simple example I used CollectionBase to bind a DataGrid control with data from Employees table of NorthWind database. So please be sure that your system exists with NorthWind database before using the sample code along with this article.
  • Deploying ASP.Net 2.0 Web site to Production Server: Part IApr 03, 2006. Deploying ASP.NET 2.0 web site is the first issue facing the developer. This part of the article gives you a step by step to how to move membership tables from MS SQL express Edition to your database that you are used on your web site. The second part we will go in details to configure our asp.net web site.
  • Create Meta Tags Programmatically in ASP.NET 2.0Apr 07, 2006. In ASP.NET, we had an option to add head tags in HTML where we could define our Meta tags like keyword and description but in ASP.NET 2.0 if we use master page inheritated page then there is problem to add meta tags. This article explains how you can add meta tags in ASP.NET 2.0.
  • 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.
  • Accessing Crystal Report in ASP.NET using C#May 01, 2006. This article is for web-developers who want to access crystal reports in ASP.Net by using multiple tables or views etc. This application might help them and save their development time.
  • Merging data into single table from multiple tables (resultsets)May 15, 2006. This article shows how to reduce the number of trips to improve performance by merging data into single table from multiple tables (resultsets).
  • Troubleshooting Tips for ASP.Net DevelopersMay 22, 2006. This article explains three silly problems that ASP.net developers regularly face and explains how to tackle them.
  • Nested Repeater : Display Hierarchal Data in Web Form by Using ASP.Net RepeaterJun 02, 2006. This article features how to display hierarchal data from multiple tables using an ASP.Net repeater control in a web form.
  • Introduction to Common Table Expressions – SQL Server 2005Aug 03, 2006. This article delves into the concepts of Common Table Expressions (CTE) in SQL Server 2005 and their usage.
  • Maintaining Transactions in Enterprise applications using ADO.NET Transactions Aug 07, 2006. This article explains usage of System.Transactions to update tables of two different databases with two different data providers (SqlClient and OleDB) in Atomic(ACID) way.
  • Changing XSL StyleSheets on the FLY in C# and ASP.NETSep 26, 2006. This article shows you how you can use alter XSL in memory to transform XML data into HTML with different results.
  • How to Extend User Profile in ASP.Net 2.0Oct 03, 2006. This article will give you guidelines to extend user profile in standard table format which created from aspnet_regsql command by creating a detail table which will be linked to the main user table.
  • Working with HashTable in C# 2.0Nov 13, 2006. We often need to store more than one dimension data in a list and data may not be an integer or string. This article shows how to use the HashTable class to store object type data.
  • Flash Player Custom Control for ASP.NET 2.0Dec 05, 2006. This article describes a quick and simple approach to creating a custom web control used to display shockwave flash files within an ASP.NET page. Whilst the article and demonstration project are focused upon displaying a shockwave flash (SWF) file, the basic idea is applicable to any sort of object that you may wish to embed within an ASP.NET 2.0 page.
  • 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
  • ASP.NET 2.0 Visio Custom ControlJan 15, 2007. This article describes a quick and simple approach to creating a custom web control used to display Microsoft Visio files within an ASP.NET page using Internet Explorer.
  • Embed PDFs into a Web Page with a Custom ControlJan 23, 2007. This article describes an approach to embedding and displaying PDF documents in a web page through the use of a simple ASP.NET 2.0 custom server control.
  • An Easy Way to Embed Word in a Web PageJan 24, 2007. This article describes an approach to displaying word documents within a web page using a simple custom server control.
  • ASP.NET HTML Postback Custom ControlMar 01, 2007. Web form controls do not offer a complete solution to ASP.Net design and hence HTML tags are still required. Occasionally the need exists for a postback from an HTML tag, this article presents a Custom Control to address this requirement.
  • Extending ASPX Panel Control to produce Rounded CornersMar 05, 2007. This article shows how to create a custom control which encapsulates scripts. Also shows how to add method attributes to interact with VS Designer and ToolBox as well as providing intellisense dropdowns.
  • Word to HTML Converter using ASP.Net 2.0 and Microsoft 11.0 object LibraryMar 26, 2007. This article uses "Microsoft 11.0 object library" & process the word document in the backend and convert to HTML document.
  • Sending E-mails with ASP.NET 2.0 using C#May 21, 2007. In this article, Anand examines how to send e-mails using ASP.NET 2.0 in both text and HTML formats using C# with the help of an example.
  • 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.
  • Windows Communication Foundation callbackJun 12, 2007. This article is intended to illustrate how to implement callback operations in WCF through a common business scenario where the service needs to notify that some events has happened to the client. During a callback, in many aspects the tables are turned: the service becomes the client, and the client becomes the server.
  • 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.
  • WPF Database Communication Adding new Record to the DatabaseSep 06, 2007. WPF Database communication Adding new record to the database (XAML-MS-Access), I have a XAML form with FirstName, LastName, Email & Contact fields in it on click of submit button it will first check if the same email address is exists in the table else it will add new record I have made use of OleDbTransaction to perform add functionality.
  • Introduction to Building a Plug-In Architecture Using C#Sep 10, 2007. In this article we'll take another look at how we can use the state pattern to build a plug-in architecture that will allow us to change the behavior of our application by placing differnt plug-ins into a folder.
  • Retrieving Middle Rows from a TableOct 16, 2007. This article helps in retrieving middle rows of a particular table irrespective of its columns and data types.
  • Ajaxify a simple HTML page using a web service Oct 23, 2007. In this article I will explore using a web service to deliver HTML markup content to an HTML aware client using the XML HTTP request object from JavaScript code.
  • View database structure using C#Jan 16, 2008. This article describes an easy approach for examining all of the tables, views, and columns in a database.
  • SQL Server backup utility using VB.Net and SQL-DMOFeb 05, 2008. This article allows you to take backup of any SQL Server database using SQL-DMO library. It allows you to take backup of selected tables, views or stored procedure.
  • Using XSL and .NET To Display Database Tables in your Web BrowserFeb 07, 2008. This article describes how you can leverage .NET and XSL as a powerful and flexible means to rendering database reports into your Web Browser.
  • Using OUTPUT Clause for Getting Deleting Information from Several Tables.Apr 01, 2008. In this article I will explain how you can use such a T-SQL (SQL Server 2005) feature as OUTPUT clause in order to get information about rows, which were affected, when deleting process is executed for several tables, “connected” by foreign keys. The examples are written using T-SQL and C#.

About how-to-align-table-in-HTML

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