protected void BindTradebusinessdate()
        {
            try
            {
                DataSet   dsGetAllTradeBussiness = new DataSet();
                DataTable dtGetAllTradeBussiness = new DataTable();
                dsGetAllTradeBussiness = OnlineOrderBackOfficeBo.GetAllTradeBussiness(int.Parse(Ddlyears.SelectedItem.Value), int.Parse(Ddlholiday.SelectedItem.Value));
                dtGetAllTradeBussiness = dsGetAllTradeBussiness.Tables[0];
                if (dtGetAllTradeBussiness.Rows.Count > 0)
                {
                    if (Cache[userVo.UserId.ToString() + "TradeBusinessDates"] != null)
                    {
                        Cache.Remove(userVo.UserId.ToString() + "TradeBusinessDates");
                    }
                    Cache.Insert(userVo.UserId.ToString() + "TradeBusinessDates", dtGetAllTradeBussiness);

                    //gvTradeBusinessDate.DataSource = dtGetAllTradeBussiness;
                    //gvTradeBusinessDate.DataBind();

                    //if (Cache[userVo.UserId.ToString() + "TradeBusinessDates"] != null)
                    //{
                    //    Cache.Remove("Tradebussiness" + adviserVo.advisorId);
                    //    Cache.Insert("Tradebussiness" + adviserVo.advisorId, dtGetAllTradeBussiness);
                    //    Cache.Insert("Tradebussiness" + adviserVo.advisorId, dtGetAllTradeBussiness);
                    //}
                    //else
                    //{

                    //}


                    //  sai
                    //if (Cache["Tradebussiness" + adviserVo.advisorId] == null)
                    //{
                    //    Cache.Insert("Tradebussiness" + adviserVo.advisorId, dtGetAllTradeBussiness);
                    //}
                    //else
                    //{
                    //    Cache.Remove("Tradebussiness" + adviserVo.advisorId);
                    //    Cache.Insert("Tradebussiness" + adviserVo.advisorId, dtGetAllTradeBussiness);
                    //}


                    //int i = 0;

                    //string s = string.Format("{0:yyyy-MM-dd}", DateTime.Now);

                    //foreach (DataRow dr in dtGetAllTradeBussiness.Rows)
                    //{
                    //    if (dtGetAllTradeBussiness.Rows[i][0].ToString().ToLower().Trim() == s.ToLower().Trim())
                    //    {
                    //        var page = (i / 20);  //eg row 50 means page = 10
                    //        gvTradeBusinessDate.CurrentPageIndex = page;

                    //        break;
                    //    }
                    //    else
                    //    {
                    //        i++;
                    //        gvTradeBusinessDate.CurrentPageIndex = 0;
                    //    }
                    //}

                    gvTradeBusinessDate.DataSource = dtGetAllTradeBussiness;
                    gvTradeBusinessDate.DataBind();
                    //BindTradebusinessdate();
                }
                else
                {
                    gvTradeBusinessDate.DataSource = dtGetAllTradeBussiness;
                    gvTradeBusinessDate.DataBind();
                }
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }
            catch (Exception Ex)
            {
                BaseApplicationException exBase       = new BaseApplicationException(Ex.Message, Ex);
                NameValueCollection      FunctionInfo = new NameValueCollection();
                FunctionInfo.Add("Method", "OnlineSchemeMIS.ascx.cs:SetParameter()");
                object[] objects = new object[4];
                FunctionInfo = exBase.AddObject(FunctionInfo, objects);
                exBase.AdditionalInformation = FunctionInfo;
                ExceptionManager.Publish(exBase);
                throw exBase;
            }
        }