Archive | Data Access RSS feed for this section

Modifying Oracle Records Using C#

The following source code connects to OracleEmp table. It allows you to delete, edit, add and save records to thetable. Dataset and DataAdapters are used. Download Source

Read more

Oracle Connectivity

Here is a code sample of how to connect to an Oracle database using C#. Download source

Read more

Delete Record Mechanism When There Are Related Records

It is quite an often situation that duringdeletion of a record from the database there is a need to perform someaction with all related records: delete related records, reassign themto another record (change foreign key), or remove information aboutrelation (null foreign key). The mechanism described below will allowyou to deal with this issue. Delete record [...]

Read more

Using ADO.NET Database 1 for beginners

Introduction This is a simple ADO.NET database application that returns results from a database table, writes the output to a DataGrid and TextBoxes, and uses Buttons to navigate through records. It is including: 1. Connection to a ADO.NET database 2. Use of a DataSet to fill with records 3. Use of a DataAdapter to load [...]

Read more

RMSDataAccessLayer

The main idea of devloping such a DAL is that,to separate the SQL execution from the client/end user and maintain iton the server side, there by reducing the number of direct simultanwousconnection to the sql server. The following are the various .net concepts you will find in the RMSDAL.Net remoting – to run the remote [...]

Read more

Navigation Through Records With TrackBar(Slider)

Introduction This application will show a different way how to navigate through records in a data source with a TrackBar (Slider) by using either the mouse or the direction keys(Left, Right, Up, Down). When you move the slider, the trackbar sends notification messages to indicate the change. If you reach the end or beginning of [...]

Read more

Populate Data from a Table in a ComboBox

This article is my own approach on how to get data populated in a ComboBox.It shows also how to get connected to a MS-Access database which you can also find in the project included(sudentDB.mdb). After having seen C#-newbies in some C#-Help-message-boards asking about the 'how to get data into ComboBox', I wanted to create a [...]

Read more

NAVIGATION in the Data source

Introduction This simple application will demonstrate -how to navigate with buttons in the data(Next, Previous, First, Last) and -how to get connection to the database Nortwind(Customers, Orders). A brief descriptionYou can control navigation: 1.using a navigational control such as a ListBox or DataGrid.2. you can also control navigation programmatically by directly interacting with the CurrencyManager. [...]

Read more

Real Life SQL and .NET

Welcome to the world of SQL and the huge,growing database technologies of today's business all over the SQLworld. By reading this article, we have begun accepting the knowledgethat will soon be required for survival in today's world of relationaldatabase and data management. Alas, for the reason that it is firstnecessary to provide a background of [...]

Read more

SQL Server 2005 Our New Possibility

Iconsider Yukon to be a new way of supporting Microsoft.NET. In fact,when I heard about Yukon I began to ask myself many questions like "Howwill Yukon support .NET?", "What will make me go for Yukon?" , "Whatare Yukon's features?", after some researches on my own I found theanswers and I'd like to share them with [...]

Read more