ado.net performance and scalability

[C# Programming]

Hi!

I would like to know whats the best way to display Detail view using ADO.net. In my case I have a product page once clicked on productid i display information regarding this product. there cant be more than one record as i filter based on ID. so in this detail page I am rendering this way

code behind
sqlDataAdapt.Fill(dsProductDetail, "ProductDetail");
if (dsProductDetail!= null)
{

dlProductDetails.DataSource = dsProductDetail;
dlProductDetails.DataBind();
}

aspx




<div class="dlfloatleft">








could anyone please tell me whats the best way I can write code so that even if there is 100000 hits in this page from various geographical ******** the page performs well? I was thinking may be use datareader and have label controls and set value of those labels but i think using web controls adds overheads to its performance.

please help.