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(); }