nicht angemeldet
.net paging
hallo,
ich versuch eschon seit 2 stunden die paging funktion von asp.net zu nutzen. leider kann ich zwar eine ausgabe im datagrid definieren, aber ich bekomme keinen link zur nächsten seite hin. habe schon in diversen newsgroups geschaut. finde keinen fehler. aus diesem grund hier der code:
<%@ Page Language="VB" Debug="true" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<script runat="server">
SUB Page_Load(Sender As Object, E As EventArgs)
If not Page.IsPostBack then
BindGrid()
End if
END SUB
SUB DataGrid_Page(Sender as Object, e as DataGridPageChangedEventArgs)
DataGrid1.CurrentPageIndex = e.NewPageIndex
BindGrid()
END SUB
SUB BindGrid()
Dim CnStr As String
Dim Cn as OleDb.OleDbConnection
Dim Commd as OleDb.OleDbCommand
Dim StrSQL as String
CnStr="Provider=OraOLEDB.Oracle;" & _
"Data Source=dbname;" & _
"User ID=user;" & _
"Password=pw"
Cn = new OleDb.OleDbConnection(CnStr)
Try
Cn.Open()
ADOStatuslbl.Text = "ORACLE Verbindung hergestellt."
StrSQL = "select * from cat"
'Commd = New OleDb.OleDbCommand(strSQL)
'Commd.Connection = Cn
Dim dCmd as New OleDbDataAdapter(StrSQL, Cn)
Dim datas as New DataSet()
dCmd.Fill(datas)
DataGrid1.DataSource = datas
DataGrid1.DataBind()
Catch Excep As OleDbException
ADOStatuslbl.Text = "Es konnte keine Verbindung hergestellt werden."
end Try
Cn.Close()
ADOStatuslbl.Text = ADOStatuslbl.Text & " Verbindung geschlossen."
END SUB
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<!-- Insert content here -->
<p>
<asp:Label id="ADOStatuslbl" runat="server" BorderColor="Transparent" BackColor="Turquoise"></asp:Label>
</p>
<p>
<asp:DataGrid id="DataGrid1" runat="server" BorderColor="#DEDFDE" BackColor="White" AllowCustomPaging="True" OnPageIndexChanged="DataGrid_Page" PagerStyle-Mode = "NumericPages" AllowPaging="True" HorizontalAlign="Left" PageSize="3" Font-Size="Medium" Font-Names="Verdana" BorderStyle="None" GridLines="Vertical" BorderWidth="1px" CellPadding="4" ForeColor="Black">
<FooterStyle backcolor="#CCCC99"></FooterStyle>
<HeaderStyle font-bold="True" forecolor="White" backcolor="#6B696B"></HeaderStyle>
<PagerStyle nextpagetext="Next" prevpagetext="Last" horizontalalign="Right" forecolor="Black" backcolor="#F7F7DE" mode="NumericPages"></PagerStyle>
<SelectedItemStyle font-bold="True" forecolor="White" backcolor="#CE5D5A"></SelectedItemStyle>
<AlternatingItemStyle backcolor="White"></AlternatingItemStyle>
<ItemStyle borderwidth="3px" backcolor="#F7F7DE"></ItemStyle>
</asp:DataGrid>
</p>
</form>
</body>
</html>
ronny