private void InitializeConnectionString()
{
try
{
ConnectionStringSettingsCollection csSection = ConfigurationManager.ConnectionStrings;
m_connectionString = csSection["pgsqlconn"].ConnectionString;
dbSelectedName = GetDatabaseName(m_connectionString);
layer = new BusinessLayer(m_connectionString);
lblServerDetails.Text = m_connectionString;
}
catch (Exception exc)
{
throw new Exception(exc.Message);
}
}
//public void threadAction(object sqlStatement)
//{
// var watch = Stopwatch.StartNew();
// DataTable tbl1 = (DataTable)layer.ExecuteBatch(sqlStatement.ToString());
// watch.Stop();
// MessageBox.Show("completed sql statements "+ watch.ElapsedMilliseconds.ToString() + " ms");
//}
private void cmbDatabases_SelectedValueChanged(object sender, EventArgs e)
{
if (cmbDatabases.Text != dbSelectedName)
{
//trebuie sa schimbam stringul de connection se baza selectata
string dbNewName = cmbDatabases.Text;
m_connectionString = m_connectionString.Replace(dbSelectedName, dbNewName);
lblServerDetails.Text = m_connectionString;
layer = new BusinessLayer(m_connectionString);
dbSelectedName = dbNewName;
}
}