Display Product Names and when clicked display Product details in ASP.Net

How you are displaying the Product links?

I would suggest you to design the Repeater in which you will be having the LinButton control. Get the product name from database and bind it to Repeater.

Get the Product details on OnClick event of LinkButton use the LinkButton Text or Command Argument to select the data.

Here I have created sample that shows the product list when you click on product Name the Details of that product will be shown in table.

HTML

<div>
<asp:DataList ID="dlProducts" runat="server" RepeatColumns="4">
    <HeaderTemplate>
        <div>
            <span>Products</span>
    </HeaderTemplate>
    <ItemTemplate>
        <div style="border: 1px solid #000; padding: 5px; float: inherit; text-align: center;
            text-decoration: none">
            <asp:LinkButton ID="LinkButton1" Text='<%# Eval("ProductName") %>' OnClick="ShowProductDetails"
                runat="server" /></div>
    </ItemTemplate>
    <FooterTemplate>
        </div>
    </FooterTemplate>
</asp:DataList>
</div>
<div>
<table id="tblProduct" runat="server" border="0" cellpadding="0" cellspacing="0"
    visible="false">
    <tr>
        <td colspan="2" style="text-align: center">
            <asp:Label Text="Product Details" runat="server" />
        </td>
    </tr>
    <tr>
        <td>
            <asp:Label Text="Product Id" runat="server" />
        </td>
        <td>
            <asp:Label ID="lblProductId" runat="server" />
        </td>
    </tr>
    <tr>
        <td>
            <asp:Label Text="Product Name" runat="server" />
        </td>
        <td>
            <asp:Label ID="lblProductName" runat="server" />
        </td>
    </tr>
    <tr>
        <td>
            <asp:Label Text="Product Price" runat="server" />
        </td>
        <td>
            <asp:Label ID="lblProductPrice" runat="server" />
        </td>
    </tr>
</table>
</div>

Namespaces

using System.Data;
using System.Data.SqlClient;
using System.Configuration;

Code

string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.GetProducts();
    }

}

protected void ShowProductDetails(object sender, EventArgs e)
{
    LinkButton productName = (sender as LinkButton);
    this.GetProductDetails(productName.Text);
    this.tblProduct.Visible = true;
}

private void GetProducts()
{

    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT Top 10 ProductName FROM Products", con))
        {
            using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
            {
                DataTable dtProducts = new DataTable();
                sda.Fill(dtProducts);
                this.dlProducts.DataSource = dtProducts;
                this.dlProducts.DataBind();
            }
        }
    }
}

private void GetProductDetails(string productName)
{
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT ProductId,ProductName,UnitPrice FROM Products WHERE ProductName = @ProductName", con))
        {
            cmd.Parameters.AddWithValue("@ProductName", productName);
            using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
            {
                DataTable dtProduct = new DataTable();
                sda.Fill(dtProduct);
                foreach (DataRow product in dtProduct.Rows)
                {
                    this.lblProductId.Text = product["ProductId"].ToString();
                    this.lblProductName.Text = product["ProductName"].ToString();
                    this.lblProductPrice.Text = product["UnitPrice"].ToString();
                }
            }
        }
    }
}

Screenshot