how to get column names of a table in ODBC programatically?

Question

0.00/5 (No votes)

See more:

I need to get column names of a table in ODBC oe OLE DB programatically.
Which functions or methods should I use?

Posted 9-Dec-10 0:54am

Comments

fjdiewornncalwe 9-Dec-10 7:18am

What type of data source are you trying to get this information for? (i.e. SQL Server, Oracle, Excel, Access?)

2 solutions

SELECT COLUMN_NAME  FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'tablename'

Posted 9-Dec-10 0:58am

Comments

fjdiewornncalwe 9-Dec-10 8:18am

You're not taking into account that his datasource could be Excel or something like that.

Add a Solution

Treat my content as plain text, not as HTML

…

Sign in to your account

Download, Vote, Comment, Publish.

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)

Rajesh Anuhya · Accepted Answer · 2010-12-09T01:08:00

Try this.., This may help you..

After you getting the DataTable using oledb connection.

use this

DataTable dt = new DataTable();
            dt.Columns[0].ColumnName()

Posted 9-Dec-10 1:08am

Comments

Rajesh Anuhya 9-Dec-10 7:27am

Why it's downvoted???, leave a comment while you are downvoting...

fjdiewornncalwe 9-Dec-10 8:17am

I'll counter... I like your answer a whole lot better than the SQL one above.