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);
}
}
public BLEmployee()
{
dl = new DLEmployee();
}
