Populate A Textbox Using A Select Statement

I want to create a details view page without using the DetailsView control. I would prefer to have separate  textboxes or labels for each column. I just don't have a clue how to go about after the Select is done putting the data into the boxes. Below is as far as I've gotten. The purpose of the label is just my way of wanting to display the QueryString value, it serves no other purpose.

 
protected void Page_Load(object sender, EventArgs e)
    {
        {
            string tktid = Request.QueryString["id"].ToString();
            Label1.Text = tktid.ToString(); 
        }
        { SqlCommand cmd = new SqlCommand("Select tkt_creator from Ticket where tkt_id = @tktid", HelpdeskConnectionString);
 
                 HelpdeskConnectionString.Open();
                 cmd.ExecuteReader();

                 Label2.Text = ?;
 
  }
 
Any help would be appreciated. So far, I've learned a lot from this forum.  Y'all have been great.