protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { string strFirstName = Request.QueryString["firstname"]; string strLastName = Request.QueryString["lastname"]; string strDOB = Request.QueryString["dob"]; string strQryDupStudent; strQryDupStudent = "SELECT studentid,firstname,lastname,dob FROM student " + "WHERE ((firstname='" + strFirstName + "' OR lastname='" + strLastName + "') " + "OR(firstname='" + strLastName + "' OR lastname='" + strFirstName + "'))" + "AND(dob='" + strDOB + "')"; StudentDataSource.SelectCommand = strQryDupStudent; StudentDataSource.DataBind(); dgStudent.DataBind(); } }
protected void btnBrowseSID_Click(object sender, EventArgs e) { tblEntryForm.Visible = false; string firstname = txtFirstName.Text.Trim(); string lastname = txtLastName.Text.Trim(); if (!firstname.Length.Equals(0) || !lastname.Length.Equals(0)) { StudentDataSource.SelectCommand = DetermineQuery(firstname, lastname); } else { StudentDataSource.SelectCommand = "SELECT s.studentid,s.firstname,s.lastname,s.dob,s.lastupdatetime,c.countryname " + "FROM student s,country c WHERE s.countryid=c.countryid ORDER BY s.lastupdatetime DESC"; } StudentDataSource.DataBind(); dgStudent.Visible = true; }