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 { } }