protected void LoadFromCacheDistricts()
        {
            if (Cache["DS"] == null)
            {
                this.LoadFromDb();
            }
            DataSet ds = (DataSet)Cache["DS"];

            GridViewDistricts.DataSource = ds.Tables["Districts"];
            GridViewDistricts.DataBind();
        }
        protected void LoadByPattern()
        {
            SqlConnection conn = new SqlConnection();

            conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
            conn.Open();
            SqlCommand cmd = new SqlCommand();

            cmd.CommandText = string.Format("select * from Districts where DistrictName like '%{0}%'", txtSearch.Text);
            cmd.Connection  = conn;
            SqlDataReader reader = cmd.ExecuteReader();

            GridViewDistricts.DataSource = reader;
            GridViewDistricts.DataBind();
        }