protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = DatabaseHelper.Retrieve(@"
SELECT IC.ItemId, IC.Id AS ItemCopyID, L.Id AS LibraryID, I.Title, L.LocationName
FROM ItemCopy IC
JOIN Item I ON I.Id = IC.ItemId
JOIN [Library] L ON L.Id = IC.LibraryId
");
Books.DataSource = dt.Rows;
Books.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = DatabaseHelper.Retrieve(@"
SELECT Author.FirstName, Author.LastName, Item.Title
FROM Author JOIN Item ON Author.Id = Item.AuthorId
");
Books.DataSource = dt.Rows;
Books.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = DatabaseHelper.Retrieve(@"
select Book.ID, Book.Title, Book.ISBN, Book.Author_ID,
Author.LastName, Author.FirstName
from Book
inner join Author
on Author.ID = Book.Author_ID
order by Title
");
Books.DataSource = dt.Rows;
Books.DataBind();
}
}