private void buttonConnect_Click(object sender, EventArgs e)
{
try
{
if (buttonConnect.Text == "Connect")
{
var result = ((comboBoxProject.Items[comboBoxProject.SelectedIndex]) as GetUserProjectsResult);
string connectionString = "";
//Start of: check connection
if (result.Provider == "OLEDB")
{
connectionString = Global.GetConnectionString(result.File, result.UserID, result.Password, result.HasOtherDetails.Value, result.MDW);
classCheckConnection = new ClassCheckConnection(connectionString, Global.DataProvider.OLEDB);
}
else if (result.Provider == "SQL")
{
connectionString = Global.GetConnectionString(result.Datasource, result.DatabaseName, result.UserID, result.Password);
classCheckConnection = new ClassCheckConnection(connectionString, Global.DataProvider.SQL);
}
if (!classCheckConnection.CheckConnection())
{
Global.ShowMessage("Connection Failed.\n\nPlease check.", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
//End of: check connection
treeProject.Nodes["NodeHeader"].Nodes["NodeName"].Text = "Name: " + result.Name;
treeProject.Nodes["NodeHeader"].Nodes["NodeDescription"].Text = "Description: " + result.Desc;
if (result.Provider == "OLEDB")
{
foreach (TreeNode n in treeProject.Nodes["NodeHeader"].Nodes)
{
if (n.Name == "NodeDatasource" || n.Name == "NodeDatabaseName")
n.Remove();
}
treeProject.Nodes["NodeHeader"].Nodes.Add("NodeDatabase", "Database: " + result.File);
Global.ProjectDataProvider = Global.DataProvider.OLEDB;
}
else if (result.Provider == "SQL")
{
foreach (TreeNode n in treeProject.Nodes["NodeHeader"].Nodes)
{
if (n.Name == "NodeDatabase")
n.Remove();
}
treeProject.Nodes["NodeHeader"].Nodes.Add("NodeDatasource", "Datasource: " + result.Datasource);
treeProject.Nodes["NodeHeader"].Nodes.Add("NodeDatabaseName", "Database Name: " + result.DatabaseName);
Global.ProjectDataProvider = Global.DataProvider.SQL;
}
Global.ProjectConnectionString = connectionString;
}
treeProject.CollapseAll();
SetConnectionStatus();
SetMenuStatus();
}
catch (Exception)
{
throw;
}
}
private void buttonTestConnection_Click(object sender, EventArgs e)
{
try
{
if (radioButtonMSAccess.Checked)
{
if (textBoxFileMDB.Text == "") { Global.ShowMessage("Please select mdb file", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; }
classCheckConnection = new ClassCheckConnection(Global.GetConnectionString(textBoxFileMDB.Text, textBoxAccessUserID.Text, textBoxAccessPassword.Text, checkBoxOtherDetails.Checked, textBoxFileMDW.Text), Global.DataProvider.OLEDB);
}
else
{
string msg = "";
if (textBoxSQLDatasource.Text == "")
msg += "Datasource\n";
if (textBoxSQLDatabaseName.Text == "")
msg += "Database Name\n";
if (msg.Length > 0)
{
Global.ShowMessage("Please fill in required fields.\n\n" + msg, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
classCheckConnection = new ClassCheckConnection(Global.GetConnectionString(textBoxSQLDatasource.Text, textBoxSQLDatabaseName.Text, textBoxSQLUserId.Text, textBoxSQLPassword.Text), Global.DataProvider.SQL);
}
if (classCheckConnection.CheckConnection())
Global.ShowMessage("Connection Succesful!", MessageBoxButtons.OK, MessageBoxIcon.Information);
else
Global.ShowMessage("Connection Failed!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (Exception)
{
throw;
}
}
