private void PopulateGrid()
{
m_tStatus = new DataTable();
m_tStatus = m_oStatus.GetStatusRegister();
string sFilter = "1=1";
if (toolStripFilter.EditValue.ToString() != "ALL")
{
sFilter = sFilter + " and Status = '" + toolStripFilter.EditValue + "'";
}
if (toolStripType.EditValue.ToString() != "ALL")
{
if (toolStripType.EditValue.ToString() == "Supply")
{
sFilter = sFilter + " and Supply = true";
}
else if (toolStripType.EditValue.ToString() == "Contract")
{
sFilter = sFilter + " and Contract = true";
}
else if (toolStripType.EditValue.ToString() == "Service")
{
sFilter = sFilter + " and Service = true";
}
}
if (Convert.ToInt32(toolStripVendor.EditValue) > 0)
{
sFilter = sFilter + " and VendorId = " + Convert.ToInt32(toolStripVendor.EditValue);
}
DataView dv;
DataTable dt;
dv = new DataView(m_tStatus);
dv.RowFilter = sFilter;
dt = dv.ToTable();
grdTrans.DataSource = dt;
TransView.Columns["RegTransID"].Visible = false;
TransView.Columns["VendorId"].Visible = false;
TransView.Columns["RDate"].Width = 100;
TransView.Columns["RefNo"].Width = 100;
TransView.Columns["RegNo"].Width = 100;
TransView.Columns["VendorName"].Width = 200;
TransView.Columns["Status"].Width = 100;
TransView.Columns["Supply"].Width = 50;
TransView.Columns["Contract"].Width = 50;
TransView.Columns["Service"].Width = 50;
TransView.Columns["RDate"].Caption = "Date";
TransView.Columns["RefNo"].Caption = "Ref No";
TransView.Columns["RegNo"].Caption = "Reg No";
TransView.Columns["VendorName"].Caption = "Vendor Name";
TransView.Columns["Status"].Caption = "Status";
//grdTrans.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Calibri", 9, FontStyle.Bold);
}
