Dotnet-Friends.com | Getting Schema of a Table using GetSchemaTable ,Dotnet Friends

Write for Dotnet-friends and earn for your each submission

Home

Latest

Fast Code

Articles

Tutorials

Online Resources

Forums

	Home

Forums

Tutorials

Articles

Fast Code

Selected Articles

Online Resources

ASP.NET NEWS

ASP.NET Latest

ASP.NET Blogs

ScottGu's Blog

4GuysFromRolla

The Code Project

ASP Alliance

Dotnetbips

Donations

Search Members

Search Web

Your IP Address

Sister Website FriendsPoint.de

Add Yours

Write an Article
Write a Tutorial
Add a Fast Code*
*Fast Code might be any helpful code with brief comment

Sponsors Links

Stem Cells
Blood Banks
Insurances
.Net Hosting
Credit Cards
PC Rental
Business

Our Feeds(RSS)

Tutorials:
ASP .NET
C# .NET
VB .NET
Articles:
ASP .NET
C# .NET
VB .NET
Fast Code:
ASP .NET
C# .NET
VB .NET

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

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

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