void LoadBooks(int t)
{
SqlCommand cmdLoadB = DBConnection.CreateCommand();
cmdLoadB.CommandText = "SELECT Title, Name, Returned" +
" FROM CONTAINS_BOOK JOIN BOOK ON CONTAINS_BOOK.B_ID = BOOK.Book_ID" +
" JOIN BOOK_AUTHOR ON BOOK.Book_ID = BOOK_AUTHOR.B_ID" +
" JOIN AUTHOR ON Author_ID = A_ID" +
" WHERE T_ID = @T_ID";
cmdLoadB.Parameters.AddWithValue("@T_ID", t);
SqlDataReader reader = cmdLoadB.ExecuteReader();
while (reader.Read())
{
BookTitle.AppendText(reader[0].ToString() + Environment.NewLine);
BookAuthor.AppendText(reader[1].ToString() + Environment.NewLine);
Returned.AppendText(reader[2].ToString() + Environment.NewLine);
}
reader.Close();
}
