protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["bid"] != null)
{
tbl_BlockedBook ne = new tbl_BlockedBook();
ne.BookId = int.Parse(Request.QueryString["bid"]);
db.tbl_BlockedBooks.InsertOnSubmit(ne);
db.SubmitChanges();
}
var ite = from b in db.tbl_BlockedBooks
select b.BookId;
var item = from b in db.tbl_Books
join c in db.tbl_Categories on b.CategoryID equals c.CategoryId
where !ite.Contains(b.BookId)
select new
{
b.BookId, b.BookTitle, b.Author,
desc = b.BookDesc.Substring(0, 50) + "...",
b.Year, b.Publisher, b.ImagePath, c.CategoryName, b.CategoryID
};
DataList1.DataSource = item;
DataList1.DataBind();
}
}
partial void Deletetbl_BlockedBook(tbl_BlockedBook instance);
partial void Updatetbl_BlockedBook(tbl_BlockedBook instance);
partial void Inserttbl_BlockedBook(tbl_BlockedBook instance);
