private void btnProduct_Click(object sender, EventArgs e) { FormProduct_View.sFormIndex = "POS"; FormProduct_View sForm = new FormProduct_View(); sForm.ShowDialog(); }
private void FormProduct_View_Load(object sender, EventArgs e) { daProductList = new MySqlDataAdapter("", clsConnection.CN); LoadProduct("SELECT tblproduct.productcode, tblproduct.productname, tblcategory.categoryname, tblcategory.categorycode, tblsupplier.suppliername, tblsupplier.suppliercode, tblproduct.unitprice, tblproduct.sellingprice, tblproduct.stock, tblproduct.autoid FROM tblproduct RIGHT JOIN tblcategory ON tblproduct.categoryautoid = tblcategory.autoid RIGHT JOIN tblsupplier ON tblproduct.supplierautoid = tblsupplier.autoid ORDER BY tblproduct.autoid ASC"); publicFormProduct_View = this; }