Mega Code Archive

 

Categories / C# / ADO Database

 

Get table Schema

using System; using System.Data; using System.Data.SqlClient;    class SchemaTable    {       static void Main(string[] args)       {          string connString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";          string sql = @"select * from employee";          SqlConnection conn = new SqlConnection(connString);          try {             conn.Open();             SqlCommand cmd = new SqlCommand(sql, conn);             SqlDataReader reader = cmd.ExecuteReader();             DataTable schema = reader.GetSchemaTable();             foreach (DataRow row in schema.Rows)             {                 foreach (DataColumn col in schema.Columns){                   Console.WriteLine(col.ColumnName + " = " + row[col]);                   Console.WriteLine("Null value allowed: " + col.AllowDBNull);                }             }             reader.Close();          } catch(Exception e) {             Console.WriteLine("Error Occurred: " + e);          } finally {             conn.Close();          }       }      }