C# Help

This is a program to access a database usingtreeview control. It contains the parent database at the root andtables in that database that are the children of the root but siblingsof each other. The Show button click causes the display of all tablesin the database to appear and double clicking of each table causes toshow [...]

0.Abstract In this article, we will drill down deeper into the design of a n-tier architecture and our focus will be on thedata access tier(DAT) (Figure 0).Our goal is to design and implement anappropriate data access tier(DAT) for scalable, reliable andinteroperable web application. I have divided this article in to twomajor parts. In the first [...]

Download ADOSQL.zip AD What? This will be a multi-part article dealing with ADO. We will begin with a bit of history of ADO, what it is, why it's so important, and finally how to utilize it in a COBOL environment. This first article will provide a brief history of data access as well as provide [...]

An OpenSource Application to administrate mySQL Databases. It provides an very easy to use and efficient Way to work with the Database. It provides many Features that can be compared with those in many commercial Tools. The Highlights are Just in Time Editing Download MySql-Spy

Soruce Code ownload Executable : Download Windows forms provides us with the RichTextBox that provides us with rich editing featues like colors , fonts and other formatting options. The SqlLighter control is just an extension of using this windows control to beautify a SQL statament that I developed as part of an existing project. This [...]

SharpClaw is an attempt to write a (somewhat)SQL compliant database server in C# (like SQL Server of MySQL). Ideveloped it in my spare time, and although it has some areas whichneed much improvement, it is a fine piece of work so far. You will needto know a bit of SQL to use SharpClaw, but I'm [...]

Recently I had a need to be able to backup andrestore databases from c#. I referred to the SQLDMO object and found itto be quite simple. The sample code will show you a simple method fordoing backup/restore of SQL Server databases on a local network. I say"simple" because there are more complex and detailed methods [...]

Download SQLDMO.zip Many times I have had a need to get at SQL Server details in my applications.  Until recently I had to use API calls and bastardized ADO calls to get the information I needed.  Now we have SQLDMO  (SQL Distributed Management Objects) .  Although not widely known or used, SQLDMO provides a very [...]

"This time, I would take a quick but a thoughtprovoking aspects of what happens with XML knits with a database inMicrosoft World." Extensible Stylesheet Language Shape ups (XSLT)When companies exchange data, their schemas will more than likely beinconsistent. One company might use CustomerID as an element name whileanother might simply use ID. Extensible Stylesheet Language [...]

The ODBC .NET Data Provider is an add-oncomponent to the Microsoft .NET Framework Software Development Kit(SDK). It provides access to native ODBC drivers the same way that theOLE DB .NET Data Provider provides access to native OLE DB Providers.Although the ODBC .NET Data Provider is intended to work with allcompliant ODBC drivers, it has only [...]