public frmInventory(frmPrincipal f) { InitializeComponent(); frmprincipal = f; string selected = frmprincipal.lstbox_products.SelectedItem.ToString(); string sql = "SELECT * FROM tb_products WHERE PRODUCT_NAME='" + selected + "'"; dt = database.DataBaseCommand(sql); nud_product_amount.Value = decimal.Parse(dt.Rows[0].ItemArray[3].ToString()); }
public frmUpdateProduct(frmPrincipal f) { // Creating new DataTable for using with database command DataTable dt = new DataTable(); InitializeComponent(); frmprincipal = f; txtbox_productName.Text = frmprincipal.lstbox_products.SelectedItem.ToString(); string selected = frmprincipal.lstbox_products.SelectedItem.ToString(); string sql = "SELECT * FROM tb_products WHERE PRODUCT_NAME='" + selected + "'"; dt = database.DataBaseCommand(sql); txtbox_productPrice.Text = dt.Rows[0].ItemArray[2].ToString(); nudProductAmount.Value = decimal.Parse(dt.Rows[0].ItemArray[3].ToString()); }
public frmLogin(frmPrincipal f) { InitializeComponent(); frmprincipal = f; }