private void button1_Click(object sender, EventArgs e)
{
DBTools db = new DBTools(".", "wkdl", true, "sa", "wdxg");
SqlDataReader b = db.getResult("Select * from userlogin where uname='" + textBox1.Text.Trim() + "'and uPassword='******'");
try
{
if (b.Read())
{
db.Disconnect();
DBTools dc = new DBTools(".", "wkdl", true, "sa", "wdxg");
SqlDataReader bb = db.getResult("Select * from userlogin where uname='" + textBox1.Text.Trim() + "'and usa='admin'");
DLname c = DLname.getInstance();
c.Str = textBox1.Text;
if (bb.Read())
{
dc.Disconnect();
MessageBox.Show("Hello administrator.", "Hello", MessageBoxButtons.OK, MessageBoxIcon.Information);
MainForm mfa = new MainForm();
mfa.Text = "Administrator System";
mfa.Show();
}
else
{
dc.Disconnect();
MessageBox.Show("Hello VIP member", "Hello", MessageBoxButtons.OK, MessageBoxIcon.Information);
MainForm mfb = new MainForm();
mfb.Text = "Member System";
mfb.Show();
}
dc.Disconnect();
this.Hide();
}
else
{
db.Disconnect();
MessageBox.Show("Login failed! Please check your input.", "Sorry", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Update_Load(object sender, EventArgs e)
{
db = new DBTools(".", "wkdl", true, "sa", "wdxg");
SqlDataReader b = db.getResult("Select * from ware where id=" + c.Num);
while (b.Read())
{
textBox1.Text = b["id"].ToString();
textBox2.Text = b["warename"].ToString();
textBox3.Text = b["price"].ToString();
textBox4.Text = b["zip"].ToString();
textBox5.Text = b["type"].ToString();
textBox6.Text = b["stocks"].ToString();
}
db.Disconnect();
}
