Ado.Net Articles

List of Articles in

01) ExecuteReader, ExecuteNonQuery, ExecuteScalar

To retrieve data from the database, we need a database connection. In ADO.Net, based on the Database provider, there are different connection classes. For example, to connect to an Oracle Database we need to use OracleConnection and in the same way, we need SqlConnection to connect to the SQL Server database... Read More

02) Process Multiple Results sets through SQLDataReader

This article explains creating a single SqlCommand object with multiple queries and processing it through the SQL Data Reader object... Read More

03) Retrieve Table schema information

This article explains retrieving the Table Column Name and its data type by making use of the command behavior... Read More

04) Execute a stored procedure

This article explains how a stored procedure can be executed from the Front-End application... Read More

05) Using DataTable and DataAdapter

This article explains how DataTable, DataAdapter, and DataGridControl work together... Read More

06) DataTable and Unique, Primary Key Constraints (Front-End)

We know that “Relational Databases” support “Database Constraints” which helps in maintaining the “Data Integrity” within the database. The same way the constraints can be enforced from the front end itself. In this article, we are going to examine how Unique Constraint and Primary Key constraint can be applied to DataTable... Read More

07) DataTable and ForeignKey Constraints (Front-End)

In “Relational Databases” like Oracle and SQL Server, a “Foreign Key” always refers to a Primary Key in a table. This establishes a relationship between two tables which is called as “Referential Integrity”. We know that a table can have only one Primary Key and can have one or more Unique Keys. In Ado.Net a Foreign Key is not restricted to refer only to Primary Key. That means, it can refer to a Unique...  Read More

No comments:

Post a Comment

Leave your comment(s) here.

Like this site? Tell it to your Friend :)