Posted on 2009-12-16
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"

            prm = New SqlParameter("@EndRow", SqlDbType.Char, (6))
            prm.Direction = ParameterDirection.Input
            prm.Value = "20"
Question by:sevensnake77
    LVL 9

    Expert Comment

    you need to set parameter value of @StartRow and @EndRow
    LVL 10

    Accepted Solution

    LVL 9

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    It’s quite interesting for me as I worked with Excel using for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
    Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
    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.…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now