SqlDataReader Class

Question

Hi.... How can we define SQLDataReaderClass and define architecture in ADO.NET?

Jignesh Trivedi · Answer

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.

Senthilkumar · Answer

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.

Satyapriya Nayak · Answer

Hi Aaron, SQLDataReaderClass Provides a way of reading a forward-only stream of rows from a SQL Server database. This class cannot be inherited. Please refer the below link http://www.triconsole.com/dotnet/sqldatareader_class.php Thanks

SqlDataReader Class

Answers (3)