private void btnSave_Click(object sender, EventArgs e) { try { if (MessageBox.Show("Are you sure you want to Save this Product?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { string bid = "", cid = ""; conn.Open(); cmd = new SqlCommand("Select id from tblBrand where Brand like '" + TXT_brand.Text + "'", conn); dr = cmd.ExecuteReader(); dr.Read(); if (dr.HasRows) { bid = dr[0].ToString(); } dr.Close(); conn.Close(); conn.Open(); cmd = new SqlCommand("Select id from Category where Category like '" + txt_cat.Text + "'", conn); dr = cmd.ExecuteReader(); dr.Read(); if (dr.HasRows) { cid = dr[0].ToString(); } dr.Close(); conn.Close(); conn.Open(); cmd = new SqlCommand("insert into ProductTble(pcode,barcode,pdesc,bid,cid,Price)Values(@pcode,@barcode,@pdesc,@bid,@cid,@Price)", conn); cmd.Parameters.AddWithValue("@pcode", txt_pcode.Text); cmd.Parameters.AddWithValue("@barcode", txt_barcode.Text); cmd.Parameters.AddWithValue("@pdesc", Txtdescription.Text); cmd.Parameters.AddWithValue("@bid", bid); cmd.Parameters.AddWithValue("@cid", cid); cmd.Parameters.AddWithValue("@Price", txt_price.Text); cmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Record inserted successfully"); clear(); frmlist.LoadProduct(); } } catch (Exception ex) { conn.Close(); MessageBox.Show(ex.Message); } }
private void button3_Click(object sender, EventArgs e) { ProductList list = new ProductList(); list.TopLevel = false; panel3.Controls.Add(list); list.LoadProduct(); list.BringToFront(); list.Show(); ; }