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