Dotnet-Friends.com | Get schema information using the FillSchema() method of a DataAdapter using ADO.NET,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

Get schema information using the FillSchema() method of a DataAdapter using ADO.NET

Written By Dotnet Friends On 07/11/2007

How use FillSchema() method of a DataAdapter in ADO .NET

Views: 855

Rating: 3.75

Login to Rate

Tagged Under: ADO .NET, Database, SQL Server 2005

Explanation:

using System;
using System.Data;
using System.Data.SqlClient;

class FillSchema
{
  public static void Main()
  {
    SqlConnection mySqlConnection =new SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;");

    SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
    mySqlCommand.CommandText =
      "SELECT ProductID, ProductName " +
      "FROM Products;" +
      "SELECT OrderID " +
      "FROM Orders;" +
      "SELECT OrderID, ProductID, UnitPrice " +
      "FROM [Order Details];";
    SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
    mySqlDataAdapter.SelectCommand = mySqlCommand;
    DataSet myDataSet = new DataSet();
    mySqlConnection.Open();
    mySqlDataAdapter.FillSchema(myDataSet, SchemaType.Mapped);
    mySqlConnection.Close();
    myDataSet.Tables["Table"].TableName = "Products";
    myDataSet.Tables["Table1"].TableName = "Orders";
    myDataSet.Tables["Table2"].TableName = "Order Details";

    foreach (DataTable myDataTable in myDataSet.Tables)
    {
      Console.WriteLine("\n\nReading from the " +
        myDataTable + "DataTable:\n");

      foreach (DataColumn myPrimaryKey in myDataTable.PrimaryKey)
      {
        Console.WriteLine("myPrimaryKey = " + myPrimaryKey);
      }

      foreach (Constraint myConstraint in myDataTable.Constraints)
      {
        Console.WriteLine("myConstraint.IsPrimaryKey = " + ((UniqueConstraint) myConstraint).IsPrimaryKey);
        foreach (DataColumn myDataColumn in ((UniqueConstraint) myConstraint).Columns)
        {
          Console.WriteLine("myDataColumn.ColumnName = " + myDataColumn.ColumnName);
        }
      }

      foreach (DataColumn myDataColumn in myDataTable.Columns)
      {
        Console.WriteLine("\nmyDataColumn.ColumnName = " + myDataColumn.ColumnName);
        Console.WriteLine("myDataColumn.DataType = " + myDataColumn.DataType);

        Console.WriteLine("myDataColumn.AllowDBNull = " + myDataColumn.AllowDBNull);
        Console.WriteLine("myDataColumn.AutoIncrement = " + myDataColumn.AutoIncrement);
        Console.WriteLine("myDataColumn.AutoIncrementSeed = " + myDataColumn.AutoIncrementSeed);
        Console.WriteLine("myDataColumn.AutoIncrementStep = " + myDataColumn.AutoIncrementStep);
        Console.WriteLine("myDataColumn.MaxLength = " + myDataColumn.MaxLength);
        Console.WriteLine("myDataColumn.ReadOnly = " + myDataColumn.ReadOnly);
        Console.WriteLine("myDataColumn.Unique = " + myDataColumn.Unique);
      }
    }
  }
}

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