private void student()
{
DDstudent.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select Id", "-1"));
DDstudent.AppendDataBoundItems = true;
string constr = ConfigurationManager.ConnectionStrings["SmsConnection"].ConnectionString;
string strQuery = "select Admission_id from Admission";
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = strQuery;
cmd.Connection = con;
try
{
con.Open();
DDstudent.DataSource = cmd.ExecuteReader();
DDstudent.DataTextField = "Admission_id";
DDstudent.DataValueField = "Admission_id";
DDstudent.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;
}