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";
}
