private void tv_allDB_NodeMouseDoubleClick(object sender, TreeNodeMouseClickEventArgs e)
{
//Oracle database
if (LogDB.ORACLE.Equals(LogDB.ConnectionDatabase))
{
try
{
if (tv_allDB.SelectedNode.Nodes.Count == 0 && !tv_allDB.SelectedNode.Text.Equals("Low permissions"))
{
string sql = "SELECT * FROM " + tv_allDB.SelectedNode.Text;
gb_result.Text = "Result set. current table[ " + tv_allDB.SelectedNode.Text + " ]";
DataSet ds = ORACLEDBHelp.ExecuteDataSet(sql);
dataGridView1.DataSource = ds.Tables[0];
}
}
catch
{
MessageBox.Show("Currently selected is not a table or Low permissions. ");
}
}
//SQL Server database
else if (LogDB.SQLSERVER.Equals(LogDB.ConnectionDatabase))
{
try
{
if (tv_allDB.SelectedNode.Nodes.Count == 0)
{
gb_result.Text = "Result set. current table[ " + tv_allDB.SelectedNode.Text + " ]";
string sql = "USE " + tv_allDB.SelectedNode.Parent.Text + ";SELECT * FROM " + tv_allDB.SelectedNode.Text;
DataSet ds = SQLSERVERDBHelp.ExecuteDataSet(sql);
dataGridView1.DataSource = ds.Tables[0];
}
}
catch
{
MessageBox.Show("Currently selected is not a table or Low permissions. ");
}
}
//MySQL database
else if (LogDB.MYSQL.Equals(LogDB.ConnectionDatabase))
{
try
{
if (tv_allDB.SelectedNode.Nodes.Count == 0)
{
gb_result.Text = "Result set. current table[ " + tv_allDB.SelectedNode.Text + " ]";
string sql = "USE " + tv_allDB.SelectedNode.Parent.Text + ";SELECT * FROM " + tv_allDB.SelectedNode.Text;
DataSet ds = MYSQLDBHelp.ExecuteDataSet(sql);
dataGridView1.DataSource = ds.Tables[0];
}
}
catch
{
MessageBox.Show("Currently selected is not a table or Low permissions. ");
}
}
}
private void MainForm_Load(object sender, EventArgs e)
{
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
//dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
loadImageList();
tss_dbname.Text = LogDB.ConnectionDatabase;
tss_version.Text = LogDB.dbversion;
this.Text += " [ " + LogDB.ConnectionDatabase + " ]";
//If now choose database is oracle,loading all oracle database's user space,behave inside user
if (LogDB.ORACLE.Equals(LogDB.ConnectionDatabase))
{
//string currendUser = ORACLEDBHelp.ExecuteScalar(LogDB.ORACLE_CURRENT_USERNAME).ToString();
string currendUser = string.Empty;
OracleDataReader reader = ORACLEDBHelp.ExecuteDataReader(LogDB.ORACLE_CURRENT_USERNAME);
if (reader.Read())
{
currendUser = reader[0].ToString();
}
reader.Close();
OracleDataReader oracle_table_reader = ORACLEDBHelp.ExecuteDataReader(LogDB.ORACLE_CURRENT_USERNAME_TABLE);
List <string> tabName = new List <string>();
while (oracle_table_reader.Read())
{
tabName.Add(oracle_table_reader[0].ToString());
}
if (!oracle_table_reader.IsClosed)
{
oracle_table_reader.Close();
}
OracleDataReader oracleReader = ORACLEDBHelp.ExecuteDataReader(LogDB.ORACLE_ALL_USER_SCRIPT);
while (oracleReader.Read())
{
if (oracleReader[0].ToString().Equals(currendUser))
{
//If current user is now loaded
TreeNode nodeUser = new TreeNode(oracleReader[0].ToString() + "(Current user)");
nodeUser.ImageIndex = 3;
TreeNode nodeTable = new TreeNode("Table");
foreach (string item in tabName)
{
TreeNode nodeInnerTable = new TreeNode(item);
nodeInnerTable.ImageIndex = 0;
nodeTable.Nodes.Add(nodeInnerTable);
}
nodeUser.Nodes.Add(nodeTable);
nodeUser.ForeColor = Color.Red;
tv_allDB.Nodes.Add(nodeUser);
}
else
{
//Loading all user information
TreeNode nodeUser = new TreeNode(oracleReader[0].ToString());
nodeUser.ImageIndex = 3;
TreeNode nodeTable = new TreeNode("Low permissions");
nodeTable.ImageIndex = 2;
nodeTable.ForeColor = Color.Gray;
nodeUser.Nodes.Add(nodeTable);
tv_allDB.Nodes.Add(nodeUser);
}
}
if (!oracleReader.IsClosed)
{
oracleReader.Close();
}
}
//If now choose database is sqlserver,loading all sqlserver database,behave system database
else if (LogDB.SQLSERVER.Equals(LogDB.ConnectionDatabase))
{
SqlDataReader sqlserverReader = SQLSERVERDBHelp.ExecuteDataReader(LogDB.SQLSERVER_ALL_TABLE_SCRIPT);
while (sqlserverReader.Read())
{
string databaseName = sqlserverReader[0].ToString();
TreeNode nodeDatabase = new TreeNode(databaseName);
nodeDatabase.ImageIndex = 1;
SqlDataReader sqlReader = SQLSERVERDBHelp.ReBuilderSqlDataReader("select * from " + databaseName + ".dbo.sysobjects where xtype='U'");
while (sqlReader.Read())
{
string tagName = sqlReader[0].ToString();
TreeNode table = new TreeNode(tagName);
table.ImageIndex = 0;
nodeDatabase.Nodes.Add(table);
}
if (!sqlReader.IsClosed)
{
sqlReader.Close();
}
tv_allDB.Nodes.Add(nodeDatabase);
}
if (!sqlserverReader.IsClosed)
{
sqlserverReader.Close();
}
}
//If now choose database is mysql,loading all mysql database,behave system database
else if (LogDB.MYSQL.Equals(LogDB.ConnectionDatabase))
{
MySqlDataReader mysqlReader = MYSQLDBHelp.ExecuteDataReader(LogDB.MYSQL_ALL_TABLE_SCRIPT);
while (mysqlReader.Read())
{
string databaseName = mysqlReader[0].ToString();
TreeNode databaseNode = new TreeNode(databaseName);
databaseNode.ImageIndex = 1;
MySqlDataReader myReader = MYSQLDBHelp.ReBuildMySQLDataReader("use " + databaseName + ";show tables");
while (myReader.Read())
{
TreeNode table = new TreeNode(myReader[0].ToString());
table.ImageIndex = 0;
databaseNode.Nodes.Add(table);
}
if (!myReader.IsClosed)
{
myReader.Close();
}
tv_allDB.Nodes.Add(databaseNode);
}
if (!mysqlReader.IsClosed)
{
mysqlReader.Close();
}
}
}
