German Wear Discount Shop - Click Here Write for Dotnet-friends and earn for your each submission [Dot]Net-Friends
Skip Navigation Links
Home
Latest
Fast Code
Articles
Tutorials
Online Resources
Forums
Login   | Hi, Guest


Getting Schema of a Table using GetSchemaTable
Written By Dotnet Friends On 07/11/2007

GetSchemaTable is used to get schema of the Queried Table from the Databe. The result can be used to discover the schema components.

Views: 674
Rating: 4.5
Login to Rate
dotnet-friends
Tagged Under: ADO .NET, Database, SQL Server 2005

Explanation:

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();
         }
      }  
   }
Delicious Digg reddit reddit Technorati
About the Author:

@@ Omer Kamal is a Software Developer at Eidanza GmbH Germany. He is Founder of FriendsPoint.de and Dotnet-Friends.com. He is currently Involved with SharePoint 2007, SharePoint Services 3.0 and BI Portal Solutions (Microsoft Dynamics Customization).
Check Dotnet Friends Profile

Related Useful Links:
Visitors/Readers Comments
(for questions please use The Forum)



"Be the First to Comment!"


Add your Comments

Name:  
Message:
Note: For faster response please use Forums >> for your questions instead of the comments area! (Admin)