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; }