16
Hi!
I have a girdview that use oracle database, the result is more than more page, how could I show the result in many page?
I used AllowPaging="True", but the just the result of page one was right and for other pages I'v got this error:
"Serverfeil i programmet /Totalsalg.
GridView GridView1 started PageIndexChanging that is handeld."
Please help me.
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="False" GridLines="None"
AutoGenerateColumns="False" CellPadding="6" >
<RowStyle BackColor="#FFFFFF" />
<AlternatingRowStyle BackColor="#CCCCCC" />
<Columns>
<asp:BoundField DataField="QUANTITY" HeaderText="Antall" ReadOnly="True" AccessibleHeaderText="false" SortExpression="QUANTITY" ItemStyle-HorizontalAlign="Right" />
<asp:BoundField DataField="SUMNOK" DataFormatString="{0:n0}" HtmlEncode="false" HeaderText="Pris" ReadOnly="True" AccessibleHeaderText="false" SortExpression="SUMNOK" ItemStyle-HorizontalAlign="Right" />
<asp:BoundField DataField="RegDate" HeaderText="Dato" ReadOnly="True" AccessibleHeaderText="False" SortExpression="RegDate" />
</Columns>
</asp:GridView>
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
OracleConnection MyConnection;
OracleCommand MyCommand;
OracleDataAdapter MyAdaptor;
DataTable MyTable = new DataTable();
MyConnection = new OracleConnection();
MyConnection.ConnectionString = ConfigurationManager.ConnectionStrings["TestDB"].ConnectionString;
MyCommand = new OracleCommand();
MyCommand.CommandText = "Select sum(o.quantity) as Quantity, SUM(o.quantity*s.price) as SumNOK, SUBSTR(o.regdate,7,4)||'-'||SUBSTR(o.regdate,1,2)||'-'||SUBSTR(o.regdate,4,2) as RegDate FROM shamrock.cat_order o, shamrock.cat_salesproduct s WHERE o.salesproductId=s.salesproductnum GROUP BY SUBSTR(o.regdate,7,4)||'-'||SUBSTR(o.regdate,1,2)||'-'||SUBSTR(o.regdate,4,2)";
MyCommand.CommandType = CommandType.Text;
MyCommand.Connection = MyConnection;
MyAdaptor = new OracleDataAdapter();
MyAdaptor.SelectCommand = MyCommand;
MyAdaptor.Fill(MyTable);
GridView1.DataSource = new DataView(MyTable, String.Empty, "REGDATE DESC", DataViewRowState.CurrentRows);
GridView1.DataBind();
MyAdaptor.Dispose();
MyCommand.Dispose();
MyConnection.Dispose();
}
}
