Get a database table properties

This program displays your table properties such as its column names, types, and column properties. I have used a database "mcTest.mdb" which has a table called 'Developer'. You can download this attached database and change the path of the database according to your location.

Explanation

I have used ADODataSetCommand, DataSet, DataTable, and DataColumn classes to do so. See my forthcoming tutorial on ADO.NET for more details of these classes.

private void Form1_Load(object sender, System.EventArgs e) {
string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\mcTest.MDB";
string strSQL = "SELECT * FROM Developer";
// create Objects of ADOConnection and ADOCommand
OleDbConnection myConn = new OleDbConnection(strDSN);
OleDbDataAdapter myCmd = new OleDbDataAdapter(strSQL, myConn);
myConn.Open();
DataSet dtSet = new DataSet();
myCmd.Fill(dtSet, "Developer");
DataTable dt = dtSet.Tables[0];
listBox1.Items.Add("Field Name DataType Unique AutoIncrement AllowNull");
listBox1.Items.Add("=================================");
foreach(DataColumn dc in dt.Columns) {
listBox1.Items.Add(dc.ColumnName + " , " + dc.DataType + " ," + dc.Unique + " ," + dc.AutoIncrement + " ," + dc.AllowDBNull);
}
}

How to Run?

Download source code and database zip files and unzip them.
Change the database path in this string. "Provider=Microsoft.JET.OLEDB.4.0;data source=C:\\Mahesh\\mcb.mdb");
Run the application