public override void Show(Object x) { var data = new FlowLayoutPanel(); data = (FlowLayoutPanel)x; var conn = Sqlconn.CreateConnection(); conn.Open(); //Lấy số lượng Sản phẩm để hiển thị string sqlSelect = "SELECT MaSP FROM SanPham"; var tmp = (SqlCommand)Sqlconn.CreateCommand(sqlSelect, conn); SqlDataReader dr = tmp.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(dr); string[] MaSP = new string[(int)dt.Rows.Count]; for (int i = 0; i < (int)dt.Rows.Count; i++) { MaSP[i] = dt.Rows[i][0].ToString(); } for (int i = 0; i < MaSP.Count(); i++) { string StrSelect = "SELECT ImageSP, DonGia FROM SanPham WHERE MaSP=@MaSP"; var cmd = (SqlCommand)Sqlconn.CreateCommand(StrSelect, conn); cmd.Parameters.AddWithValue("@MaSP", MaSP[i]); SqlDataReader drr = cmd.ExecuteReader(); DataTable t = new DataTable(); t.Load(drr); var price = new Label(); price.Text = t.Rows[0][1].ToString() + " VNĐ"; price.Height = 10; price.ForeColor = Color.Blue; // var ID = new Label(); ID.Text = MaSP[i]; ID.Dock = DockStyle.Bottom; ID.BackColor = Color.AliceBlue; ID.ForeColor = Color.Red; ID.TextAlign = ContentAlignment.MiddleCenter; // byte[] b = (byte[])cmd.ExecuteScalar(); var pic = new PictureBox(); pic.Width = 100; pic.Height = 130; pic.BackgroundImageLayout = ImageLayout.Stretch; pic.BorderStyle = BorderStyle.FixedSingle; pic.Controls.Add(price); pic.Controls.Add(ID); MemoryStream ms = new MemoryStream(b); pic.BackgroundImage = Image.FromStream(ms); data.Controls.Add(pic); ID.Click += new System.EventHandler(this.picClick); } dr.Close(); conn.Close(); }
public override void Show(Object x) { var data = new DataGridView(); data = (DataGridView)x; var conn = Sqlconn.CreateConnection(); conn.Open(); string sqlSelect = "SELECT MaNV as 'ID', TenNV as 'Name', GioiTinh as 'Gender',NgaySinh as 'Birthday' , Email as 'Mail' , SDT as 'Phone', DiaChi as 'Address', ViTri as 'Position' FROM NhanVien"; var cmd = (SqlCommand)Sqlconn.CreateCommand(sqlSelect, conn); SqlDataReader dr = cmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(dr); data.DataSource = dt; }