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#.
  • Use C# to write comments and documentationJan 12, 2000. Comments and Documentation is one of the most hated tasks by programmers. By using C# programmers can can automatically builds the documentation and comments in the code. This documentation is a XML file which is more or less self explanatory.
  • Write data to an access database using SQL Query and ADO.NETDec 06, 2000. See how to use SQL Statements to write data to an access database.
  • Add, Edit, Delete, View data using ADO+Jan 04, 2001. Free to use Tutorials on using ADO+ on Microsoft's .NET Platform in C# as programming language.
  • 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.
  • 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.
  • Database Explorer : Part 2Jan 22, 2001. Attached is a C# program which is a enhanced version of the previous article on ADO.NET.
  • Get a database table propertiesJan 22, 2001. Get a table properties such as column names, types etc using DataColumn and DataTable.
  • A Database Access Class with Overloaded SELECT StatementsJan 24, 2001. A useful database access class with overloaded SELECT and other statements.
  • ADO.NET Database Explorer with Query Analyzer : Part 3Jan 24, 2001. This is the part three of the Article Database Explorer. This parts adds some more and valuable functionality.
  • Database Explorer-IVJan 25, 2001. This is version IV of the Database Explorer, which include the support for Access Database with SQL Server.
  • ADODataReader- Writing DataSets to XMLFeb 04, 2001. This file uses ADODataReader and other objects to write DataSets to XML and filling data from the XML files.
  • 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.
  • Testing .Net Components Using NUnitMar 08, 2001. Write unit tests before starting development". Writing test allows me to see immediate results of every code change.
  • 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.
  • 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.
  • ADO.NET DataSet ProgrammingMar 20, 2001. A sample project shows you how to add, edit, delete, navigate, save records in a database using DataSet.
  • 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.
  • Introduction to SOAPMar 22, 2001. Since the release I have been fascinated with this thing called SOAP, This bubbly new protocol backed by the power of XML is certainly going to make waves in the world of distributed computing. The first thing which comes into our mind is “Why the heck we didn’t think of this before?
  • Write XML in C#Mar 27, 2001. In this article, I will show you how to use XmlTextWriter class to create an XML document and write data to the document.
  • 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.
  • Inserting Data to an XML DocumentMar 28, 2001. The XmlNode and the XmlDocument classes can be used to insert XML data to an existing document or to a new document.
  • 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.
  • Reading XML File using XmlDocumentApr 26, 2001. In this article Reading XML File using XmlDocument.
  • XML Strengths and Weaknesses with DOM, ASP, and XSLApr 30, 2001. In this article we're going to take a look at some of the terminology that comes with using XML and its related technologies, as well as how to create and transform XML documents with XSL using Microsoft's MSXML parser. To test the code samples shown in this article you should be running Windows NT/2000/XP with IIS installed. You should also have SQL server 2000 installed on the same machine.
  • Connect to an Oracle DatabaseMay 03, 2001. This sample code shows you how to connect to an Oracle database using C#.
  • SQLDataReader Vs. DataSetMay 11, 2001. To compare and contrast SQLDataReader and SQLDataSetCommand.
  • Transaction Web SiteMay 16, 2001. When I started working with this technology I faced a problem dealing with session as in any transaction or Database oriented portal this is a must requirement to deal with.
  • 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.
  • Web Scanner Part-1Jun 01, 2001. My favourite technology web site is updated throughout the day. I thought it would be nice to have a program that checked every 30 minutes for updates and told me what stories were there.
  • Working With OleDb Data Adapters Jun 19, 2001. This step by step tutorial guides you to create your database applications using OleDb Data Adapters in VS.NET.
  • Working with OleDb Data AdaptersJun 20, 2001. This step by step article guides you to create your database applications using OleDb Data Adapters in VS.NET.
  • XML as Middle TierJul 12, 2001. There is always been a need that there will be an intelligent middle Layer between Database Server and the UI Code. There are many ways but one fantastic approach came in picture with the XML.
  • Mobile with Access DatabaseJul 14, 2001. Till now we had done the Programming using SQL Server and XML as Database.
  • .NET is the FutureJul 19, 2001. This has been a long time in coming. I couldn't write any more article because of some problems but finally I thought I should talk about the future of .NET. The reason is very simple, I'm getting almost 50 mails a day in my inbox just asking about the future of .NET and the comparison with other technologies. So I'm presenting my own views about the future possibilities of this technology.
  • Generating XML from SQL databaseJul 30, 2001. Some Days Back i posted the article dealing XML as a Middle tier but i guess the People didn't get the clear funda.
  • Basic Database Operations in ADO.NETAug 08, 2001. This Article will show the basic database transactions select, insert update and delete.
  • CDataService: A Generic Database Access ClassAug 09, 2001. Using a generic database access component in data-aware applications can simply development and separate data tier from business tier.
  • Creating Dynamic Web Quizzes using C# and ASP.NETAug 15, 2001. This article describes how to create a web quiz from the information in a database.
  • XML GeneratorAug 17, 2001. This article is about advance use of reflection package in Csharp.
  • MP3 IndexerAug 20, 2001. Mp3Indexer searches for existing Mp3 files on a given path, and generates a report in XML/XSL.
  • Basic Database operations using ADO.NETAug 21, 2001. I found very interesting database features incorporated into the .NET as ADO.NET.
  • Advertising on MobileAug 30, 2001. Finally,its possible to advertise on your mobile phones. Mobiles toolkit provides an add rotator control very similiar to the ad rotator control for the Web. This control will disply the Advertisement in the random manner picking from the XML File.
  • Simple Game Developed in C#Sep 03, 2001. This article contains the code for a simple game developed using csharp. This game is all about arranging the shuffled numbers in ascending order.
  • Accessing Oracle DatabaseSep 21, 2001. This source code shows you how to connect to an oracle database and do operations such as select, insert, update and delete.
  • 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.
  • File Uploading using XMLOct 09, 2001. This application is in ASP.NET which will allow you to upload images to an XML file which serves as the database for the uploaded files.
  • Query BuilderOct 17, 2001. This application is that of a QueryBuilder in CSharp.This application is for Beta2 SDK version of DotNetFramework.
  • 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.
  • 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.
  • 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.
  • Deevloping a Banking System using VS.NET and Windows FormsDec 26, 2001. This article also focuses on deploying multiple windows forms and shows how to navigate between them.
  • Adapter Pattern in C#Jan 03, 2002. The Gang Of Four (GoF) defined the Adaptor pattern as follows in their most famous book "Design Patterns" Gamma et al. Adapter lets classes work together that couldn't otherwise because of incompatible interfaces."
  • Sending WAP Site feedback from Mobile PhoneJan 16, 2002. The WAP (Wireless Apllication Protocol) is the leading standard for information services on wireless terminals.
  • .NET Framework and Web Services - Part 1Jan 28, 2002. The .NET Framework is a new computing platform designed to simplify Windows application development in the highly distributed environment of the Internet. Common Language Runtime (CLR) is the Heart of the .NET Framework.
  • C# Discussion Forum from Harrison LogicJan 29, 2002. Threaded Discussion Forum that utilizes the .NET framework, with C# as the ASP.NET server side language. Uses MS Access Database for data.
  • World Weather Update on Your MobileFeb 04, 2002. In this article, I would like to discuss the "Weather Update" on Your Mobile.
  • Data Binding in DataGrid Control - Part 1Feb 05, 2002. When it comes to data-bound controls and database programming, DataGrid control is the most versatile , powerful and flexible control available in Visual Studio .NET.
  • Data Access through Web Services, Stored Procedures and SQL QueriesFeb 12, 2002. Web Services has been the most revolutionary aspect of the .NET framework developed by Microsoft. This article presents the three different modes through which data can be accessed viz. through Web services, stored procedures and SQL query using the power of ADO.NET and XML.
  • N-Tier Development with Microsoft .NET : Part IFeb 15, 2002. The purpose of this article is to examine a proof of concept on an architecture that follows the DNA pattern on concept only.
  • 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.
  • XML Web Services Type MarshalingFeb 20, 2002. This article illustrates that various data types can be passed to and returned from Web Service methods.
  • 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.
  • xBase Engine for C# and VB.NETFeb 25, 2002. This library is written to handle DBF files from C# or VB.NET applications.
  • Transcations in Web Services - Part 1Feb 26, 2002. I believe most of the database developers are familiar with transactions. Transactions are one of the common activities a database developer has to deal with. Transactions are also used in Web Services.
  • Sorting Object Using IComparer and IComparable Interfaces Mar 01, 2002. The System.Collections namespace contains interfaces and classes that define various...
  • Authenticate Web Service Client - Windows ApplicationMar 04, 2002. This client application shows you how to access Authenticate Web service from a Windows application.
  • Authenticate Web ServiceMar 04, 2002. In this example we will build a web service that authenticates userid and password from an a very simple MS Access database. This web service exposes only one method to the client.
  • 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.
  • Publication Application Developed in C#Mar 07, 2002. This program retrieves publishers, title and author information from the SQL Server "pubs" Database.
  • Reflecting Data to .NET Classes: Part IIMar 08, 2002. This article continue the series of "Reflecting Data to .NET Classes". In the first article, we discussed the concept “Reflecting Data”. The techniques behind it were also explained and demonstrated. The source of data demonstrated in this article will be XML documents.
  • Creating a SQL Server Database Programmatically using SQLDMOMar 12, 2002. The attached source code creates a SQL Server database programmatically using SQLDMO.
  • .NET Beta 2 and Navigation in XML DocumentsMar 13, 2002. .NET Beta 2 was released yesterday at tech-ed, 2001, Atlanta. Many things have been changed in Beta 2 since Beta 1. In this article, I'll cover changes in XmlNavigator class replaced with XPathNavigator.
  • SQL Server Database ExplorerMar 20, 2002. This application connects to a running SQL Server 2000 and displays all the available databases in it.
  • 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.
  • .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.
  • XML Signatures in Microsoft .NETMar 28, 2002. In this article we will explore XML Signature specification from W3C and its implementation in .NET using C#.
  • XML Signatures in Microsoft .NETMar 28, 2002. In this article we will explore XML Signature specification from W3C and its implementation in .NET using C#.
  • Poorman's Installation program in C# and .NETApr 08, 2002. Installation programs can be quite expensive these days. Although programs such as Wise and InstallShield have fantastic features and are fairly comprehensive, sometimes you just want to do the easy installation of copying and pasting files into a directory and perhaps placing a shortcut in the start menu.
  • 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.
  • Creating Graphics with XMLApr 09, 2002. This article shows how to create images on the fly and uses XML to specify the properties of the images.
  • Using XML Based Configuration File in Windows Form ApplicationsApr 15, 2002. Often when building an application, a programmer wants to be able to change application settings without having to recompile the application.
  • 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.
  • XML Schema ValidatorApr 16, 2002. The XML Schema Validator checks if a given XML document is well formed and has a valid schema model.
  • Loading XML File in a TreeView Control using MultithreadingApr 19, 2002. There are many occasions when programmers need to develop multithreading applications, which can load big files in the background and let the user do data entry or other jobs without any interruption. In this article, I'll show you how to create multiple threads to load multiple files.
  • A Database Component: Inserting Serializable ObjectsApr 23, 2002. The attached zip file contains two projects - a database component (DLL) project and a Windows forms project called Test. Both projects are written and compiled using Visual Studio .NET version 1.0.
  • A C# SOAP Apache ClientApr 26, 2002. This part shall demonstrate how a simple web service can be created quickly using Visual Studio.Net.
  • XML Parser in C#Apr 30, 2002. This project gives you a head start to write XML parser in C#.
  • 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).
  • A Simple Contacts List for Pocket PCMay 19, 2002. I have implemented a simple contact list application that is capable of adding and viewing contact details.
  • Save and Restore Setings of a .NET Form using XMLMay 28, 2002. Even though there are advantages to writing to the registry, there are times when a programmer does not want to impact anything outside of the directory where the program resides.
  • 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.
  • 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.
  • 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.

About Xml-Database

NA

SPONSORED BY

Custom Software Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.
European SharePoint Conference