Ado.Net Articles

List of Articles in

01) ExecuteReader, ExecuteNonQuery, ExecuteScalar

To retrieve data from the database, we need 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 works together... Read More

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

We know that “Relational Databases” support “Database Constrains” 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

1 comment:

  1. This comment has been removed by a blog administrator.


Leave your comment(s) here.

Like this site? Tell it to your Friend :)