public SQLConnectionHelper()
{
this.serverNames = new ArrayList();
this.defaultServerName = "";
this.sqlConnectionStr = new SQLConnectionString();
this.isConnected = false;
this.sqlConnection = null;
this.databases = new ArrayList();
this.tables = new ArrayList();
}
public object Clone()
{
SQLConnectionString scs = new SQLConnectionString();
scs.auth = auth;
scs.database = database;
scs.password = password;
scs.server = server;
scs.user = user;
return scs;
}
private void lbScheduleEvents_SelectedIndexChanged(object sender, EventArgs e)
{
if (this.lbScheduleEvents.SelectedIndex < 0)
return;
ScheduleEvent schedEvent = (ScheduleEvent)this.lbScheduleEvents.SelectedItem;
SQLConnectionString sqlConnString = new SQLConnectionString();
sqlConnString.ConnectionString = schedEvent.SQLConnectionString;
if (this.cbServerNames.Items.Contains(sqlConnString.Server))
{
this.cbServerNames.Text = sqlConnString.Server;
}
else
{
DialogResult result = MessageBox.Show(
"Nie ma takiej bazy na liście.\n\nCzy chcesz usnąć to zdarzenie z listy?",
"Ostrzeżenie",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question
);
if (result == DialogResult.Yes)
{
object toDelete = lbScheduleEvents.SelectedItem;
lbScheduleEvents.Items.Remove(toDelete);
this.events.Remove(toDelete);
this.events.Save();
}
}
}
private static void DisplayData(System.Data.DataTable table)
{
String srvName = "";
foreach (System.Data.DataRow row in table.Rows)
{
if (srvName.Equals(""))
{
srvName = row["ServerName"] + "\\" + row["InstanceName"];
}
else
{
if (!row["InstanceName"].Equals("SQLEXPRESS"))
{
srvName = row["ServerName"] + "\\" + row["InstanceName"];
}
}
Console.WriteLine(row["ServerName"] + "\\" + row["InstanceName"]);
SQLConnectionString sqlConnStr = new SQLConnectionString();
sqlConnStr.Server = srvName;
sqlConnStr.Authentication = true;
/*
if (!rbAuthWindows.Checked)
{
sqlConnStr.UserID = txtUser.Text;
sqlConnStr.Password = txtPassword.Text;
}
*/
using (SqlConnection sqlConn = new SqlConnection(sqlConnStr.ConnectionString))
{
try
{
sqlConn.Open();
DataTable tblDatabases = sqlConn.GetSchema("Databases");
foreach (DataRow rowDBs in tblDatabases.Rows)
{
Console.WriteLine(rowDBs["database_name"]);
if (rowDBs["database_name"].Equals("MagresNET"))
{
sqlConn.ChangeDatabase("MagresNET");
Console.WriteLine("Found and selected");
DataTable dt = sqlConn.GetSchema("Tables");
foreach (DataRow rowTables in dt.Rows)
{
Console.WriteLine(rowTables["table_name"]);
}
}
}
sqlConn.Close();
}
catch (Exception ex)
{
Console.WriteLine("EX: " + ex.Message);
Console.WriteLine("EX: " + sqlConnStr.ConnectionString);
}
}
}
/*
foreach (System.Data.DataRow row in table.Rows)
{
foreach (System.Data.DataColumn col in table.Columns)
{
Console.WriteLine("{0} = {1}", col.ColumnName, row[col]);
}
Console.WriteLine("============================");
}
*/
}