private void GetBuyerList()
{
try
{
if (txtSearch.Text != "")
{
string Ocode = Convert.ToString(((SessionUser)Session["SessionUser"]).OCode);
string name = txtSearch.Text;
List <Com_Buyer_Setup> BuyerList = _Buyerbll.GetBuyerByName(name);
if (BuyerList.Count > 0)
{
grdBuyer.DataSource = BuyerList;
grdBuyer.DataBind();
}
else
{
var obj = new List <Com_Buyer_Setup>();
obj.Add(new Com_Buyer_Setup());
// Bind the DataTable which contain a blank row to the GridView
grdBuyer.DataSource = obj;
grdBuyer.DataBind();
int columnsCount = grdBuyer.Columns.Count;
grdBuyer.Rows[0].Cells.Clear(); // clear all the cells in the row
grdBuyer.Rows[0].Cells.Add(new TableCell()); //add a new blank cell
grdBuyer.Rows[0].Cells[0].ColumnSpan = columnsCount; //set the column span to the new added cell
grdBuyer.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
grdBuyer.Rows[0].Cells[0].ForeColor = System.Drawing.Color.Red;
grdBuyer.Rows[0].Cells[0].Font.Bold = true;
//set No Results found to the new added cell
grdBuyer.Rows[0].Cells[0].Text = "NO RECORDS FOUND!";
}
}
else
{
string Ocode = Convert.ToString(((SessionUser)Session["SessionUser"]).OCode);
List <Com_Buyer_Setup> BuyerList = _Buyerbll.GetBuyerList(Ocode);
if (BuyerList.Count > 0)
{
grdBuyer.DataSource = BuyerList;
grdBuyer.DataBind();
}
else
{
var obj = new List <Com_Buyer_Setup>();
obj.Add(new Com_Buyer_Setup());
// Bind the DataTable which contain a blank row to the GridView
grdBuyer.DataSource = obj;
grdBuyer.DataBind();
int columnsCount = grdBuyer.Columns.Count;
grdBuyer.Rows[0].Cells.Clear(); // clear all the cells in the row
grdBuyer.Rows[0].Cells.Add(new TableCell()); //add a new blank cell
grdBuyer.Rows[0].Cells[0].ColumnSpan = columnsCount; //set the column span to the new added cell
grdBuyer.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
grdBuyer.Rows[0].Cells[0].ForeColor = System.Drawing.Color.Red;
grdBuyer.Rows[0].Cells[0].Font.Bold = true;
//set No Results found to the new added cell
grdBuyer.Rows[0].Cells[0].Text = "NO RECORDS FOUND!";
}
}
}
catch (Exception)
{
throw;
}
}