예제 #1
0
        private void Binding()
        {
            DataSet data = new mstoreCRUD().getData();

            DtGrid.DataSource = data;
            DtGrid.DataMember = "tblmstore";
        }
예제 #2
0
        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";
        }
예제 #3
0
        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";
        }
예제 #4
0
        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";
        }
예제 #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";
        }