How to get Column Names and Types of MDB Database using C#
try this code
var query = $@"select * from myTable";
DataAdapter dataAdapter = new OleDbDataAdapter(query, con);
var dt = new DataTable();
var ds = new DataSet();
dataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
dataAdapter.ReturnProviderSpecificTypes = true;
dataAdapter.Fill(ds);
dt = ds.Tables[0];
dataAdapter.Dispose();
//NOTE: foreach did not work for me
for(int i = 0; i < dt.Rows.Count; i++)
{
var colName = dt.Columns[i].ColumnName;
var colType = dt.Columns[i].DataType.Name;
}