/// <summary>
/// fill the authors combobox
/// </summary>
private void LoadAuthor()
{
DataTable dtAuthor = DataAccess.GetData("SELECT AuthorId, FirstName + ISNULL(' '+ MiddleName, '') + ' ' + LastName AS WholeName FROM Author ORDER BY LastName, FirstName");
UT.BindComboBox(cmbAuthor, dtAuthor, "WholeName", "AuthorId");
}
/// <summary>
/// fill the category combobox
/// </summary>
private void LoadCategory()
{
DataTable dtCategory = DataAccess.GetData("SELECT CategoryId, CategoryName FROM Category");
UT.BindComboBox(cmbCategory, dtCategory, "CategoryName", "CategoryId");
}
/// <summary>
/// fill the books combobox
/// </summary>
private void LoadBook()
{
DataTable dtBook = DataAccess.GetData("SELECT BookId, Title FROM Book");
UT.BindComboBox(cmbBook, dtBook, "Title", "BookId");
}