protected void sign_up_Click(object sender, EventArgs e) { cls_con.Open(); string query = "insert into Infoxx(TenNguoiDung,TenDangNhap,ThuDienTu,MatKhau,DiaChi,SoDienThoai) VALUES('" + txtname.Text + "','" + txtuser.Text + "','" + txtemail.Text + "','" + txtpassword.Text + "','" + txtadress.Text + "','" + txtnumber.Text + "');"; SqlCommand sqlcm = new SqlCommand(query, cls_con.sql_con); int result = sqlcm.ExecuteNonQuery(); cls_con.Closed(); }
protected void Page_Load(object sender, EventArgs e) { string st = Request.QueryString.Get("id"); Connect_DB cls_con = new Connect_DB(); cls_con.Open(); string query = "Select ID,Name,Price from KhuyenMaiHapDan where ID='" + st + "';"; sqlcm = new SqlCommand(query, cls_con.sql_con); SqlDataReader result = sqlcm.ExecuteReader(); while (result.Read()) { Name_Pro.Text = result.GetValue(1).ToString(); Price_Pro.Text = result.GetValue(2).ToString() + " đ"; } cls_con.Closed(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserAdmin"] == null) { Response.Redirect("login.aspx"); } cls_con.Open(); // đếm tổng số sản phẩm string query = "select sum(count) from CountProduct;"; SqlCommand sqlcm = new SqlCommand(query, cls_con.sql_con); int tong = (int)sqlcm.ExecuteScalar(); lblProduct.Text = tong.ToString(); // Tính doanh thu string query2 = "select countProduct.count,AmThuc.Price from CountProduct, AmThuc where CountProduct.id_Product = AmThuc.Id_Product;"; SqlCommand sqlcm2 = new SqlCommand(query2, cls_con.sql_con); SqlDataReader result = sqlcm2.ExecuteReader(); double sum = 0; while (result.Read()) { int price = Convert.ToInt32(result.GetValue(0).ToString()); int count = Convert.ToInt32(result.GetValue(1).ToString()); sum = sum + (price * count); } lblMoney.Text = sum.ToString(); // Tính số Lương user //string query3 = "select Count(TenDangNhap) from Infoxx;"; //SqlCommand sqlcm3 = new SqlCommand(query3,cls_con.sql_con); //int tonguer = (int) sqlcm3.ExecuteScalar(); //lblUser.Text = tonguer.ToString(); cls_con.Closed(); }