private void describeMenu_Click(object sender, EventArgs e)
{
ssh.Connect();
DescribeOutput descOutput = ssh.Describe(listBox1.SelectedItem.ToString());
DataTable dtDescribe = new DataTable();
dtDescribe.Columns.Add("Name");
dtDescribe.Columns.Add("Type");
dtDescribe.Columns.Add("Modifiers");
dtDescribe.Columns.Add("Primary Key");
foreach (DBColumn column in descOutput.Columns)
{
DataRow r = dtDescribe.NewRow();
r["Name"] = column.ColumnName;
r["Type"] = column.Type;
r["Modifiers"] = column.Modifiers;
r["Primary Key"] = column.IsPrimaryKey ? "X" : "";
dtDescribe.Rows.Add(r);
}
describeTable.DataSource = dtDescribe;
ssh.Disconnect();
}
private void RemoteConnection(Config nConfig)
{
this.ssh = new SshDbWrapper(nConfig.SSH_HOST,
nConfig.SSH_USER,
nConfig.SSH_PASSW,
nConfig.DB_HOST,
nConfig.DB_PORT,
nConfig.DB_USER,
nConfig.DB_SCHEMA,
nConfig.DB_PASSWORD);
ssh.Connect();
List <String> tableList = ssh.TableList();
ssh.Disconnect();
//assign a contextmenustrip
listboxContextMenu = new ContextMenuStrip();
listboxContextMenu.Opening += new CancelEventHandler(listboxContextMenu_Opening);
listBox1.ContextMenuStrip = listboxContextMenu;
listBox1.Items.Clear();
foreach (String table in tableList)
{
listBox1.Items.Add(table);
}
}
private void btnExecute_Click(object sender, EventArgs e)
{
ssh.Connect();
DBModifyOutput output = ssh.ExecuteScript(txtScript.Text);
txtOuput.ForeColor = output.Status == 0 ? Color.Green : Color.Red;
txtOuput.Text = output.Response;
ssh.Disconnect();
}
private void QuerySelect()
{
DataTable sqlresponse = new DataTable();
ssh.Connect();
SelectOutput selectOutput = ssh.SelectFromTable(Table, txtWhere.Text, txtOrder.Text, txtLimit.Text);
dataGridView1.DataSource = selectOutput.Table;
PrimaryKeyData = selectOutput.PrimaryKey;
ssh.Disconnect();
UpdateList.Clear();
InsertList.Clear();
InitialRowsCount = dataGridView1.Rows.Count;
}
private void btnDdlCompare_Click(object sender, EventArgs e)
{
Config source = ConfigList[(String)ddlListConnection1.SelectedItem];
Config destination = ConfigList[(String)ddlListConnection2.SelectedItem];
SourceConnection = new SshDbWrapper(source.SSH_HOST,
source.SSH_USER,
source.SSH_PASSW,
source.DB_HOST,
source.DB_PORT,
source.DB_USER,
source.DB_SCHEMA,
source.DB_PASSWORD);
DestinationConnection = new SshDbWrapper(destination.SSH_HOST,
destination.SSH_USER,
destination.SSH_PASSW,
destination.DB_HOST,
destination.DB_PORT,
destination.DB_USER,
destination.DB_SCHEMA,
destination.DB_PASSWORD);
SourceConnection.Connect();
DestinationConnection.Connect();
lstBox1.Items.Clear();
foreach (String table in SourceConnection.TableList())
{
lstBox1.Items.Add(table);
}
lstBox2.Items.Clear();
foreach (String table in DestinationConnection.TableList())
{
lstBox2.Items.Add(table);
}
SourceConnection.Disconnect();
DestinationConnection.Disconnect();
}
