Need to add a hyperlinkfield to a gridview containing data from another column

Question

I have a gridview that gets data from an sqldatasource and as a results gets 3 columns from an SQL query: ID, description and price.

What I want to do is adding another column with an hyperlink in the format of page.aspx?id=x where x is the ID code from the first column. This for each row in the table.

I've been looking all morning for how to do this, all I got is that I have to manage the RowDataBound event and use an hyperlinkfield but couldn't find anything else that explained how they actually work together, even the msdn article is kind of vague on the subject or just doesn't have any relevant help for my specific case as I'm managing the gridview from the code-behind. Also haven't been able to figure how to access strings from the other columns, since it's what I need to insert in the resulting hyperlink.

Here's what I got so far for the creation of the gridview:

private void FillGrid(string qid)
{
    SqlDataSource1.ConnectionString = Connessione.connectionString;
    SqlDataSource1.SelectCommand = "SELECT art_tessuto_articolo, art_tessuto_descrizione, lipre_prezzo FROM lipre INNER JOIN listini_tessuti ON lipre.lipre_codice = listini_tessuti.listini_codice INNER JOIN art_tessuti ON lipre.lipre_articolo = art_tessuti.art_tessuto_articolo WHERE lipre_codice = @qid AND lipre_prezzo <> 0";
    SqlDataSource1.SelectParameters.Clear();
    SqlDataSource1.SelectParameters.Add("qid", qid);

    GridView1.AllowPaging = true;
    GridView1.PageSize = 500;
    GridView1.DataSource = SqlDataSource1;

    GridView1.DataBind();


}

Answer 1

This should do the job.

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
       HyperLink hlControl = new HyperLink();
       hlControl.Text = e.Row.Cells[0].Text; 
       hlControl.NavigateUrl = "page.aspx?id=" + e.Row.Cells[0].Text;
       e.Row.Cells[3].Controls.Add(hlControl);
    }
}