private void EnterBooks_Load(object sender, EventArgs e)
{
DB_Access acc = new DB_Access();
DataTable dat = acc.getTable("ViewAuthor");
txtBAuthor.DataSource = dat;
txtBAuthor.ValueMember = "AuthorID";
txtBAuthor.DisplayMember = "FirstName";
DataTable dt = acc.getTable("ViewTopic");
txtBTopic.DataSource = dt;
txtBTopic.ValueMember = "TopicID";
txtBTopic.DisplayMember = "Topic";
}
private void Quotations_Load(object sender, EventArgs e)
{
DB_Access acc = new DB_Access();
DataTable dat = acc.getTable("ViewAuthor");
txtAuthor.DataSource = dat;
txtAuthor.ValueMember = "AuthorID";
txtAuthor.DisplayMember = "FirstName";
DataTable dt = acc.getTable("ViewBooks");
txtBook.DataSource = dt;
txtBook.ValueMember = "Tittle";
txtBook.DisplayMember = "Tittle";
}
private void button1_Click(object sender, EventArgs e)
{
DB_Access dba = new DB_Access();
dba.rptTitlesByTopic();
}
private void button1_Click_1(object sender, EventArgs e)
{
DB_Access dbacc = new DB_Access();
dbacc.update();
}
private void btnDAuthor_Click(object sender, EventArgs e)
{
DB_Access dbacc = new DB_Access();
dbacc.delete();
}
private void button2_Click(object sender, EventArgs e)
{
DB_Access dbacc = new DB_Access();
dbacc.viewauthor();
}