private void bookid()
{
DDbookid.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select Id", "-1"));
DDbookid.AppendDataBoundItems = true;
string constr = ConfigurationManager.ConnectionStrings["SmsConnection"].ConnectionString;
string strQuery = "select Book_Id from AddBook";
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = strQuery;
cmd.Connection = con;
try
{
con.Open();
DDbookid.DataSource = cmd.ExecuteReader();
DDbookid.DataTextField = "Book_Id";
DDbookid.DataValueField = "Book_Id";
DDbookid.DataBind();
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
con.Dispose();
}
}
private void Reset()
{
txtBookName.Text = string.Empty;
txtBookNum.Text = string.Empty;
DDbookid.ClearSelection();
DDstudent.ClearSelection();
txtclass.Text = string.Empty;
txtcopies.Text = string.Empty;
txtstock.Text = string.Empty;
txtprice.Text = string.Empty;
txtclass1.Text = string.Empty;
txtstdname.Text = string.Empty;
txtsection.Text = string.Empty;
txtReturn.Text = string.Empty;
}
