现在数据库的使用非常普及,随着大数据时代的发展,数据库与编程语言之间的联系更加紧密,该方法反馈的列表名字以字母顺序排列
public static string[] GetColNames(string _connectionstr, int _tablenumber) //ok aber in Alphabet
{
OleDbConnection Connection = new OleDbConnection(@_connectionstr);
try
{
Connection.Open();
DataTable schemaTable = Connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
DataRow dr = schemaTable.Rows[_tablenumber];
DataTable columnTable = Connection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[] { null, null, dr["TABLE_NAME"].ToString(), null });
int n = columnTable.Rows.Count;
string[] resultnames = new string[n];