DATAREADER

Question

HOW TO USE DATAREADER IN C#.NET

Subhendu De · Answer

string _connectString = @Data Source=.\SQLEXPRESS;Initial Catalog=TestDB;Integrated Security=True; using (SqlConnection _connection = new SqlConnection(_connectString)) { SqlCommand _command = new SqlCommand(); _command.Connection = _connection; _command.CommandText = SELECT * FROM RDLCTable; _command.CommandType = CommandType.Text; _connection.Open(); IDataReader _reader = _command.ExecuteReader(); while (_reader.Read()) { Console.WriteLine(_reader[Test]); Console.WriteLine(_reader[Param]); } _connection.Close(); }