473,763 Members | 5,610 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

pagination and procedure stored

Hello chic@s, I have problem with pagination and procedure stored, can to
show information within DataGrid, but when I do click in nobody of the
number which they down appear for the pagination, do not change the
registries.... always shows the first page, somebody has some idea of so
that it can be this... greetings and thanks.

Don Quijote de Nicaragua.
Elder Soto.
Nota: Aqui esta el código que uso

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
If Not Page.IsPostBack Then
udfCargarDatos( )
End If
End Sub

Private Sub grdGeneral_Page IndexChanged(By Val source As System.Object, ByVal
e As System.Web.UI.W ebControls.Data GridPageChanged EventArgs)
grdGeneral.Curr entPageIndex = e.NewPageIndex
udfCargarDatos( )
End Sub

Private Sub udfCargarDatos( )
Dim Cn As New
SqlConnection(C onfigurationSet tings.AppSettin gs("strConex") )
Dim cmd As New SqlCommand("spR ecuperarDatosNo tas", Cn)
Dim da As SqlDataAdapter, ds As DataSet
cmd.CommandType = CommandType.Sto redProcedure
'Definir el comando para el Parametro
cmd.Parameters. Add("@CodUbica" , SqlDbType.Int)
'Pasar el parametro
cmd.Parameters( "@CodUbica").Va lue = Convert.ToInt32 (1)
da = New SqlDataAdapter( cmd)
' Obtener un DataSet y pasarlo al DataGrid
ds = New DataSet
da.Fill(ds)
'Pagina el DataGrid con el DataBind
Me.grdGeneral.D ataSource = ds
Me.grdGeneral.D ataBind()
Cn.Close()
End Sub

En Español:

Hola chic@s, tengo un problema con la paginación y un procedimiento
almacenado, puede mostrar la información dentro del DataGrid, pero cuando
hago click en cualquier de los número que aparecen abajo para la paginación,
no cambian los registros .... siempre me muestra la primera página, alguien
tiene alguna idea de por que puede ser esto... saludos y gracias.
Nov 19 '05 #1
0 1432

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
22145
by: dinesh prasad | last post by:
I'm trying to use a servlet to process a form, then send that data to an SQL server stored procedure. I'm using the WebLogic 8 App. server. I am able to retrieve database information, so I know my application server can talk to the database. I've determined the failure occurs when the the following statement is executed: cstmt.execute(); (due to the failure of println statements placed afterwards). I get the following error after trying to...
2
5458
by: Dino L. | last post by:
How can I run stored procedure (MSSQL) ?
3
8689
by: Joseph D. DeJohn | last post by:
I am trying to get pagination working on a datagrid. Can anyone point me to a resource for help on this? I'm not sure if custom paging is the best option or not.
10
7244
by: EOZyo | last post by:
Hi, i'm trying to set pagination for a search i run on my website, i'll try to explain the easiest i can: When i click the search button on search.php, data is received and stored in variables within results.php, MySQL structure seems to work as expected, although i get some problems: As soon as i click on the "Page 2" Link, i get nothing, neither results nor page numbers.
4
2959
by: VB Programmer | last post by:
I am using a datalist on an ASP.NET 2.0 website. Any idea (or code examples) how I can use pagination on a datalist? Thanks!
1
3382
by: assgar | last post by:
Hi I was using a schroll bar to display multiple rows of dynamically created from database records. The scrolling was not displaying the data properly so I have decided to use pagination. The problem I am having is, if I select one item on page #1 and another on page #5 only the last item selected on page #5 is stored in the array. How can I store selections from multiple pages into one array?
1
6851
by: shalini jain | last post by:
Hi, I want to know how can we do pagination using XSL. There are number of tutorials available on pagination using PHP but nothing with XSL. i am really stuck with my code. Below is the code that i have written for pagination but it displays the link of all the pages at one go i.e. if i have 8 pages showing 10 results per page than it shows links for all 8 pages. Previous 1-10 11-20 21-30 31-40 41-50 51-60 61-70 71-80 Next i want to...
1
2185
by: jdom | last post by:
I am new to stored procedure. I would like to call this to my asp page but just don't have clue how to. Reason i have to this because i have a largedata base. Here is the query from my database: SELECT AD_ID,make, model, year, imagea, ad_dated FROM ADS WHERE Make = "BMW" ORDER BY AD_ID DESC Make is querystring I did try but with no success. if anyone can help or guide me to a sample tutorial
16
2778
by: gnawz | last post by:
I have a pagination function I am using in a file called functions.php as below<? //Pagination functions function getPagingQuery($sql, $itemPerPage = 10) { if (isset($_GET) && (int)$_GET > 0) { $page = (int)$_GET; } else { $page = 1; } // start fetching from this row number $offset = ($page - 1) * $itemPerPage; return $sql . " LIMIT $offset, $itemPerPage"; } /* Get the links to navigate between...
0
9997
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9822
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7366
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6642
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5270
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5405
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3917
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3522
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2793
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.