Obtain the table name in dbf and the dbf table name.

Obtain the table name in dbf and the dbf table name.

For special needs, you need to obtain the name of the table in the dbf DATABASE. The following solutions are available:

1 public List <string> GetTableFields (string path) 2 {3 List <string> tables = new List <string> (); 4 var dt = GetSchemaTable (ConnectionString ); 5 foreach (DataRow dr in dt. rows) 6 {7 tables. add (dr ["COLUMN_NAME"] as string); 8} 9 return tables; 10} 11 12 private DataTable GetSchemaTable (string connectionString) 13 {14 using (OleDbConnection connection = new15 OleDbConnection (connectionString) 16 {17 connection. open (); 18 DataTable schemaTable = connection. getOleDbSchemaTable (19 OleDbSchemaGuid. columns, 20 new object [] {null, null}); 21 return schemaTable; 22} 23}