ADO.NET Tutorials - ITFunda.Com

How to check for the existence of record into the database?

To check whether a record exists into the database or not, we can follow this approach.

Technology covered: ASP.NET ADO.NET
Type: Tips and Tricks (Books)

More details ...

How to use transactions in ADO.NET?

To guarantee that failing execution of one sql statements in the group of statements rollback changes made by other successful statements as well, we can use this approach. So in this approach either all sql statemetns executes successfully or none executes.

Technology covered: ASP.NET ADO.NET
Type: Tips and Tricks (Books)

More details ...

How to work with multiple results set using and SqlDataReader?

To retrieve more than one result sets using Stored Procedure or multiple select statements in one go using SqlDataReader, we can follow this approach.

Technology covered: ASP.NET ADO.NET
Type: Tips and Tricks (Books)

More details ...

How to work with multiple results set using DataSet?

To retrieve more than one result sets from the Stored Procedure or multiple select statements at one go using DataSet, we can use this approach.

Technology covered: ASP.NET ADO.NET
Type: Tips and Tricks (Books)

More details ...

How to retrieve records from SqlDataReader?

To retrieve records from the database using SqlDataReader and getting their values by iterating through them, we can use this approach.

Technology covered: ASP.NET ADO.NET
Type: Tips and Tricks (Books)

More details ...

How to bind data using SqlDataReader and where to use SqlDataReader?

To retrieve data from database using xxxDataReader and bind to the data controls, we can follow this approach. This also explains in which scenario we should use xxxDataReader.

Technology covered: ASP.NET ADO.NET
Type: Tips and Tricks (Books)

More details ...

How to retrieve the saved imaged into database and show them on the page?

To retrieve and show saved images from the database inside asp:GridView we can follow this approach.

Technology covered: ASP.NET ADO.NET
Type: Tips and Tricks (Books)

More details ...

How to save the Image into the database using Stored Procedure?

To save the image into the database (using stored procedure), we can follow this approach.

Technology covered: ASP.NET ADO.NET
Type: Tips and Tricks (Books)

More details ...

How to use the stored procedure in ADO.NET?

To use stroed procedure to retrieve records from the database, we can follow this approach.

Technology covered: ASP.NET ADO.NET
Type: Tips and Tricks (Books)

More details ...