private void RecordTSB_Click(object sender, EventArgs e) { DataSet data = new mcostCRUD().getData(txtCostID.Text, txtDescription.Text); //data.geData(); DtGrid.DataSource = data; DtGrid.DataMember = "tblmcost"; }
private void Binding() { DataSet data = new mcostCRUD().getData(); //data.geData(); DtGrid.DataSource = data; DtGrid.DataMember = "tblmcost"; }
private void frmgrnCMT_Load(object sender, EventArgs e) { SimpanTSB.Enabled = true; UbahTSB.Enabled = false; dtGrid.Enabled = false; DataSet dsCost = new mcostCRUD().getData(); //DataSet dsCurrency = new mcurrencyCRUD().getData(); DataSet dsUOM = new muomCRUD().getData(); DataSet dsType = new mtypeCRUD().getData(); DataSet dsDIV = new mdivCRUD().getData(); DataSet dsCourier = new mcourierCRUD().getData(); DataSet dsStore = new mstoreCRUD().getData(); cbStore.DataSource = dsStore.Tables[0]; cbStore.DisplayMember = "NAME"; cbStore.ValueMember = "STOREID"; cbDIV.DataSource = dsDIV.Tables[0]; cbDIV.DisplayMember = "DESCRIPTION"; cbDIV.ValueMember = "DIVID"; //cbCurrency.DataSource = dsCurrency.Tables[0]; //cbCurrency.DisplayMember = "CURRENCYID"; //cbCurrency.ValueMember = "CURRENCYID"; DataGridViewComboBoxColumn Uom = dtGrid.Columns["hUom"] as DataGridViewComboBoxColumn; // DataGridViewComboBoxColumn CurrencyID = dtGrid.Columns["hCurrencyID"] as DataGridViewComboBoxColumn; DataGridViewComboBoxColumn UomPurchase = dtGrid.Columns["hUomPurchase"] as DataGridViewComboBoxColumn; Uom.DataSource = dsUOM.Tables[0]; Uom.DisplayMember = "DESCRIPTION"; Uom.ValueMember = "UOMID"; UomPurchase.DataSource = dsUOM.Tables[0]; UomPurchase.DisplayMember = "DESCRIPTION"; UomPurchase.ValueMember = "UOMID"; //CurrencyID.DataSource = dsCurrency.Tables[0]; //CurrencyID.DisplayMember = "CURRENCYID"; //CurrencyID.ValueMember = "CURRENCYID"; }
private void frmcosting_Load(object sender, EventArgs e) { SimpanTSB.Enabled = true; UbahTSB.Enabled = false; dtGrid.Enabled = false; DataSet dsCost = new mcostCRUD().getData(); DataSet dsCurrency = new mcurrencyCRUD().getData(); DataSet dsValueIn = new mcurrencyCRUD().getData(); DataSet dsUOM = new muomCRUD().getData(); DataSet dsType = new mtypeCRUD().getData(); DataSet dsDIV = new mdivCRUD().getData(); cbTypeID.DataSource = dsType.Tables[0]; cbTypeID.DisplayMember = "DESCRIPTION"; cbTypeID.ValueMember = "TYPEID"; cbDIV.DataSource = dsDIV.Tables[0]; cbDIV.DisplayMember = "DESCRIPTION"; cbDIV.ValueMember = "DIVID"; cbValueIn.DataSource = dsValueIn.Tables[0]; cbValueIn.DisplayMember = "CURRENCYID"; cbValueIn.ValueMember = "CURRENCYID"; DataGridViewComboBoxColumn CostType = dtGrid.Columns["hCostType"] as DataGridViewComboBoxColumn; //new DataGridViewComboBoxColumn(); DataGridViewComboBoxColumn Uom = dtGrid.Columns["hUom"] as DataGridViewComboBoxColumn; DataGridViewComboBoxColumn Currency = dtGrid.Columns["hCurrency"] as DataGridViewComboBoxColumn; CostType.DataSource = dsCost.Tables[0]; CostType.DisplayMember = "DESCRIPTION"; CostType.ValueMember = "COSTID"; Uom.DataSource = dsUOM.Tables[0]; Uom.DisplayMember = "DESCRIPTION"; Uom.ValueMember = "UOMID"; Currency.DataSource = dsCurrency.Tables[0]; Currency.DisplayMember = "CURRENCYID"; Currency.ValueMember = "CURRENCYID"; cbValueIn.Text = "USD"; }