C# Help

By Sanjay H. Rao This is a GUI based data entry application which shows how to add, modify and delete records using Oracle Database. This also shows how to use the ErrorProvider for validations. There are many applications which have been developed using SQL Server. However, there are many people using Oracle as a database. [...]

.NET provides easy access to any type of database through the OLE DB provider (System.Data.OleDb). Of course we could connect to a data source also through ODBC, but firstly we should download the.NET ODBC driver from the Microsoft site. Here is an example of how to open MySQL database through OLE DB Provider in C#. [...]

Download Source: DotNetData.zip The example defines the prototype for accessing the data through ADO .Net objects in C#. For any given database table there are 4important operations while working with relational tables anddatabases. The 4 different operations, which can be done on thedatabase, are ADD, UPDATE, DELETE and SELECT. This prototype gives the users (especiallythose [...]

Source Code: MappingObjsLC.zip This article explains how you can map databasetables to C# objects. In other words, The application generates C#Class files for each table in a relational database. I have used Mysqland ODBC.NET for this project. The application only supports MySQLright now. However, it is easy to port to other databases. I will do [...]

  INTRODUCTION Web Services has been the most revolutionaryaspect of the .NET framework developed by Microsoft. This articlepresents the three different modes through which data can be accessedviz. through web services, stored procedures and SQL Query using thepower of ADO.NET and XML. Accessing Data through Stored Procedures/SQL Queries Case: Displaying Data in a Data Grid [...]

INTRODUCTION: The Interoperability services make it veryeasy to work with COM Capable Applications such as Word and Excel. Thisarticle reveals using Excel from a managed application. Excel is thespreadsheet component of Microsoft Office 2000. The majority of Excelprogrammatic functionality is exposed through Automation via the typelibrary Excel9.olb. The intention of this article is to express [...]

This is a small CGI Aplication built with Visual C# .Net Beta 2, to test this application you must haveat least SQL Server 7 (running Northwind database) and IIS 5.0 installed. Steps to test the application: 1- Create an account for the Internet Users in SQL 7 (normally IUSR_YourComputerName). – Open SQL 7 "Enterprise Manager". [...]

  By far, the most important application for current applications as well asfuture applications is the management of information (students lists, customerorders, CD labels, etc) through a database system. In this handout we are goingto create an application that allows the user to navigate through a database andalso provides the capabilities to update. Navigating through [...]

By P.T Sahul Hameed This is a simple C# Program that illustrate the usage of DataGrid with DataSet. Create Database and Table accordingly. /* * Simple C# example to illustrate the usage of Dataset with DataGrid * Need to change the url and query accordingly */ using System; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Windows.Forms; [...]

This is a GUI based data entry applicationwhich shows how to add, modify and delete records using OracleDatabase. This also shows how to use the ErrorProvider for validations. There are many applications which have beendeveloped using SQL Server. However, there are many people using Oracleas a database. So, in this article I'll show how an [...]