public void deleteLV(string query) { if (con.State != ConnectionState.Open) { con.Open(); } SqlDataAdapter da = new SqlDataAdapter(query, con); DataTable dt = new DataTable(); da.Fill(dt); DeleteBookLV.DataSource = dt; DeleteBookLV.DataBind(); con.Close(); }