public void adddpart(partclass p) { label1.Text = p.partname; label2.Text = p.price; label3.Text = p.part_id.ToString(); MemoryStream mem = new MemoryStream(p.pic); mem.Seek(0, SeekOrigin.Begin); pictureBox1.Image = Image.FromStream(mem); label4.Text = "part"; label5.Text = p.customer_id.ToString(); }
void partdb() { part.Clear(); String sql = "Data Source=DESKTOP-8TO2TNB;Initial Catalog=car_sales;Integrated Security=True"; SqlConnection con = new SqlConnection(sql); con.Open(); string query = "SELECT *FROM part_car where customerid is null"; SqlCommand cmd = new SqlCommand(query, con); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { partclass p = new partclass { part_id = reader.GetInt32(0), partname = reader.GetString(1), type = reader.GetString(2), pic = (byte[])reader["pictuer"], price = reader.GetString(4), customer_id = xx }; part.Add(p); } }