Get table schema from SqlDataReader : Column Type Name « ADO.Net « C# / CSharp Tutorial

C# / CSharp Tutorial 1.  Language Basics 2.  Data Type 3.  Operator 4.  Statement 5.  String 6.  struct 7.  Class 8.  Operator Overload 9.  delegate 10.  Attribute 11.  Data Structure 12.  Assembly 13.  Date Time 14.  Development 15.  File Directory Stream 16.  Preprocessing Directives 17.  Regular Expression 18.  Generic 19.  Reflection 20.  Thread 21.  I18N Internationalization 22.  GUI Windows Forms 23.  2D 24.  Design Patterns 25.  Windows 26.  XML 27.  ADO.Net 28.  Network 29.  Directory Services 30.  Security 31.  unsafe Microsoft Office Word 2007 Tutorial Java Java Tutorial Java Source Code / Java Documentation Java Open Source Jar File Download Java Articles Java Products Java by API C# / C Sharp ASP.Net JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial PHP Python SQL Server / T-SQL Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial

C# / CSharp Tutorial » ADO.Net » Column Type Name   27. 39. 2. Get table schema from SqlDataReader   using System; using System.Data; using System.Data.SqlClient; class MainClass {    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 rdr = cmd.ExecuteReader();          DataTable schema = rdr.GetSchemaTable();          foreach (DataRow row in schema.Rows)           {             foreach (DataColumn col in schema.Columns)                Console.WriteLine(col.ColumnName + " = " + row[col]);          }          rdr.Close();       }       catch(Exception e)       {          Console.WriteLine("Error Occurred: " + e);       }       finally       {          conn.Close();       }    } }          ColumnName = ID ColumnOrdinal = 0 ColumnSize = 4 NumericPrecision = 10 NumericScale = 255 IsUnique = False IsKey = BaseServerName = BaseCatalogName = BaseColumnName = ID BaseSchemaName = BaseTableName = DataType = System.Int32 AllowDBNull = True ProviderType = 8 IsAliased = IsExpression = IsIdentity = False IsAutoIncrement = False IsRowVersion = False IsHidden = IsLong = False IsReadOnly = False ProviderSpecificDataType = System.Data.SqlTypes.SqlInt32 DataTypeName = int XmlSchemaCollectionDatabase = XmlSchemaCollectionOwningSchema = XmlSchemaCollectionName = UdtAssemblyQualifiedName = NonVersionedProviderType = 8 ColumnName = FirstName ColumnOrdinal = 1 ColumnSize = 10 NumericPrecision = 255 NumericScale = 255 IsUnique = False IsKey = BaseServerName = BaseCatalogName = BaseColumnName = FirstName BaseSchemaName = BaseTableName = DataType = System.String AllowDBNull = True ProviderType = 10 IsAliased = IsExpression = IsIdentity = False IsAutoIncrement = False IsRowVersion = False IsHidden = IsLong = False IsReadOnly = False ProviderSpecificDataType = System.Data.SqlTypes.SqlString DataTypeName = nchar XmlSchemaCollectionDatabase = XmlSchemaCollectionOwningSchema = XmlSchemaCollectionName = UdtAssemblyQualifiedName = NonVersionedProviderType = 10 ColumnName = LastName ColumnOrdinal = 2 ColumnSize = 10 NumericPrecision = 255 NumericScale = 255 IsUnique = False IsKey = BaseServerName = BaseCatalogName = BaseColumnName = LastName BaseSchemaName = BaseTableName = DataType = System.String AllowDBNull = True ProviderType = 10 IsAliased = IsExpression = IsIdentity = False IsAutoIncrement = False IsRowVersion = False IsHidden = IsLong = False IsReadOnly = False ProviderSpecificDataType = System.Data.SqlTypes.SqlString DataTypeName = nchar XmlSchemaCollectionDatabase = XmlSchemaCollectionOwningSchema = XmlSchemaCollectionName = UdtAssemblyQualifiedName = NonVersionedProviderType = 10 ColumnName = Salary ColumnOrdinal = 3 ColumnSize = 8 NumericPrecision = 15 NumericScale = 255 IsUnique = False IsKey = BaseServerName = BaseCatalogName = BaseColumnName = Salary BaseSchemaName = BaseTableName = DataType = System.Double AllowDBNull = True ProviderType = 6 IsAliased = IsExpression = IsIdentity = False IsAutoIncrement = False IsRowVersion = False IsHidden = IsLong = False IsReadOnly = False ProviderSpecificDataType = System.Data.SqlTypes.SqlDouble DataTypeName = float XmlSchemaCollectionDatabase = XmlSchemaCollectionOwningSchema = XmlSchemaCollectionName = UdtAssemblyQualifiedName = NonVersionedProviderType = 6 ColumnName = Birthday ColumnOrdinal = 4 ColumnSize = 8 NumericPrecision = 23 NumericScale = 3 IsUnique = False IsKey = BaseServerName = BaseCatalogName = BaseColumnName = Birthday BaseSchemaName = BaseTableName = DataType = System.DateTime AllowDBNull = True ProviderType = 4 IsAliased = IsExpression = IsIdentity = False IsAutoIncrement = False IsRowVersion = False IsHidden = IsLong = False IsReadOnly = False ProviderSpecificDataType = System.Data.SqlTypes.SqlDateTime DataTypeName = datetime XmlSchemaCollectionDatabase = XmlSchemaCollectionOwningSchema = XmlSchemaCollectionName = UdtAssemblyQualifiedName = NonVersionedProviderType = 4 27. 39. Column Type Name 27. 39. 1.  ResultSet Metadata: table column name and type 27. 39. 2.  Get table schema from SqlDataReader

w_w___w.__j_a__v___a__2___s___.com_ | Contact Us

Copyright 2003 - 08 Demo Source and Support. All rights reserved.

All other trademarks are property of their respective owners.