如何以编程方式在ODBC中获取表的列名? [英] how to get column names of a table in ODBC programatically?

问题描述

我需要以编程方式获取ODBC oe OLE DB中表的列名.
我应该使用哪些函数或方法?

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

推荐答案

尝试一下..，这可能对您有帮助..

使用oledb连接获取DataTable之后.

用这个

Try this.., This may help you..

After you getting the DataTable using oledb connection.

use this

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

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

这篇关于如何以编程方式在ODBC中获取表的列名?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！