Paging

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)
LVL 9
Seven priceFull StackAsked:
Who is Participating?
 
sarabhaiCommented:
you need to set parameter value of @StartRow and @EndRow
0
 
Seven priceFull StackAuthor Commented:
tks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.