C#

BradNorthA wrote:

Hope you understood the issue. I just have to update the settings whenever the config file gets changed. I tried with the below code in my class constructor as suggested by you. Still its not updating.

Properties.Settings.Default.Save();

Properties.Settings.Default.Reload();

Bastard Programmer from Hell

Chris Maunder wrote:

be surrogates for doing one's own research.

SHOW [FULL] TABLES [{FROM | IN} db_name]
    [LIKE 'pattern' | WHERE expr]

SELECT Table_Name FROM Information_Schema.Tables WHERE Table_Type = 'BASE TABLE' AND Table_Schema = 'yourSchema'

public override List<string> GetTableNames() {
	using (OleDbConnection con=new OleDbConnection(connectionString)) {
		con.Open();
		DataTable dt=con.GetSchema("Tables");
		List<string> tableNames=new List<string>();
		foreach (DataRow row in dt.Rows) {
			string tableName=(string)row["TABLE_NAME"];
			tableNames.Add(tableName);
		}
		return tableNames;
	}
}