public void BindPurchaseItemGroup() { try { clsCategoryMaster objLoad = new clsCategoryMaster(); objLoad.Mode = "PurchaseItemGroup"; objLoad.CompanyID = cId; var ds = objLoad.GetAllCategory(); DataTable dt = ds.Tables[0]; DataRow dr = dt.NewRow(); dr["CategoryMasterCatKey"] = "0"; dr["CategoryMasterCatVal"] = "Please Select PurchaseItem Group"; dt.Rows.InsertAt(dr, 0); //DataRow dr = dt.NewRow(); /* Bind the PurchaseItem Group */ cmbPurchaseItemGroup.DataSource = dt; cmbPurchaseItemGroup.DisplayMember = "CategoryMasterCatVal"; cmbPurchaseItemGroup.ValueMember = "CategoryMasterCatKey"; cmbPurchaseItemGroup.Text = "Please Select PurchaseItem Group"; /* Bind the PurchaseItem Group */ /* Bind the Search PurchaseItem Group */ cmbSearchPurchaseItemGroup.DataSource = dt; cmbSearchPurchaseItemGroup.DisplayMember = "CategoryMasterCatVal"; cmbSearchPurchaseItemGroup.ValueMember = "CategoryMasterCatKey"; cmbSearchPurchaseItemGroup.Text = "Please Select PurchaseItem Group"; /* Bind the Search PurchaseItem Group */ } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "BindPurchaseItemGroup", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void BindDataGrid() { try { clsCategoryMaster objLoad = new clsCategoryMaster(); objLoad.Mode = "SELECTALL"; objLoad.CompanyID = cId; objLoad.CategoryMasterCatName = cmbCategory.Text; dgvCategoryDetail.AutoGenerateColumns = false; var ds = objLoad.GetAllCategory(); dgvCategoryDetail.DataSource = ds.Tables[0]; lblRecordCount.Text = ds.Tables[0].Rows.Count.ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "BindDataGrid", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void BindCategoryCombo() { try { clsCategoryMaster objLoad = new clsCategoryMaster(); objLoad.Mode = "COMBOFILL"; objLoad.CompanyID = cId; var ds = objLoad.GetAllCategory(); DataTable dt = ds.Tables[0]; DataRow dr = dt.NewRow(); dr["CategoryMasterCatKey"] = "0"; dr["CategoryMasterCatName"] = "Please Select Category"; dt.Rows.InsertAt(dr, 0); cmbCategory.DataSource = dt; cmbCategory.DisplayMember = "CategoryMasterCatName"; cmbCategory.ValueMember = "CategoryMasterCatKey"; cmbCategory.Text = "Please Select Category"; cmbCategory.Focus(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "BindCategoryCombo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }