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