//private void ConnectToMySQL()
//{
// if (this.aConnection_MySQL.State == ConnectionState.Open)
// {
// this.aConnection_MySQL.ChangeDatabase(cboxDataBase.Text);
// MySqlCommand aCmd = new MySqlCommand("show tables", this.aConnection_MySQL);
// aCmd.CommandType = CommandType.Text;
// MySqlDataAdapter Adapter = new MySqlDataAdapter(aCmd);
// this.aDS_SQL = new DataSet();
// Adapter.Fill(this.aDS_SQL);
// List<string> ListTable = new List<string>();
// for (int i = 0; i < this.aDS_SQL.Tables[0].Rows.Count; i++)
// {
// ListTable.Add(this.aDS_SQL.Tables[0].Rows[i][0].ToString());
// }
// FrmListTable aFrm = new FrmListTable(ListTable, this.aConnection_MySQL);
// aFrm.Show();
// }
// else
// {
// MessageBox.Show("Không kết nối được đến DB, kiểm tra lại các thông số");
// }
//}
private void ConnectToMSSQL()
{
if (this.aConnection_MSSQL.State == ConnectionState.Open)
{
this.aConnection_MSSQL.ChangeDatabase(cboxDataBase.Text);
SqlCommand aCmd = new SqlCommand("SELECT * FROM sys.Tables", this.aConnection_MSSQL);
aCmd.CommandType = CommandType.Text;
SqlDataAdapter Adapter = new SqlDataAdapter(aCmd);
this.aDS_SQL = new DataSet();
Adapter.Fill(this.aDS_SQL);
List<string> ListTable = new List<string>();
for (int i = 0; i < this.aDS_SQL.Tables[0].Rows.Count; i++)
{
ListTable.Add(this.aDS_SQL.Tables[0].Rows[i][0].ToString());
}
FrmListTable aFrm = new FrmListTable(ListTable, this.aConnection_MSSQL);
aFrm.Show();
}
else
{
MessageBox.Show("Không kết nối được đến DB, kiểm tra lại các thông số");
}
}
//private void ConnectToMySQL()
//{
// if (this.aConnection_MySQL.State == ConnectionState.Open)
// {
// this.aConnection_MySQL.ChangeDatabase(cboxDataBase.Text);
// MySqlCommand aCmd = new MySqlCommand("show tables", this.aConnection_MySQL);
// aCmd.CommandType = CommandType.Text;
// MySqlDataAdapter Adapter = new MySqlDataAdapter(aCmd);
// this.aDS_SQL = new DataSet();
// Adapter.Fill(this.aDS_SQL);
// List<string> ListTable = new List<string>();
// for (int i = 0; i < this.aDS_SQL.Tables[0].Rows.Count; i++)
// {
// ListTable.Add(this.aDS_SQL.Tables[0].Rows[i][0].ToString());
// }
// FrmListTable aFrm = new FrmListTable(ListTable, this.aConnection_MySQL);
// aFrm.Show();
// }
// else
// {
// MessageBox.Show("Không kết nối được đến DB, kiểm tra lại các thông số");
// }
//}
private void ConnectToMSSQL()
{
if (this.aConnection_MSSQL.State == ConnectionState.Open)
{
this.aConnection_MSSQL.ChangeDatabase(cboxDataBase.Text);
//--------------------------------------------------------------------------------
// Get List Table
SqlCommand aCmd = new SqlCommand("SELECT sys.Tables.name , sys.schemas.name FROM sys.Tables inner join sys.schemas on sys.Tables.schema_id = sys.schemas.schema_id ", this.aConnection_MSSQL);
aCmd.CommandType = CommandType.Text;
SqlDataAdapter Adapter = new SqlDataAdapter(aCmd);
this.aDS_SQL = new DataSet();
Adapter.Fill(this.aDS_SQL);
// ---------------------------------------------------------------------------------
List<string> ListTable = new List<string>();
string TableName = "";
for (int i = 0; i < this.aDS_SQL.Tables[0].Rows.Count; i++)
{
TableName = this.aDS_SQL.Tables[0].Rows[i][1].ToString() + "." + this.aDS_SQL.Tables[0].Rows[i][0].ToString();
ListTable.Add(TableName);
aListTable.Add(new TableInfo(TableName, false));
}
//--------------------------------------------------------------------------------
// Get List View
aCmd = new SqlCommand("SELECT * from INFORMATION_SCHEMA.VIEWS", this.aConnection_MSSQL);
aCmd.CommandType = CommandType.Text;
Adapter = new SqlDataAdapter(aCmd);
this.aDS_SQL = new DataSet();
Adapter.Fill(this.aDS_SQL);
TableName = "";
for (int i = 0; i < this.aDS_SQL.Tables[0].Rows.Count; i++)
{
TableName = this.aDS_SQL.Tables[0].Rows[i][1].ToString() + "." + this.aDS_SQL.Tables[0].Rows[i][2].ToString();
ListTable.Add(TableName);
aListTable.Add(new TableInfo(TableName, false));
}
FrmListTable aFrm = new FrmListTable(aListTable, this.aConnection_MSSQL);
aFrm.Show();
}
else
{
MessageBox.Show("Không kết nối được đến DB, kiểm tra lại các thông số");
}
}
