April 29, 2010 at 10:56 am
Garadin (4/29/2010)
Sid Childers (4/29/2010)
This client is stuck on ASP.NET 2.0, unwilling to consider 3.5/dynamic data because he feels that 2.0 can do the job. I'm afraid it will be a maintenance nightmare especially as he adds more content pages/articles.This doesn't make any sense to me. Nothing about 2.0 bars dynamic data. You could make dynamic pages with classic ASP. Maybe I'm missing something?
Seth,
Typo, my bad. When I said 3.5/dynamic data, I meant 3.5/LINQ. Sorry for the confusion!
April 29, 2010 at 11:00 am
I think I'm starting to bring this into focus 🙂
So, serve up the article dynamically via SQL query where 0001.aspx calls query such as select the article ID with the highest votes (max?) and output article content on 0001.aspx. If that's the case, what kind of SQL syntax would be used to get the 2nd to nth articles loaded in pages 0002.aspx through 000n.aspx ?
Thanks much!
the example i gave would do it; if i was on page 0004.aspx, the query would order the data by "RW" (my rownumber alias)
WHERE RW = [int of this pages name: 0004]
that'd be a dataset with one row...witht eh right article and all that..it might be articleID=2, but it's the fourth most popular.
it's kind of dumb, because you could easily have a single page do all the work, just by keeping track of what the next page is/should be, but this is a work around for fulfilling bad requirements.
Lowell
April 29, 2010 at 11:38 am
Sid Childers (4/29/2010)
Garadin (4/29/2010)
Sid Childers (4/29/2010)
This client is stuck on ASP.NET 2.0, unwilling to consider 3.5/dynamic data because he feels that 2.0 can do the job. I'm afraid it will be a maintenance nightmare especially as he adds more content pages/articles.This doesn't make any sense to me. Nothing about 2.0 bars dynamic data. You could make dynamic pages with classic ASP. Maybe I'm missing something?
Seth,
Typo, my bad. When I said 3.5/dynamic data, I meant 3.5/LINQ. Sorry for the confusion!
OK... but you don't need LINQ to do this either. I don't care for LINQ to SQL personally and we don't use it here even though we are on 3.5. Still not seeing the obstacle with doing all of this dynamically with .Net 2.0
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply