private void NewPartToolStripMenuItem_Click(object sender, EventArgs e) { NewPart np = new NewPart(this); np.FormClosed += new FormClosedEventHandler(VendorSetupClosed); np.Show(); }
private void Part_combo_SelectedIndexChanged(object sender, EventArgs e) { if (part_combo.SelectedIndex == 1) { NewPart np = new NewPart(ms); np.FormClosed += new FormClosedEventHandler(PartSetupClosed); np.Show(); } else { try { using (SqlConnection conn = new SqlConnection(conn_string)) { q = "SELECT PartID, PartDescription, UnitPrice " + "FROM Parts " + "WHERE PartNumber = '" + part_combo.Text + "'"; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = q; DataTable td = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(q, conn); conn.Open(); da.Fill(td); conn.Close(); desc_txb.Text = td.Rows[0].ItemArray[1].ToString(); price_txb.Text = td.Rows[0].ItemArray[2].ToString(); } int qty = Convert.ToInt16(qty_txb.Text); decimal price = Convert.ToDecimal(price_txb.Text); decimal total = qty * price; total_txb.Text = total.ToString(); } catch { } } }