SqlDataReader « Database ADO.net « VB.Net






  1. VB.Net
  2. Database ADO.net
  3. SqlDataReader
1.Use SqlDataReader.Read to read result setUse SqlDataReader.Read to read result set
2.From SqlDataReader get Column NameFrom SqlDataReader get Column Name
3.Format data when reading the data from SqlDataReaderFormat data when reading the data from SqlDataReader
4.Get number of columns in SqlDataReaderGet number of columns in SqlDataReader
5.Get info about each column: Name, Ordinal and FieldTypeGet info about each column: Name, Ordinal and FieldType
6.Get data from SqlDataReader by Data typeGet data from SqlDataReader by Data type
7.Use column name to index dataUse column name to index data
8.Employee Table Metadata