public void deletecanLV(string query) { if (con.State != ConnectionState.Open) { con.Open(); } SqlDataAdapter da = new SqlDataAdapter(query, con); DataTable dt = new DataTable(); da.Fill(dt); DeleteCandidateLV.DataSource = dt; DeleteCandidateLV.DataBind(); con.Close(); }
protected void DeleteCandidateLV_PagePropertiesChanging(object sender, PagePropertiesChangingEventArgs e) { (DeleteCandidateLV.FindControl("DataPager1") as DataPager).SetPageProperties(e.StartRowIndex, e.MaximumRows, false); deletecanLV("select * from Add_Candidate where isActive = 0"); }