Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Paging

Posted on 2009-12-16
3
Medium Priority
?
205 Views
Last Modified: 2012-05-08
Ok I have a storedprocedure. By default the parameters load 1-20 rows. Not really sure how to make this happen. But in my code. I have on the load it loads 1-20 but I want to use an image button to increase to the next 20 rows. Not sure of the syntex to put this all together.

##'' Store procedure

where Dept = 'Dept ' And totrow >= @StartRow AND totrow <= @EndRow


#####' parameters
 prm = New SqlParameter("@StartRow", SqlDbType.Char, (6))
            prm.Direction = ParameterDirection.Input
            prm.Value = "1"
            cmd.Parameters.Add(prm)

            prm = New SqlParameter("@EndRow", SqlDbType.Char, (6))
            prm.Direction = ParameterDirection.Input
            prm.Value = "20"
            cmd.Parameters.Add(prm)
0
Comment
Question by:Seven price
3 Comments
 
LVL 9

Expert Comment

by:sarabhai
ID: 26065293
you need to set parameter value of @StartRow and @EndRow
0
 
LVL 10

Accepted Solution

by:
anv earned 2000 total points
ID: 26070505
0
 
LVL 9

Author Closing Comment

by:Seven price
ID: 31666866
tks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question