Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

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();     } }