private void RefreshGridView()
{
tblBook = adpBook.GetData(); // get the datatable
grdBook.DataSource = tblBook;
grdBook.DataBind();
tblAuthor = adpAuthor.GetData();
tblCat = adpCat.GetData();
tblPub = adpPub.GetData();
lstAuthor.DataSource = tblAuthor;
lstAuthor.DataTextField = tblAuthor.AuthorNameColumn.ToString();
lstAuthor.DataValueField = tblAuthor.AuthorIdColumn.ToString();
lstAuthor.DataBind();
lstAuthor.Items.Insert(0, new ListItem("Add Author", "-1"));
//lstAuthor.SelectedIndex = 1;
lstPub.DataSource = tblPub;
lstPub.DataTextField = tblPub.PublisherNameColumn.ToString();
lstPub.DataValueField = tblPub.PublisherIdColumn.ToString();
lstPub.DataBind();
lstPub.Items.Insert(0, new ListItem("Add Publisher", "-1"));
//lstPub.SelectedIndex = 1;
lstCat.DataSource = tblCat;
lstCat.DataTextField = tblCat.CategoryNameColumn.ToString();
lstCat.DataValueField = tblCat.CategoryIdColumn.ToString();
lstCat.DataBind();
lstCat.Items.Insert(0, new ListItem("Add Category", "-1"));
//lstCat.SelectedIndex = 1;
}
protected void btnLoad_Click(object sender, EventArgs e)
{
int idx = int.Parse(txtBookID.Text);
tblBook = adpBook.GetDataByID(idx);
grdBook.DataSource = tblBook;
grdBook.DataBind();
}
