How to select five rows from table and display in page in ASP.Net

Question

I have 10 rows with records but wants to display only 5 rows

sujayanand · Accepted Answer

Try like this for first 5 rows SELECT TOP5contactid lastname firstnameFROM contactsWHERE lastname  39Anderson39ORDER BY contactidAnd Bind the data in GridViewTry this if it helps u

How to select five rows from table and display in page in ASP.Net

Company

Explore

Follow us

Contact Us