[FONT="]
Ok, I am trying to retrieve a random record set from my OLEDB connected database.
I tried this, but it returns the entire record set.
Just using the sql
Ok, I am trying to retrieve a random record set from my OLEDB connected database.
Code:
OleDbDataAdapter adapter2 = new OleDbDataAdapter("Select top 5 url from stories ORDER BY rnd()", aConn);
I tried this, but it returns the entire record set.
Just using the sql
Code:
SELECT top 5 url FROM stories [code]
Only returns 5 stories, but there seems to be no way to change which 5 are returned.
[/FONT]