public void FillGrid(string CompCode)
{
try
{
DataTable Dt = new DataTable();
Dt = OP_STOCK_BALLogicLayer.GetAllSTOCK_OP_BALDetials(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString()));
DataView Dv = new DataView(Dt);
if (CompCode != string.Empty)
{
Dv.RowFilter = "COMP_CODE=" + Session["COMP_CODE"].ToString();
}
GvStocktOpeningBalance.DataSource = Dv.ToTable();
GvStocktOpeningBalance.DataBind();
DtSearch = Dv.ToTable();
}
catch (Exception)
{
throw;
}
}
protected void TxtSearch_TextChanged(object sender, EventArgs e)
{
try
{
if (TxtSearch.Text != string.Empty)
{
DataView Dv = new DataView(DtSearch);
Dv.RowFilter = "ProductName LIKE '%" + TxtSearch.Text.Trim() + "%' OR PROD_CODE like '%" + TxtSearch.Text.Trim() + "%' OR Convert(SRNO,'System.String') like '%" + TxtSearch.Text.Trim() + "%' ";
GvStocktOpeningBalance.DataSource = Dv.ToTable();
GvStocktOpeningBalance.DataBind();
}
else
{
GvStocktOpeningBalance.DataSource = DtSearch;
GvStocktOpeningBalance.DataBind();
}
}
catch (Exception)
{
throw;
}
}
