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(); }