DECLARE @mytable TABLE
     (
  rownum int IDENTITY(1,1),
  style NVARCHAR(50),
  fabric NVARCHAR(50),
  team NVARCHAR(50),
  color NVARCHAR(50)
     ) 

Nice table albeit modified, but forums leaves a trail.

Err? I never pretended for it to be the same. How could it be? I showed you a -real- table, while this is just a temporary one. I was just showing that rownum was a valid column name.

I think Caddre is somewhat of a bessewisser that just have to be right, even when she is wrong. Like proven in other threads when she in fact tries to convince people that they missunderstood the question when she missunderstood everything from start to end.

http://forums.asp.net/thread/1455988.aspx

Like you try to make object permissions appear simple only to get to where I started in this thread.

 

http://forums.asp.net/thread/1459045.aspx

And you both bulling me to stop explaining to the user  that there are no two timestamps to compare because it is not time in the above thread.

So I should let users run code in a disposable table being queried to page rows not associated to a column leave data persistence to chance and a UI control the Gridview.  That code is not valid if it was a thread it is none of my business it is a faq he was proudly referencing as valid code, in the Architecture forum in the thread below.

http://forums.asp.net/1/1454575/ShowThread.aspx

I call it cave men bulling me to intimidate my participation in the forums run by the largest software company in the world.

This thread has regressed to a bout of name calling that is inappropriate on a professional developers forum.

Caddre, please be sure to read and understand all posts in a thread before contributing to the thread.  Without that understanding, a thread can be moved off on a tangent that will not help the original poster.

Pqxl, please refrain from attacking other members.  While you may challenge a person's argument, you may not attack the person.

If anyone on this thread wishes to continue their complaint, he or she may do so with a private message to me.  Otherwise, please allow this thread to return to the topic introduced by shados.
 

How do people who do not know and like stored procedures understand the chain of two stored procs and comparison of two timestamp when there is one more than I do. 

I am just calling things as I see them. There is a problem and it is not going away.

I'd just like to say that I don't understand what either of you are talking about.

Here's a nice little tutorial on it. No stored procedures.
http://www.developerfusion.co.uk/show/4060/

Just use Fill(DataSet dataSet, int startRecord, int maxRecords, string srcTable); method of DbDataAdapter.

Thanks,
Gurjinder Singh Brar
http://agileguru.blogspot.com

A cool article on efficient server side paging:

http://www.dotnetcurry.com/ShowArticle.aspx?ID=267

 Hi friend You chan just check the following URL for the Custome paging in the Gridview.

http://www.codeproject.com/KB/webforms/FullGridPager.aspx?fid=469379&df=90&mpp=25&noise=3&sort=Position&view=Quick&select=2299627