public void classicBtnSearch(object sender, EventArgs e) { searchPanel.Controls.Clear(); DataTable dt = getBooksByGenre("Fiction/Classic"); if (dt != null) { //display search page welcomePanel.Visible = false; searchPanel.Visible = true; myOrdersPanel.Visible = false; SearchBookItem sb; foreach (DataRow row in dt.Rows) { sb = new SearchBookItem(UserID); sb.BookTitle = row[0].ToString(); sb.BookAuthor = row[1].ToString(); sb.BookPublisher = row[4].ToString(); sb.BookPages = row[2].ToString(); sb.BookGenre = row[3].ToString(); sb.BookPrice = row[5].ToString(); sb.BookID = row[6].ToString(); sb.Dock = DockStyle.Top; searchPanel.Controls.Add(sb); } } }
public void searchBooks(object sender, EventArgs e) { myCartButton.BackColor = Color.FromArgb(9, 132, 227); aMyOrders.BackColor = Color.FromArgb(9, 132, 227); searchPanel.Controls.Clear(); //clear other pages myOrdersPanel.Visible = false; welcomePanel.Visible = false; searchPanel.Visible = true; //get data DataTable dt = SQL.SQLcommand(@"Select * from books"); if (dt != null) { SearchBookItem sb; foreach (DataRow row in dt.Rows) { if (resultMatch(aSearchBar.Text, row)) { sb = new SearchBookItem(UserID); sb.BookTitle = row[0].ToString(); sb.BookAuthor = row[1].ToString(); sb.BookPublisher = row[4].ToString(); sb.BookPages = row[2].ToString(); sb.BookGenre = row[3].ToString(); sb.BookPrice = row[5].ToString(); sb.BookID = row[6].ToString(); sb.Dock = DockStyle.Top; searchPanel.Controls.Add(sb); } } } }