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

   class SchemaTable
   {
      static void Main(string[] args)
      {
         string ConnectionString = "server=(local)\\SQLEXPRESS;database=Store;Integrated Security=SSPI";
         SqlConnection MySqlConnection = new SqlConnection(ConnectionString);

            MySqlConnection.Open();
            SqlCommand MySqlCommand = new SqlCommand("select * from ItemMaster", MySqlConnection);
            SqlDataReader MySqlDatareader = MySqlCommand.ExecuteReader();

            DataTable MyDataTableSchema = MySqlDatareader.GetSchemaTable();

            foreach (DataRow MyDataRowRow in MyDataTableSchema.Rows)
            { 
               foreach (DataColumn MyDataColumn in schema.Columns){
                  Console.WriteLine(MyDataColumn.ColumnName + " = " + MyDataRowRow[col]);
               }
            }
            MySqlDatareader.Close();
            MySqlConnection.Close();
      }  
   }