SqlDataReader « Database ADO.net « C# / C Sharp






  1. C# / C Sharp
  2. Database ADO.net
  3. SqlDataReader
1.Execute multiple SELECT statements using a SqlCommand object and read the results using a SqlDataReader object
2.Get column index from SqlDataReader
3.use the GetOrdinal() from DataReader to get the numeric positions of a column
4.how to read column values as C# types using the Get* methods
5.read column values as Sql* types using the GetSql* methods
6.Read data from SqlDataReader
7.Reference data in SqlDataReader by column name
8.Use A Data Reader
9.Use While loop to read query result data from SqlDataReader




10.Deal with Multiple Results
11.SqlDataReader Ordinal Indexer