Add data to textbox
<p>I would like your help in order to solve the following issue. I want to show the value of several fields in different TextBox. </p>

<p>I have a GridView with a hyperlink Field on Name. When I click on the Name I want, I go directly to the Profile Page of that Name. And there is where the problem resides. I want to add data into the textboxes based on my select...Here is my code on the Profile page.</p>

<pre><code>private void bindData()
    {
        dvDriverProfile.DataSource = (DataTable)Session["Dados"];
        dvDriverProfile.DataBind();
    }

    private void FillDrivers()
    {
        SqlConnection conn;
        SqlCommand cm;
        SqlDataAdapter da;
        DataTable dt;
        string strSQL;
        string DriverId;

        DriverId = Request["DriverId"].ToString();
        conn = new SqlConnection();
        conn.ConnectionString = "Data Source=NOTEBOOK\\SQL;Initial Catalog=Paddock;Integrated Security=True";
        conn.Open();

        strSQL = "SELECT d.DriverID, (FirstName + ' ' + LastName) AS DriverName, c.Country, d.DOB, CAST(DATEDIFF(YY,d.DOB,GetDate()) - CASE WHEN DATEADD(YY,DATEDIFF(YY,d.DOB,GETDATE()),d.DOB)&gt; GETDATE() THEN 1 ELSE 0 END AS nvarchar(20)) + ' yrs' AS Age, g.Gender, n.Number, ds.DrivingStyle " +
                 "FROM dbo.Drivers d " +
                 "INNER JOIN dbo.pDrivingStyle ds ON d.DrivingStyleID=ds.DrivingStyleID " +
                 "INNER JOIN dbo.pGender g ON d.GenderID=g.GenderID " +
                 "INNER JOIN dbo.pNumbers n ON d.NumberID=n.NumberID " +
                 "INNER JOIN dbo.pCountry c ON d.CountryID=c.CountryID " +
                 "WHERE d.DriverId='" + DriverId + "'";



        cm = new SqlCommand(strSQL, conn);

        dt = new DataTable();
        da = new SqlDataAdapter(cm);

        da.Fill(dt);
    }


    protected void Page_Load(object sender, EventArgs e)
    {


        if (!IsPostBack)
        {
            FillDrivers();
            bindData();

        }
    }
</code></pre>
