select top 10 * from table1 Will retrieve only 10 rows is this what you want ?
----- Original Message ----- From: "Ravi Swaminathan" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, November 25, 2005 11:35 PM Subject: [AspNetAnyQuestionIsOk] Fixed Rows in Datagrid > Hi, > > I need to display a fixed number of rows in a > datagrid, but even if I set the height property, all > of the rows are returned without the scroll bar when > viewed in the browser. Could someone plaese provide a > solution? > > ALternatively I would like to display a multi-column > datalist, but I need a sample code to achieve that. > > Thanks > > Ravi > > > > __________________________________ > Start your day with Yahoo! - Make it your home page! > http://www.yahoo.com/r/hs > > > > > Yahoo! Groups Links > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
