private void btnGetData_Click(object sender, EventArgs e)
{
//try
//{
// MySqlDataReader myReader = DBConnection_MySQL.Query_MySQL("SELECT * FROM TAIKHOAN");
// if (myReader.Read())
// {
// //tbContent.Text = myReader.GetString(1);
// }
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message + ((DBConnection_MySQL.ErrorString != "") ? "\n\n" + DBConnection_MySQL.ErrorString : ""));
//}
//finally
//{
// DBConnection_MySQL.closeConnection();
//}
//string selected = cbbTables.GetItemText(cbbTables.SelectedItem);
string selected = cbbTables.Text;
if (string.IsNullOrWhiteSpace(selected))
{
return;
}
string query = "SELECT * FROM " + selected;
DataSet ds = DBConnection_MySQL.getData(query);
dgvContent.DataSource = ds.Tables[0];
}
private void btnQuery_Click(object sender, EventArgs e)
{
try
{
DataSet ds = DBConnection_MySQL.getData(rtbQuery.Text);
dgvQueryResult.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public MainGUI()
{
InitializeComponent();
this.Text = BUS.Show.name;
DataSet tables = DBConnection_MySQL.getData("show tables from dbquanlynhankhau");
foreach (DataRow item in tables.Tables[0].Rows)
{
cbbTables.Items.Add(item[0].ToString());
}
}
protected void checkLogin()
{
if (tbUsername.Text == "" || tbPassword.Text == "")
{
MessageBox.Show(this, "Vui lòng điền đầy đủ tài khoản và mật khẩu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
DataSet ds = DBConnection_MySQL.getData("SELECT * FROM TAIKHOAN WHERE TAIKHOAN='"
+ tbUsername.Text + "' AND MATKHAU='" + tbPassword.Text + "'");
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show(this, "Tài khoản hoặc mật khẩu không đúng!\n" + DBConnection_MySQL.ErrorString, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
this.Hide();
var mainGUI = new MainGUI();
mainGUI.Closed += (s, args) => this.Close();
mainGUI.Show();
}
}
}
