Thanks for your response. But how do I call the reader within the page? What I am currently doing is:

protected void GridView3_SelectedIndexChanged(object sender, EventArgs e)

{

int reg_id = (int)GridView3.SelectedDataKey.Values["Reg_id"];

Label3.Text = reg_id.ToString();

db.GetRecord(reg_id);

}

How do i pick those values on the form? I was wondering whether a stored procedure with output parameters is the answer?

cheers,