public void CallConnection()
    {
        ClsSqlConnection obj = new ClsSqlConnection();
        DataSet          ds  = obj.Select("spRegisterUserReport");

        if (ds.Tables.Count > 0)
        {
            BindControls.BindGridView(gvwUsers, ds.Tables[0]);
        }
    }
 public void CallConnection(string MailType)
 {
     if (Session["Data"] == null)
     {
         ClsSqlConnection obj = new ClsSqlConnection();
         DataSet          ds  = obj.Select(int.Parse(Session["CustomerId"].ToString()), MailType);
         if (ds.Tables.Count > 0)
         {
             BindControls.BindGridView(gvwMails, ds.Tables[0]);
         }
     }
     else if (Session["Data"] != null)
     {
         BindControls.BindGridView(gvwMails, (Session["Data"] as DataSet).Tables[0]);
         Session["Data"] = null;
     }
 }