public void PopulateAppSettings()
{
int columnCount = 8;
grid.SetColumnCount(columnCount);
TreeViewColumn tvc;
tvc = grid.CreateColumn(COL_Setting, "Setting");
grid.View.AppendColumn(tvc);
tvc = grid.CreateColumn(COL_Provider, "Provider");
grid.View.AppendColumn(tvc);
tvc = grid.CreateColumn(COL_Server, "Server");
grid.View.AppendColumn(tvc);
tvc = grid.CreateColumn(COL_Database, "Database");
grid.View.AppendColumn(tvc);
tvc = grid.CreateColumn(COL_UserID, "User ID");
grid.View.AppendColumn(tvc);
tvc = grid.CreateColumn(COL_Options, "Options");
grid.View.AppendColumn(tvc);
tvc = grid.CreateColumn(COL_ConnectionString, "ConnectionString");
grid.View.AppendColumn(tvc);
NameValueCollection settings = ConfigurationSettings.AppSettings;
int num = 1;
foreach (String sName in settings.AllKeys)
{
string connectionString = settings[sName];
ConnectionString conString = new ConnectionString(connectionString);
string factory = conString.Parameters["FACTORY"];
string server = conString.Parameters["SERVER"];
if (server == null)
{
server = conString.Parameters["DATA SOURCE"];
}
if (server == null)
{
server = conString.Parameters["NETWORK ADDRESS"];
}
if (server == null)
{
server = conString.Parameters["ADDRESS"];
}
if (server == null)
{
server = conString.Parameters["ADDR"];
}
string database = conString.Parameters["DATABASE"];
if (database == null)
{
database = conString.Parameters["INITIAL CATALOG"];
}
string userid = conString.Parameters["USER ID"];
if (userid == null)
{
userid = conString.Parameters["USER"];
}
if (userid == null)
{
userid = conString.Parameters["UID"];
}
string otherOptions = conString.GetOtherOptions();
TreeIter row = grid.NewRow();
grid.SetColumnValue(row, COL_Setting, sName);
grid.SetColumnValue(row, COL_Provider, factory);
grid.SetColumnValue(row, COL_Server, server);
grid.SetColumnValue(row, COL_Database, database);
grid.SetColumnValue(row, COL_UserID, userid);
grid.SetColumnValue(row, COL_Options, otherOptions);
grid.SetColumnValue(row, COL_ConnectionString, connectionString);
num++;
}
grid.View.Model = grid.Store;
grid.View.Selection.Changed += new EventHandler(OnSelectionChanged);
}
