SqlDataReader Class

hi,

please refer following sites.

http://www.dotnetperls.com/sqldatareader
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.aspx

http://stackoverflow.com/questions/4290986/sql-data-reader-class

hope this help.

The SqlDataReader class is part of the System.Data.SqlClient namespace. It has designed to read the data from the connected sql server. It can only read the data from the sql server and connection oriented. While reading the data it should have the connection.

The sql data reader is designed to move forward and it cannot come front and fourth while iterating the sql data reader. The SqlCommand has the connection and the required table/sql query/ stored procedure to retrieve the data from the database.

SqlConnection sqlConnection = new SqlConnection(connectionString);
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand("SELECT * FROM Product",sqlConnection);
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();

Now the sqldatareader has the record set and it can be iterated to manipulate the data.

The main advantages is it will not bulk loaded and it will load the data on demand. So it will improve the performance significantly. The disadvantages is it always needs the connection.