Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Schema Table from SqlDataReader

using System; using System.Data; using System.Data.SqlClient;     class SchemaTable     {         static void Main(string[] args)         {             string connString = @"server = .\sqlexpress;integrated security = true;database = northwind";             string sql = @"select * from employees";             SqlConnection conn = new SqlConnection(connString);             try             {                 conn.Open();                 SqlCommand cmd = new SqlCommand(sql, conn);                 SqlDataReader rdr = cmd.ExecuteReader();                 DataTable schema = rdr.GetSchemaTable();                 foreach (DataRow row in schema.Rows)                 {                     foreach (DataColumn col in schema.Columns)                         Console.WriteLine(col.ColumnName + " = " + row[col]);                 }                 rdr.Close();             }             catch (Exception e)             {                 Console.WriteLine("Error Occurred: " + e);             }             finally             {                 conn.Close();             }          }     }