Get access table Column name and Datatype

Question

0.00/5 (No votes)

See more:

C#

OleDbConnection cn = new ("Provider=Microsoft.ACE.OLEDB.12.0;Data=C:\\Documents and Settings\\User\\My Documents\\Database1.accdb");
                cn.Open();
                
DataTable schemaTable = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new Object[] { null, null, null, "TABLE" });
                //List the table name from each row in the schema table.
                for (int i = 0; i < schemaTable.Rows.Count; i++)
                {
                    string Current_Str = schemaTable.Rows[i].ItemArray[2].ToString();
                }

using the above code i some how got the Table Names in access database.
But how can i extract the individual table's Column Name and Datatypes

Any Suggestions

Posted 4-Sep-11 2:23am

amitk_189

Updated 4-Sep-11 2:24am

RaisKazi

v2

Add a Solution

2 solutions

Solution 2

Try as below code. It will give you all the Column Names and their DataTypes belonging to your DataTable - "schemaTable". Then use it in the way you want.

C#

StringBuilder sbColumnDetails = new StringBuilder();
foreach (DataColumn column in schemaTable.Columns)
{
  sbColumnDetails.Append("Column Name: ");
  sbColumnDetails.Append(column.ColumnName);

  sbColumnDetails.Append(" ");

  sbColumnDetails.Append("Column DataType: ");
  sbColumnDetails.Append(column.DataType.ToString());

 sbColumnDetails.Append(" || ");
}

Posted 4-Sep-11 2:49am

RaisKazi

Updated 4-Sep-11 2:55am

v2

Comments

meerDcoder 28-Sep-20 4:20am

This gives me the names of the columns of the Schema and not the required table. thanks

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Accepted Answer · 2011-09-04T02:35:00

Solution 1

Have a look at this[^] OleDbSchemaTable sample. You should be able to use it to get all the details you are looking for.

Posted 4-Sep-11 2:35am

Abhinav S

Comments

amitk_189 4-Sep-11 9:01am

Got it.
thanks but the answer was in VB.net, with the logic provided in got result in C#.net

Abhinav S 4-Sep-11 9:42am

It should not be too difficult to convert into C#.
You can always use a a tool to do so otherwise.

meerDcoder 28-Sep-20 4:20am

This link is no more there. Please update thanks