为什么DataGrid不能正常分页???
kazan 2003-07-21 04:01:58 代码如下:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim conn As New OleDb.OleDbConnection
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("demo.mdb")
conn.Open()
Dim mycmd As New OleDb.OleDbCommand
mycmd.CommandText = "Select * from msc_table"
mycmd.Connection = conn
Dim Myapater As New OleDb.OleDbDataAdapter(mycmd)
Dim MyDataSet As New DataSet
Myapater.Fill(MyDataSet, "Table_1")
DataGrid1.DataSource = MyDataSet.Tables("table_1").DefaultView
DataGrid1.DataBind()
End Sub
====================================================
HTML代码:
<asp:DataGrid id="DataGrid1" runat="server" Width="360px" Height="112px" PageSize="5" BorderColor="#CC9966"
BorderStyle="None" BorderWidth="1px" BackColor="White" CellPadding="5" AllowPaging="True"
AllowCustomPaging="True">
<SelectedItemStyle Font-Bold="True" ForeColor="#663399" BackColor="#FFCC66"></SelectedItemStyle>
<ItemStyle ForeColor="#330099" BackColor="White"></ItemStyle>
<HeaderStyle Font-Bold="True" ForeColor="#FFFFCC" BackColor="#990000"></HeaderStyle>
<FooterStyle ForeColor="#330099" BackColor="#FFFFCC"></FooterStyle>
<PagerStyle HorizontalAlign="Center" ForeColor="#330099" BackColor="#FFFFCC"></PagerStyle>
</asp:DataGrid>