private void BindItems()
{
try
{
DataSet ds = objCP.GET_Billing_Items_Detail(UDFLib.ConvertIntegerToNull(Session["CPID"]));
DataTable dt = ds.Tables[0];
string[] Pkey_cols = new string[] { "Billing_Item_Id" };
string[] Hide_cols = new string[] { "Trading_Range_Id", "CPID" };
DataTable dt1 = PivotTable("WEF_Date", "Item_Amount", "Trading_Range_Id", Pkey_cols, Hide_cols, dt);
if (dt1.Rows.Count > 0)
{
dtGridItems = dt1;
rgdItems.DataSource = dt1;
rgdItems.DataBind();
}
else
{
rgdItems.DataSource = dtGridItems;
rgdItems.DataBind();
//rgdItems.MasterTableView.Columns[9].Visible = false;
}
ViewState["dtGridItems"] = dtGridItems;
}
catch (Exception ex)
{
//lblError.Text = ex.ToString();
//.WriteError(this.GetType().Name.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name.ToString(), ex);
}
finally
{
}
}
