public void bookret(string query)
{
SqlDataAdapter da = new SqlDataAdapter(query, "server=.;database=MyLMS;user=sa;password=Ak11;");
DataTable dt = new DataTable();
da.Fill(dt);
BookRetLV.DataSource = dt;
BookRetLV.DataBind();
con.Close();
}
protected void BookRetLV_PagePropertiesChanging(object sender, PagePropertiesChangingEventArgs e)
{
(BookRetLV.FindControl("DataPager1") as DataPager).SetPageProperties(e.StartRowIndex, e.MaximumRows, false);
bookret("select * from BookIssueForm");
}
