how to read a table schema : SqlDataReader : ADO.Net C# Examples

how to read a table schema

    
using  System;
using  System.Data;
using  System.Data.SqlClient;

class  SchemaOnlyCommandBehavior  {
        public  static  void  Main()  {
                SqlConnection  mySqlConnection  =  new  SqlConnection("server=localhost;database=Northwind;uid=sa;pwd=sa");

                SqlCommand  mySqlCommand  =  mySqlConnection.CreateCommand();
                mySqlCommand.CommandText  =  "SELECT  ProductID,  ProductName,  UnitPrice  FROM  Products  WHERE  ProductID  =  1";

                mySqlConnection.Open();
                SqlDataReader  productsSqlDataReader  =  mySqlCommand.ExecuteReader(CommandBehavior.SchemaOnly);
                DataTable  myDataTable  =  productsSqlDataReader.GetSchemaTable();

                foreach  (DataRow  myDataRow  in  myDataTable.Rows)  {
                        foreach  (DataColumn  myDataColumn  in  myDataTable.Columns)  {
                                Console.WriteLine(myDataColumn  +  "=  "  +  myDataRow[myDataColumn]);
                                if  (myDataColumn.ToString()  ==  "ProviderType")  {
                                        Console.WriteLine(myDataColumn  +  "=  "  +  ((System.Data.SqlDbType)myDataRow[myDataColumn]));
                                }
                        }
                }

                productsSqlDataReader.Close();
                mySqlConnection.Close();
        }
}
    
   
  
   

Related in same category :
• SqlDataReader
• Use SQL Server Data Provider
• Reference result set by column name in SqlDataReader
• Reference result set by column index in SqlDataReader
• OrdinalIndexer
• Use loop to read all data in SqlDataReader
• Use SqlDataReader to retrieve data in the resultset
• Get data by data type using SqlDataReader
• Using a DataReader to read row by row
• Updating Data Using CommondBuilder
• SqlDataReader
• Typed Accessors
• SqlDataReader.GetString, GetDateTime
• Use indexer to read data