protected void GridViewBook_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("DeleteRow")) { int bookID = int.Parse(e.CommandArgument.ToString()); BookDAO.DeleteBook(bookID); GridViewBook.DataBind(); } }
protected void ButtonAddBook_Click(object sender, EventArgs e) { string title = TextBoxTitle.Text.Trim(); string author = TextBoxAuthor.Text.Trim(); string publisher = TextBoxPublisher.Text.Trim(); int number = int.Parse(TextBoxNumber.Text.Trim()); BookDAO.InsertBook(title, author, publisher, number); GridViewBook.DataBind(); }
public void refereshData() { string query = "Select * From Book"; SqlCommand command = new SqlCommand(query, dbConnection); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = command; DataSet dataSet = new DataSet(); adapter.Fill(dataSet, "Book"); DataTable bookTable = dataSet.Tables["Book"]; GridViewBook.DataSource = bookTable; GridViewBook.DataBind(); command.Dispose(); }
protected void ButtonSearch_Click(object sender, EventArgs e) { if (TextBoxSearch.Text == "") { labDate.Text = "Please Enter What You search"; } else { try { GridViewBook.DataSource = libEntity.searchBook(TextBoxSearch.Text); GridViewBook.DataBind(); } catch (Exception) { labDate.Text = "Record Not found"; } } }
protected void Page_Load(object sender, EventArgs e) { GridViewBook.DataBind(); }//pageload
public void showBook() { GridViewBook.DataSource = libEntity.showAllBooks(); GridViewBook.DataBind(); }