// triggered by view button
protected void view_click(object sender, EventArgs e)
{
// Clear any displayed messages
msg.Text = "";
if (vId.IsValid && id1.Text.Length > 0)
{
int ID = int.Parse(id1.Text);
// Call view record method
SqlDataReader rd = person.ViewRecord(ID);
rd.Read();
// display retrieved data to the controls
if (rd.HasRows)
{
firstN.Text = rd.GetString(1);
lastN.Text = rd.GetString(2);
age.Text = rd.GetInt32(3).ToString();
sex.Text = rd.GetString(4);
mobile.Text = rd.GetString(5);
active.Text = rd.GetString(6);
// assing a new message
msg.Text = "Here is your requested record";
//Close database and datareader
rd.Close();
person.con.Close();
}
else
{
msg.Text = "We could not find the record of the specified Id";
//Close database and datareader
rd.Close();
person.con.Close();
}
}
}
