public void BindGrid() { try { string cstring = ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString; MySqlConnection con = new MySqlConnection(cstring); MySqlCommand cmd = new MySqlCommand(m.strEmpDL, con); MySqlDataAdapter sda = new MySqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); DLEmployee.DataSource = dt; DLEmployee.DataTextField = "Name"; DLEmployee.DataValueField = "Name"; DLEmployee.DataBind(); Cache.Insert("EmployeeName", dt, null, DateTime.Now.AddSeconds(40), System.Web.Caching.Cache.NoSlidingExpiration); } catch (Exception ex) { Response.Write(ex.Message); } }