Ver Mensaje Individual
  #1 (permalink)  
Antiguo 02/03/2005, 08:21
mjesus20
 
Fecha de Ingreso: marzo-2005
Mensajes: 190
Antigüedad: 19 años, 2 meses
Puntos: 0
Exclamación Urgente ayuda con el codigo

hola necesito ayuda con el siguiente codigo necesito controlar la propiedad pagesize del datagrid pueden indicarme donde esta el error

Function MyQueryMethod() As System.Data.DataSet
Dim connectionString As String = "server=xxxxx; user id='xxxxx'; password=''; database=xxxxxxxx
Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionStri ng)

Dim queryString As String = "SELECT [Inventario].[Item], [Inventario].[Inventario], [Inventario].[Equipo], [In"& _
"ventario].[Fecha Compra], [Inventario].[Modelo], [Inventario].[Serie], [Inventar"& _
"io].[Valor Compra], [Inventario].[Ubicacion] FROM [Inventario]order by item"
Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection

Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.SqlClient.SqlDataAdapter
dataAdapter.SelectCommand = dbCommand
Dim dataSet As System.Data.DataSet = New System.Data.DataSet
dataAdapter.Fill(dataSet)

Return dataSet
End Function


Sub pagerbuttonclick(sender As Object, e As EventArgs)
dim arg as string = sender.commandargument
select arg
case "siguiente"
if(datagrid1.currentpageindex <(datagrid1.pagecount - 1 )) then
datagrid1.currentpageindex + = 1
end if
case "anterior"
if (datagrid1.currentpageindex > 0) then
datagrid1.currentpageindex - = 1
end if
case "ultima"
datagrid1.currentpageindex= (datagrid1.pagecount -1)
case else
datagrid1.currentpageindex=0
end select
datagrid1.datasource=myquerymethod()
datagrid1.databind()
End Sub

sub mi_cambio(sender as object, e as system.web.ui.webcontrols.datagridpagechangedevent args)
datagrid1.currentpageindex=e.newpageindex
datagrid1.datasource=myquerymethod()
datagrid1.databind
end sub

Sub DropDownList1_SelectedIndexChanged(sender As Object, e As EventArgs)
datagrid1.datasource=myquerymethod(dropdownlist1.i tems(dropdownlist1.selectedindex).text)
datagrid1.pagesize=Cint(dropdownlist1.selecteditem value)
datagrid1.databind()
End Sub