private void button8_Click(object sender, EventArgs e)
{
OleDbConnection conn = LibraryDB.GetConnection();
DataTable dt = new DataTable();
OleDbDataAdapter adapter = new OleDbDataAdapter("select * from Books Where (Author=@ath)", conn);
adapter.SelectCommand.Parameters.AddWithValue("@author", textBox1.Text);
adapter.Fill(dt);
dataGridView1.DataSource = dt;
button6.Visible = false;
button7.Visible = false;
button8.Visible = false;
}
private void button7_Click(object sender, EventArgs e)
{
OleDbConnection conn = LibraryDB.GetConnection();
DataTable dt = new DataTable();
OleDbDataAdapter adapter = new OleDbDataAdapter("select * from Users Where (CustomerName=@cname)", conn);
adapter.SelectCommand.Parameters.AddWithValue("@cname", textBox1.Text);
adapter.Fill(dt);
dataGridView1.DataSource = dt;
button6.Visible = false;
button9.Visible = false;
button10.Visible = false;
}
private void button1_Click(object sender, EventArgs e)
{
int num = Convert.ToInt32(textBox3.Text);
bok = LibraryDB.GetBooks(num);
if (bok == null)
{
MessageBox.Show("The book has not been found");
}
else
{
button3.Enabled = true;
button5.Enabled = true;
this.DisplayBooks();
}
OleDbConnection conn = LibraryDB.GetConnection();
DataTable dt = new DataTable();
OleDbDataAdapter adapter = new OleDbDataAdapter("select * from Books Where (BookID=@id)", conn);
adapter.SelectCommand.Parameters.AddWithValue("@bookid", textBox3.Text);
adapter.Fill(dt);
dataGridView1.DataSource = dt;
}
