private void Binding() { DataSet data = new mstoreCRUD().getData(); DtGrid.DataSource = data; DtGrid.DataMember = "tblmstore"; }
private void RecordTSB_Click(object sender, EventArgs e) { DataSet data = new mstoreCRUD().getData(txtStoreID.Text, txtName.Text, txtAddress.Text); DtGrid.DataSource = data; DtGrid.DataMember = "tblmstore"; }
private void frmginMat_Load(object sender, EventArgs e) { SimpanTSB.Enabled = true; UbahTSB.Enabled = false; dtGrid.Enabled = false; DataSet dsDIV = new mdivCRUD().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"; }
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 frmgin_Load(object sender, EventArgs e) { SimpanTSB.Enabled = true; UbahTSB.Enabled = false; dtGrid.Enabled = false; DataSet dsColor = new mcolorCRUD().getData(); DataSet dsSize = new msizeCRUD().getData(); DataSet dsUOM = new muomCRUD().getData(); DataSet dsType = new mtypeCRUD().getData(); DataSet dsDIV = new mdivCRUD().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"; DataGridViewComboBoxColumn Uom = dtGrid.Columns["hUom"] as DataGridViewComboBoxColumn; DataGridViewComboBoxColumn SizeID = dtGrid.Columns["hSizeID"] as DataGridViewComboBoxColumn; DataGridViewComboBoxColumn ColorID = dtGrid.Columns["hColorID"] as DataGridViewComboBoxColumn; SizeID.DataSource = dsSize.Tables[0]; SizeID.DisplayMember = "DESCRIPTION"; SizeID.ValueMember = "SIZEID"; ColorID.DataSource = dsColor.Tables[0]; ColorID.DisplayMember = "DESCRIPTION"; ColorID.ValueMember = "COLORID"; Uom.DataSource = dsUOM.Tables[0]; Uom.DisplayMember = "DESCRIPTION"; Uom.ValueMember = "UOMID"; }