public void gridfill() { try { DataTable dtbl = new DataTable(); ReminderSP SpRemainder = new ReminderSP(); dtbl = SpRemainder.ShortExpiryReminderGridFill(Convert.ToDecimal(cmbProductGroup.SelectedValue.ToString()), Convert.ToDecimal(cmbProduct.SelectedValue.ToString()), Convert.ToDecimal(cmbBrand.SelectedValue.ToString()), Convert.ToDecimal(cmbSize.SelectedValue.ToString()), Convert.ToDecimal(cmbModelno.SelectedValue.ToString()), Convert.ToDecimal(cmbTax.SelectedValue.ToString()), Convert.ToDecimal(cmbGodown.SelectedValue.ToString()), Convert.ToDecimal(cmbRack.SelectedValue.ToString())); dgvProductExpiry.DataSource = dtbl; } catch (Exception ex) { MessageBox.Show("SE:2" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public List <DataTable> ShortExpiryReminderGridFill(decimal groupId, decimal productId, decimal brandId, decimal sizeId, decimal modelNoId, decimal taxId, decimal godownId, decimal rackId) { List <DataTable> list = new List <DataTable>(); try { list = spReminder.ShortExpiryReminderGridFill(groupId, productId, brandId, sizeId, modelNoId, taxId, godownId, rackId); } catch (Exception ex) { MessageBox.Show("RM6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(list); }