Ejemplo n.º 1
0
        private void frmjoborder_Load(object sender, EventArgs e)
        {
            DataSet dsType  = new mtypeCRUD().getData();
            DataSet dsDIV   = new mdivCRUD().getData();
            DataSet dsColor = new mcolorCRUD().getData();
            DataSet dsSize  = new msizeCRUD().getData();

            //teat
            // dtGrid.HeaderCell.Columns["hSizeID"].HeaderCell = datagridViewCheckBoxHeaderCell;
            SimpanTSB.Enabled = true;
            UbahTSB.Enabled   = false;
            dtGrid.Enabled    = true;

            cbTypeID.DataSource    = dsType.Tables[0];
            cbTypeID.DisplayMember = "DESCRIPTION";
            cbTypeID.ValueMember   = "TYPEID";

            cbDIV.DataSource    = dsDIV.Tables[0];
            cbDIV.DisplayMember = "DESCRIPTION";
            cbDIV.ValueMember   = "DIVID";
            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";
        }
Ejemplo n.º 2
0
        private void Binding()
        {
            DataSet data = new mcolorCRUD().getData();

            DtGrid.DataSource = data;
            DtGrid.DataMember = "tblmcolor";
        }
Ejemplo n.º 3
0
        private void RecordTSB_Click(object sender, EventArgs e)
        {
            DataSet data = new mcolorCRUD().getData(txtColorID.Text, txtDescription.Text);

            DtGrid.DataSource = data;
            DtGrid.DataMember = "tblmcolor";

            // frmmcolorSearch f = new frmmcolorSearch();
            // f.AddItemCallback = new frmmcolorSearch.AddItemDelegate(this.SetValueCallBack);
            // f.ShowDialog();
        }
Ejemplo n.º 4
0
        private void frmgrnOtherMat_Load(object sender, EventArgs e)
        {
            SimpanTSB.Enabled = true;
            UbahTSB.Enabled   = false;
            dtGrid.Enabled    = false;


            DataSet dsCurrency = new mcurrencyCRUD().getData();
            DataSet dsColor    = new mcolorCRUD().getData();
            DataSet dsSize     = new msizeCRUD().getData();
            DataSet dsDIV      = new mdivCRUD().getData();
            DataSet dsStore    = new mstoreCRUD().getData();
            DataSet dsUOM      = new muomCRUD().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";
        }
Ejemplo n.º 5
0
        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";
        }