private void getAllBooks()
{
dtBook = bm.getBooks();
txtBookID.DataBindings.Clear();
txtBookPrice.DataBindings.Clear();
txtBookQuantity.DataBindings.Clear();
txtBookTitle.DataBindings.Clear();
txtBookID.DataBindings.Add("Text", dtBook, "BookID");
txtBookPrice.DataBindings.Add("Text", dtBook, "BookPrice");
txtBookTitle.DataBindings.Add("Text", dtBook, "BookTitle");
txtBookQuantity.DataBindings.Add("Text", dtBook, "BookQuantity");
dgvBookList.DataSource = dtBook;
lblTotalQuantity.Text = string.Format($"TotalQuantity {dtBook.Compute("SUM(BookQuantity)", string.Empty)}");
}
private void getAllBooks()
{
dataBook = bookData.getBooks();
txtBookID.DataBindings.Clear();
txtBookTitle.DataBindings.Clear();
txtBookPrice.DataBindings.Clear();
txtBookQuantity.DataBindings.Clear();
txtBookID.DataBindings.Add("Text", dataBook, "BookID");
txtBookTitle.DataBindings.Add("Text", dataBook, "BookTitle");
txtBookPrice.DataBindings.Add("Text", dataBook, "BookPrice");
txtBookQuantity.DataBindings.Add("Text", dataBook, "BookQuantity");
dgvBookList.DataSource = dataBook;
lblTotalQuantity.Text = "TotalQuantity: " + dataBook.Compute("SUM(BookQuantity)", string.Empty);
}