private void cboProviderType_SelectedIndexChanged(object sender, EventArgs e)
{
var item = cboProviderType.SelectedItem as ItemText <EnumDbProviderType>;
if (item != null)
{
providerType = (EnumDbProviderType)item.Value;
}
if (hints.ContainsKey(providerType))
{
lblHints.Text = "Samples:\r\n\r\n" + hints[providerType];
}
else
{
lblHints.Text = "";
}
switch (providerType)
{
case EnumDbProviderType.Access:
SetVisible(chkEmbedded, false, txtHost, txtDatabase, chkIntegSec, false, txtUserId, txtPassword, numPort, false);
txtDatabase.UseFile = true;
break;
case EnumDbProviderType.Firebird:
SetVisible(chkEmbedded, txtHost, false, txtDatabase, chkIntegSec, false, txtUserId, txtPassword, numPort, false);
SetVisible(txtDatabase, true);
txtDatabase.UseFile = true;
//if (chkEmbedded.Checked)
//{
// SetVisible(txtDatabase, false);
// txtDatabase.UseFile = true;
//}
//else
// txtDatabase.UseFile = false;
break;
case EnumDbProviderType.MariaDB:
SetVisible(chkEmbedded, false, txtHost, txtDatabase, chkIntegSec, txtUserId, txtPassword, numPort);
txtDatabase.UseFile = false;
break;
case EnumDbProviderType.MySql:
SetVisible(chkEmbedded, false, txtHost, txtDatabase, chkIntegSec, txtUserId, txtPassword, numPort);
txtDatabase.UseFile = false;
break;
case EnumDbProviderType.Oracle:
SetVisible(chkEmbedded, false, txtHost, txtDatabase, false, chkIntegSec, txtUserId, txtPassword, numPort);
txtDatabase.UseFile = false;
break;
case EnumDbProviderType.PostgreSQL:
SetVisible(chkEmbedded, false, txtHost, txtDatabase, chkIntegSec, txtUserId, txtPassword, numPort);
txtDatabase.UseFile = false;
break;
case EnumDbProviderType.SQLite:
SetVisible(chkEmbedded, false, txtHost, false, txtDatabase, chkIntegSec, false, txtUserId, false, txtPassword, numPort, false);
txtDatabase.UseFile = true;
break;
case EnumDbProviderType.SqlServer:
SetVisible(chkEmbedded, false, txtHost, txtDatabase, chkIntegSec, txtUserId, txtPassword, numPort);
txtDatabase.UseFile = false;
break;
case EnumDbProviderType.SqlServerCe:
SetVisible(chkEmbedded, false, txtHost, false, txtDatabase, chkIntegSec, false, txtUserId, false, txtPassword, numPort, false);
txtDatabase.UseFile = true;
break;
}
lblPortDefault.Visible = numPort.Visible;
Draw();
SetControls();
}
private void Form1_Load(object sender, EventArgs e)
{
if (!this.DesignMode)
{
controls = new List <DbControl>();
controls.Add(new DbControl(lblEmbedded, chkEmbedded));
controls.Add(new DbControl(lblHost, txtHost));
controls.Add(new DbControl(lblDatabase, txtDatabase));
controls.Add(new DbControl(lblIntegSec, chkIntegSec));
controls.Add(new DbControl(lblUserId, txtUserId));
controls.Add(new DbControl(lblPassword, txtPassword));
controls.Add(new DbControl(lblPort, numPort));
hints = new Dictionary <EnumDbProviderType, string>();
hints.Add(EnumDbProviderType.Access,
"\"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=FILENAME.accdb\r\n\r\n" +
"\"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=FILENAME.mdb");
hints.Add(EnumDbProviderType.Firebird,
@"Initial Catalog=E:\MyDb.fdb;user id=SYSDBA;password=masterkey;pooling=True" +
@"Initial Catalog=E:\TEST.FB;user id=SYSDBA;password=masterkey;pooling=True;server type=Embedded");
hints.Add(EnumDbProviderType.SqlServer,
"Data Source=localhost;Initial Catalog=MyDatabasename;Integrated Security=True;MultipleActiveResultSets=True;\r\n\r\n" +
"Data Source=localhost;Initial Catalog=MyDatabasename;User ID=MyUserName;Password=MyPassword;MultipleActiveResultSets=True;");
hints.Add(EnumDbProviderType.PostgreSQL,
"HOST=localhost;DATABASE=Speed;USER ID=MyUserName;PASSWORD=MyPassword;\r\n\r\n" +
"Data Source=localhost;Initial Catalog=MyDatabasename;User ID=MyUserName;Password=MyPassword;MultipleActiveResultSets=True;");
hints.Add(EnumDbProviderType.SQLite,
"Data Source=FILENAME;Pooling=true;FailIfMissing=false");
hints.Add(EnumDbProviderType.Oracle,
"Data Source=orcl;User ID=MyUserName;Password=MyPassword");
hints.Add(EnumDbProviderType.MySql,
"server=localhost;database=MyDatabasename;User Id=root;password=MyPassword;\r\n\r\n" +
"server=localhost;database=MyDatabasename;Integrated Security=True");
hints.Add(EnumDbProviderType.MariaDB,
"server=localhost;database=MyDatabasename;User Id=root;password=MyPassword;\r\n\r\n" +
"server=localhost;database=MyDatabasename;Integrated Security=True");
cboProviderType.Items.Add(new ItemText <EnumDbProviderType>("Access", EnumDbProviderType.Access));
cboProviderType.Items.Add(new ItemText <EnumDbProviderType>("Firebird", EnumDbProviderType.Firebird));
cboProviderType.Items.Add(new ItemText <EnumDbProviderType>("MariaDB", EnumDbProviderType.MariaDB));
cboProviderType.Items.Add(new ItemText <EnumDbProviderType>("MySql", EnumDbProviderType.MySql));
cboProviderType.Items.Add(new ItemText <EnumDbProviderType>("Oracle", EnumDbProviderType.Oracle));
cboProviderType.Items.Add(new ItemText <EnumDbProviderType>("PostgreSQL", EnumDbProviderType.PostgreSQL));
cboProviderType.Items.Add(new ItemText <EnumDbProviderType>("Sql Server", EnumDbProviderType.SqlServer));
cboProviderType.Items.Add(new ItemText <EnumDbProviderType>("SQLite", EnumDbProviderType.SQLite));
providerType = EnumDbProviderType.SqlServer;
cboProviderType.SelectByValue <EnumDbProviderType>(providerType);
grbEnterCs.Location = grbBuildCs.Location;
grbEnterCs.Width = grbBuildCs.Width;
#if DEBUG2
Connection = new ConnectionInfo(EnumDbProviderType.SqlServer, ".", "Testes", "sa", "manager", 0, 30);
#endif
SetControls();
}
}
