private void kháchHàngToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
conn.Open();
// command
SqlDataAdapter dta = new SqlDataAdapter("Select Count (*) From DANGNHAP ", conn);
DataTable dtb = new DataTable();
dta.Fill(dtb);
if (dtb.Rows[0][0].ToString() == "1")
{
this.Hide();
khachhang ql = new khachhang();
ql.Show();
}
else
{
this.Hide();
DNNV tc = new DNNV();
tc.Show();
}
}
catch (Exception ex)
{
MessageBox.Show("Loi ket noi " + ex.Message, "Thong bao");// thong bao loi
}
conn.Close();
}
private void kháchHàngToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Hide();
khachhang ql = new khachhang();
ql.Show();
}
public khachhang GetDataTable(string NameTable)
{
string sql = "select * from " + NameTable;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd);
khachhang dt = new khachhang();
return(dt);
}
