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