OK with 1.1, System.IndexOutOfRangeException with 2

  • Thread starter Thread starter acb
  • Start date Start date
A

acb

Hi,

I have an aspx page that works well with Framework 1.1 and crashes with
Framework 2. What follows is the error page and the source code.

--- error page

Server Error in '/' Application.
--------------------------------------------------------------------------------

Index was outside the bounds of the array.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: Index was outside
the bounds of the array.

Source Error:


Line 22: DataSet dataset = new DataSet();
Line 23: dataset.Clear();
Line 24: adapter.Fill(dataset,"StatCountry");
Line 25:
Line 26: DataView dvw = dataset.Tables["StatCountry"].DefaultView;


Source File:
c:\Inetpub\wwwroot\VISUALASPNET\Ch06\ASPDataGrid_cache.aspx Line: 24


Stack Trace:


[IndexOutOfRangeException: Index was outside the bounds of the array.]
System.Data.ProviderBase.DbBuffer.ReadTime(Int32 offset) +1034856
System.Data.Odbc.CNativeBuffer.MarshalToManaged(Int32 offset, SQL_C
sqlctype, Int32 cb) +588
System.Data.Odbc.OdbcDataReader.GetBoundColumnValue(Int32 i) +667
System.Data.Odbc.OdbcDataReader.internalGetValue(Int32 i) +85
System.Data.Odbc.OdbcDataReader.GetValues() +28
System.Data.Odbc.OdbcDataReader.Read() +284
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping
mapping) +156
System.Data.Common.DataAdapter.FillFromReader(DataSet dataset,
DataTable datatable, String srcTable, DataReaderContainer dataReader,
Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn,
Object parentChapterValue) +157
System.Data.Common.DataAdapter.Fill(DataSet dataSet, String
srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
+172
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) +175
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String
srcTable) +83
ASP.ASPDataGrid_cache_aspx.Page_Load(Object Sender, EventArgs e) in
c:\Inetpub\wwwroot\VISUALASPNET\Ch06\ASPDataGrid_cache.aspx:24
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object
o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object
sender, EventArgs e) +36
System.Web.UI.Control.OnLoad(EventArgs e) +102
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
+1064




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50215.44;
ASP.NET Version:2.0.50215.44


----- source code

<%@ Page Language="C#" Debug="True" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.Odbc" %>

<html>
<head>
<script Language="C#" runat="server">
// DATABASE CONNECTION


void Page_Load (Object Sender, EventArgs e)
{
if (!IsPostBack)
{
string connection = "DSN=Cache";
string query = "SELECT * FROM StatCountry";

OdbcConnection conn = new OdbcConnection(connection);
OdbcDataAdapter adapter = new OdbcDataAdapter();
adapter.SelectCommand = new OdbcCommand(query, conn);

DataSet dataset = new DataSet();
adapter.Fill(dataset,"StatCountry");

DataView dvw = dataset.Tables["StatCountry"].DefaultView;

MyDataGrid.DataSource = dvw;
MyDataGrid.DataBind();
}
}
</script>
</head>

<body>

<asp:datagrid id="MyDataGrid" runat="server" />

</body>
</html>


--------- end code

Thank you

Chris
 
Back
Top