I want to display top 3 products in featured table on my web page from the same datasource which is pulling all rows from SQL and then all rows can be find in another asp.net repeater. How can i limit

SQL Data Source


FeaturedProduct.DataSourceID = "PriceComparison";UpdateI am done with the limit datasouce for top 3 rows only, But now eval bind is not working. So how can i bind the data with element in html.

var mycollection = ProductPics.SelectCommand;FeaturedProduct.DataSour ce = mycollection.Take(3);FeaturedProduct.DataBind();

Check Solution