Need some quick help with C#

SHOwnsYou · Nov 20, 2009

[FONT=&quot]
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]

SEO20 · Nov 20, 2009

Selecting random in TSQL is not the best place to have such logic. But if you really must do that here is an article that will teach you more:

http://www.kodyaz.com/articles/top-n-random-rows-foreach-category-or-group.aspx

SHOwnsYou · Nov 20, 2009

Thanks for the quick reply!

I figured using oledb wasnt the best way to approach this, but I am more itnerested in giving this another test run.

I do plan to rewrite it and make it more efficient, but right now I don't have the time.

Need some quick help with C#

SHOwnsYou

Registered Member

SEO20

BANNED

SHOwnsYou

Registered Member

Main Menu

Marketplace

Making Money

BlackHatWorld

Other