Sunday, May 10, 2009

Data Retrieval with stored procedure

Introduction
Data Retrieval with stored procedures is the same (surprise!) as if using standard SQL. You can wrap a DataAdapter around the Command object or you can use a DataReader to fetch the data one row at a time.In this example I used the SqlDataReader.

Page Design


SQL Coding Part



C# coding for Button Event

2 comments:

Amila Bandara said...
This comment has been removed by a blog administrator.
database repair tool said...

Database recovery is one of our primary focuses. Look for a company that has realized the importance of database systems have for the clients. There are providers which already developed techniques for recovering databases that have proved to be highly successful.