public void GetActivityData()
        {
            DataTable dtGridViewActivity;

            dtGridViewActivity = objBSS.GetActivitySales(Session["UserID"].ToString());

            if (dtGridViewActivity.Rows.Count > 0)
            {
                DataTable dt1 = new DataTable();
                dt1.Columns.AddRange(new DataColumn[]
                {
                    new DataColumn("Subject"),
                    new DataColumn("Customer"),
                    new DataColumn("RefID"),
                    new DataColumn("POC"),
                    new DataColumn("POCName"),
                    new DataColumn("Address"),
                    new DataColumn("OppName"),
                    new DataColumn("SubRefID"),
                    new DataColumn("ActivityName"),
                    new DataColumn("ActivityTypeID"),
                    new DataColumn("Date"),
                    new DataColumn("Time"),
                    new DataColumn("ActivityStatus"),
                    new DataColumn("ActivityStatusID"),
                    new DataColumn("ActivityOwner"),
                    new DataColumn("ActivityOwnerID"),
                    new DataColumn("ClosureRemarks"),
                    new DataColumn("ClosureRemarksID"),
                    new DataColumn("Attachment"),
                    new DataColumn("Remarks"),
                    new DataColumn("ActivityID"),
                    new DataColumn("TransactionBy")
                });
                for (int i = 0; i <= dtGridViewActivity.Rows.Count - 1; i++)
                {
                    dt1.Rows.Add(dtGridViewActivity.Rows[i]["Subject"].ToString(),
                                 dtGridViewActivity.Rows[i]["Customer"].ToString(),
                                 dtGridViewActivity.Rows[i]["RefID"].ToString(),
                                 dtGridViewActivity.Rows[i]["POC"].ToString(),
                                 dtGridViewActivity.Rows[i]["POCName"].ToString(),
                                 dtGridViewActivity.Rows[i]["Address"].ToString(),
                                 dtGridViewActivity.Rows[i]["OppName"].ToString(),
                                 dtGridViewActivity.Rows[i]["SubRefID"].ToString(),
                                 dtGridViewActivity.Rows[i]["ActivityName"].ToString(),
                                 dtGridViewActivity.Rows[i]["ActivityTypeID"].ToString(),
                                 dtGridViewActivity.Rows[i]["Date"].ToString(),
                                 dtGridViewActivity.Rows[i]["Time"].ToString(),
                                 dtGridViewActivity.Rows[i]["ActivityStatus"].ToString(),
                                 dtGridViewActivity.Rows[i]["ActivityStatusID"].ToString(),
                                 dtGridViewActivity.Rows[i]["ActivityOwner"].ToString(),
                                 dtGridViewActivity.Rows[i]["ActivityOwnerID"].ToString(),
                                 dtGridViewActivity.Rows[i]["ClosureRemarks"].ToString(),
                                 dtGridViewActivity.Rows[i]["ClosureRemarksID"].ToString(),
                                 dtGridViewActivity.Rows[i]["Attachment"].ToString(),
                                 dtGridViewActivity.Rows[i]["Remarks"].ToString(),
                                 dtGridViewActivity.Rows[i]["ActivityID"].ToString(),
                                 dtGridViewActivity.Rows[i]["TransactionBy"].ToString()
                                 );
                }
                GVActivity.DataSource = dt1;
                GVActivity.DataBind();
                GVActivity.MasterTableView.GetColumn("RefID").Visible            = false;
                GVActivity.MasterTableView.GetColumn("POC").Visible              = false;
                GVActivity.MasterTableView.GetColumn("Address").Visible          = false;
                GVActivity.MasterTableView.GetColumn("SubRefID").Visible         = false;
                GVActivity.MasterTableView.GetColumn("ActivityTypeID").Visible   = false;
                GVActivity.MasterTableView.GetColumn("Time").Visible             = false;
                GVActivity.MasterTableView.GetColumn("ActivityStatusID").Visible = false;
                GVActivity.MasterTableView.GetColumn("ActivityOwner").Visible    = false;
                GVActivity.MasterTableView.GetColumn("ActivityOwnerID").Visible  = false;
                GVActivity.MasterTableView.GetColumn("ClosureRemarksID").Visible = false;
                GVActivity.MasterTableView.GetColumn("Attachment").Visible       = false;
                GVActivity.MasterTableView.GetColumn("Remarks").Visible          = false;
                GVActivity.MasterTableView.GetColumn("ActivityID").Visible       = false;
            }
        }