[問題] asp.net gridview 分頁失效
我已經弄很多天了,就是弄不出來,請板上各位大大協助,拜託!
我有加上查詢條件,每次查詢完第一頁是正常,第二頁開始就會把資料庫內所有資料都LOAD出來
我該怎麼修改??
以下是我gridview的程式碼
<asp:GridView ID="GridView1" runat="server"
AutoGenerateColumns="False" DataKeyNames="識別碼"
DataSourceID="AccessDataSource1" EmptyDataText="沒有資料可顯示"
Visible="False" BackColor="White" BorderColor="#E7E7FF"
BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Horizontal"
AllowPaging="True" AutoGenerateSelectButton="True" >
<Columns>
<asp:BoundField DataField="識別碼" HeaderText="識別碼"
InsertVisible="False" ReadOnly="True" SortExpression="識別碼" />
<asp:BoundField DataField="BUILDING" HeaderText="棟別"
SortExpression="BUILDING" />
<asp:BoundField DataField="FLOOR" HeaderText="樓層"
SortExpression="FLOOR" />
<asp:BoundField DataField="DEP" HeaderText="單位代號"
SortExpression="DEP" />
<asp:BoundField DataField="SYSTEM" HeaderText="系統用途"
SortExpression="SYSTEM" />
<asp:BoundField DataField="NUMBER" HeaderText="編號"
SortExpression="NUMBER" />
<asp:BoundField DataField="NOTE" HeaderText="備註"
SortExpression="NOTE" />
</Columns>
<RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
<PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C"
HorizontalAlign="Right" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True"
ForeColor="#F7F7F7" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True"
ForeColor="#F7F7F7" />
<AlternatingRowStyle BackColor="#F7F7F7" />
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/op.mdb" SelectCommand="SELECT * FROM [電腦名稱命名規則]">
</asp:AccessDataSource><br />
拜託大家了~
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 163.15.161.238
※ 編輯: evan1112 來自: 163.15.161.238 (12/25 16:11)
→
12/25 18:14, , 1F
12/25 18:14, 1F
→
01/03 00:03, , 2F
01/03 00:03, 2F