Get Column data type and name from DataColumn : Table Schema « Database ADO.net « C# / C Sharp






Get Column data type and name from DataColumn

Get Column data type and name from DataColumn

using System;
using System.Data;
using System.Data.OleDb;

public class DatabaseInfo {    
 public static void Main () { 
   String connect = "Provider=Microsoft.JET.OLEDB.4.0;data source=.\\Employee.mdb";
   OleDbConnection con = new OleDbConnection(connect);
   con.Open();  
   Console.WriteLine("Made the connection to the database");

   String cmd = "SELECT * FROM Employee"; 
   OleDbDataAdapter adapter = new OleDbDataAdapter();
   adapter.SelectCommand = new OleDbCommand(cmd, con);
   DataSet ds = new DataSet();
   adapter.Fill(ds, "Employee");
   DataTable item = ds.Tables[0];
   Console.WriteLine("Table name: {0}", item.TableName);
   Console.WriteLine("Its columns are:");
   foreach (DataColumn col in item.Columns)
     Console.WriteLine("{0}\t{1}", col.ColumnName, col.DataType);

   con.Close();
 }
}
 
           
       








Related examples in the same category

1.Get all table namesGet all table names
2.Get specified column data type and column name from OleDbSchemaTableGet specified column data type and column name from OleDbSchemaTable
3.Read schema information using the FillSchema() method of a DataAdapter object
4.How to read a table schema
5.Get table Schema