protected void Button2_Click(object sender, EventArgs e) { db.CheckStatus(); SqlCommand cmd = new SqlCommand("select name from student where enrollid=@Name", db.sqcon); cmd.Parameters.AddWithValue("@Name", TextBox2.Text); dr = cmd.ExecuteReader(); if (dr.Read()) { Label2.Text = "Issue report of " + dr[0].ToString(); } else { Label2.Text = "Invalid ID"; } repStuname(); res_stu.Style.Add("display", "block"); }
protected void Button1_Click(object sender, EventArgs e) { db.CheckStatus(); SqlCommand cmd = new SqlCommand("select name,dept,email,contact from student where enrollid=@Name", db.sqcon); cmd.Parameters.AddWithValue("@Name", TextBox1.Text); dr = cmd.ExecuteReader(); if (dr.Read()) { Label1.Text = dr[0].ToString(); Label2.Text = dr[1].ToString(); Label3.Text = dr[2].ToString(); Label4.Text = dr[3].ToString(); } else { Label1.Text = "Invalid ID/No such data existing in database"; } string issue = "select bname from book where stuid='" + TextBox1.Text + "'"; dr = db.RetriveData(issue); int i = 0; while (dr.Read()) { i++; Label5.Text = dr[0].ToString(); } Label5.Text = i + ""; //else //{ // Label2.Text = "No book issued by this student"; //} rmvstu.Style.Add("display", "block"); }
protected void unameTxt_TextChanged(object sender, EventArgs e) { if (!string.IsNullOrEmpty(unameTxt.Text)) { db.CheckStatus(); SqlCommand cmd = new SqlCommand("select * from faculty where username=@Name", db.sqcon); cmd.Parameters.AddWithValue("@Name", unameTxt.Text); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { imgcheck.Visible = true; lblcheck.Visible = true; imgcheck.ImageUrl = "~/Images/taken.gif"; lblcheck.Text = "UserName Taken!!"; } else { imgcheck.Visible = true; lblcheck.Visible = true; imgcheck.ImageUrl = "~/Images/available.gif"; lblcheck.Text = "Available"; } } }