void getDataTaiSan() { cbbTaiSan.Items.Clear(); string query = @"SELECT ma_tai_san, ten_tai_san, so_luong, tri_gia, mo_ta, img FROM TaiSan WHERE taikhoan = 'admin'"; DB.conn.Open(); SqlCommand cmd = new SqlCommand(query, DB.conn); SqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { CTaiSan ngd = new CTaiSan(rd[0].ToString(), rd[1].ToString(), rd[2].ToString(), rd[3].ToString(), rd[4].ToString(), (byte[])rd[5]); cbbTaiSan.Items.Add(ngd); } DB.conn.Close(); }
public void getData() { listTaiSan = new List <CTaiSan>(); string query = @"SELECT ma_tai_san, ten_tai_san, so_luong, tri_gia, mo_ta, img FROM TaiSan WHERE taikhoan = '" + IDUser + "' ORDER BY so_luong * tri_gia DESC"; DB.conn.Open(); SqlCommand cmd = new SqlCommand(query, DB.conn); SqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { CTaiSan ppt = new CTaiSan(rd[0].ToString(), rd[1].ToString(), rd[2].ToString(), rd[3].ToString(), rd[4].ToString(), (byte[])rd[5]); listTaiSan.Add(ppt); } DB.conn.Close(); addItem(); }
void getData() { string query = @"SELECT ma_tai_san, ten_tai_san, so_luong, tri_gia, mo_ta, img FROM TaiSan WHERE ma_tai_san = " + Id + ""; DB.conn.Open(); SqlCommand cmd = new SqlCommand(query, DB.conn); SqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { TaiSan = new CTaiSan(rd[0].ToString(), rd[1].ToString(), rd[2].ToString(), rd[3].ToString(), rd[4].ToString(), (byte[])rd[5]); } DB.conn.Close(); lbName.Text = TaiSan.Name; lbCount.Text = TaiSan.Count; lbValue.Text = Commom.getMoneyStr(TaiSan.Value); lbDescription.Text = TaiSan.Description; pbAnhTaiSan.Image = TaiSan.getImage(); }