private void cmbitemname_KeyDown(object sender, KeyEventArgs e) { if (e.KeyData == Keys.Enter) { try { if (cmbitemname.Text != null) { con = new OleDbConnection(lblpath.Text); con.Open(); cmd = con.CreateCommand(); cmd.CommandText = "SELECT ITEMID,UNITID,UNITNAME,SALERATE,MRP,TAXID,TAXNAME FROM ItemMaster WHERE ITEMNAME='" + cmbitemname.Text + "'"; rdr = cmd.ExecuteReader(); while (rdr.Read()) { txtitemno.Text = (rdr["ITEMID"].ToString()); lblunitid.Text = (rdr["UNITID"].ToString()); txtunit.Text = (rdr["UNITNAME"].ToString()); txtprice.Text = (rdr["SALERATE"].ToString()); txtmrp.Text = (rdr["MRP"].ToString()); lblTaxid.Text = (rdr["TAXID"].ToString()); txttaxname.Text = (rdr["TAXNAME"].ToString()); } rdr.Close(); con.Close(); txtSerialNo.Focus(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } if (e.KeyData == Keys.F3) { try { Form fc = Application.OpenForms["PRODUCTCREATION"]; if (fc == null) { PRODUCTCREATION frm = new PRODUCTCREATION(); frm.lblpath.Text = lblpath.Text; frm.ShowDialog(); } // new PRODUCTCREATION(this).Show(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
public GROUP(PRODUCTCREATION frm) { InitializeComponent(); ths = frm; lblpath.Text = ths.lblpath.Text; }