Results 1 to 3 of 3

Thread: Simple Datalist Question

  1. Dec 15th, 2003, 06:48 PM #1
    HollywoodKY
    HollywoodKY is offline

    Thread Starter
    Member
    Join Date
    Jan 2003
    Posts
    53

    Simple Datalist Question

    I have fallen in love with the datalist control in .Net... but now its testing my patience. In all the other times I have used it, I have had a small database that I didn't particularly care if it listed the entire database.

    This time is different. I want to take the last five entries in my table (using an automnumber ID field as primary key) and bind them toa datalist.

    What code am I needing to limit the datalist to only 5 entries instead of the entire table of data?

    HWOODKY
    Reply With Quote Reply With Quote
  2. Dec 15th, 2003, 08:44 PM #2
    Memnoch1207
    Memnoch1207 is offline
    Frenzied Member Memnoch1207's Avatar
    Join Date
    Feb 2002
    Location
    DUH, Guess...Hint: It's really hot!
    Posts
    1,861
    post your code. It may be as simple as modifying a sql statement.
    Being educated does not make you intelligent.

    Need a weekend getaway??? Come Visit
    Reply With Quote Reply With Quote
  3. Dec 16th, 2003, 09:54 AM #3
    Rio
    Rio is offline
    Junior Member
    Join Date
    Oct 2003
    Location
    Earth
    Posts
    23
    Use store procedures,
    SELECT TOP 5
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width