Member_4438002
asked on
IDataReader System.IndexOutOfRangeException on Class File Object
Hi,
I'm building a class file, and I am getting an System.IndexOutOfRangeExce ption: when I get past the third property. I have no idea why!
I've attached my business object
The error is raised on the line that reads: _DataTitle = reader["DataTitle"].ToStri ng(); in the public Data999(IDataReader reader) section
I'm building a class file, and I am getting an System.IndexOutOfRangeExce
I've attached my business object
The error is raised on the line that reads: _DataTitle = reader["DataTitle"].ToStri
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
/// <summary>
/// Summary description for Data999
/// </summary>
///
public class Data999
{
private string _DataTitle;
public string DataTitle
{
get { return _DataTitle; }
set { _DataTitle = value; }
}
private string _Forename;
public string Forename
{
get { return _Forename; }
set { _Forename = value; }
}
private string _Surname;
public string Surname
{
get { return _Surname; }
set { _Surname = value; }
}
private string _Honours;
public string Honours
{
get { return _Honours; }
set { _Honours = value; }
}
private string _BusinessPrefix;
public string BusinessPrefix
{
get { return _BusinessPrefix; }
set { _BusinessPrefix = value; }
}
private string _Premises;
public string Premises
{
get { return _Premises; }
set { _Premises = value; }
}
private string _Throughfare;
public string Throughfare
{
get { return _Throughfare; }
set { _Throughfare = value; }
}
private string _Locality;
public string Locality
{
get { return _Locality; }
set { _Locality = value; }
}
private string _Postcode;
public string Postcode
{
get { return _Postcode; }
set { _Postcode = value; }
}
private string _addedBy;
public string addedBy
{
get { return _addedBy; }
set { _addedBy = value; }
}
private string _TelephoneNumber;
public string TelephoneNumber
{
get { return _TelephoneNumber; }
set { _TelephoneNumber = value; }
}
private string _Deleted;
public string Deleted
{
get { return _Deleted; }
set { _Deleted = value; }
}
public Data999(IDataReader reader)
{
_addedBy = reader["addedBy"].ToString();
_TelephoneNumber = reader["TelephoneNumber"].ToString();
_Deleted = reader["Deleted"].ToString();
_DataTitle = reader["DataTitle"].ToString();
_Forename = reader["Forename"].ToString();
_Surname = reader["Surname"].ToString();
_Honours = reader["Honours"].ToString();
_BusinessPrefix = reader["BusinessPrefix"].ToString();
_Premises = reader["Premises"].ToString();
_Throughfare = reader["Throughfare"].ToString();
_Locality = reader["Locality"].ToString();
_Postcode = reader["Postcode"].ToString();
}
}
================
EXCEPTION DETAILS
================
Exception Details: System.IndexOutOfRangeException: DataTitle
Source File: c:\Inetpub\wwwroot\eff999\App_code\Data999.cs Line: 109
Source Error:
Line 107: _TelephoneNumber = reader["TelephoneNumber"].ToString();
Line 108: _Deleted = reader["Deleted"].ToString();
Line 109: _DataTitle = reader["DataTitle"].ToString();
Line 110: _Forename = reader["Forename"].ToString();
Line 111: _Surname = reader["Surname"].ToString();
Could you add the business object once more. I cannot see it.
ASKER
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls. WebParts;
using System.Web.UI.HtmlControls ;
/// <summary>
/// Summary description for Data999
/// </summary>
///
public class Data999
{
private string _DataTitle;
public string DataTitle
{
get { return _DataTitle; }
set { _DataTitle = value; }
}
private string _Forename;
public string Forename
{
get { return _Forename; }
set { _Forename = value; }
}
private string _Surname;
public string Surname
{
get { return _Surname; }
set { _Surname = value; }
}
private string _Honours;
public string Honours
{
get { return _Honours; }
set { _Honours = value; }
}
private string _BusinessPrefix;
public string BusinessPrefix
{
get { return _BusinessPrefix; }
set { _BusinessPrefix = value; }
}
private string _Premises;
public string Premises
{
get { return _Premises; }
set { _Premises = value; }
}
private string _Throughfare;
public string Throughfare
{
get { return _Throughfare; }
set { _Throughfare = value; }
}
private string _Locality;
public string Locality
{
get { return _Locality; }
set { _Locality = value; }
}
private string _Postcode;
public string Postcode
{
get { return _Postcode; }
set { _Postcode = value; }
}
private string _addedBy;
public string addedBy
{
get { return _addedBy; }
set { _addedBy = value; }
}
private string _TelephoneNumber;
public string TelephoneNumber
{
get { return _TelephoneNumber; }
set { _TelephoneNumber = value; }
}
private string _Deleted;
public string Deleted
{
get { return _Deleted; }
set { _Deleted = value; }
}
public Data999(IDataReader reader)
{
_addedBy = reader["addedBy"].ToString ();
_TelephoneNumber = reader["TelephoneNumber"]. ToString() ;
_Deleted = reader["Deleted"].ToString ();
_DataTitle = reader["DataTitle"].ToStri ng();
_Forename = reader["Forename"].ToStrin g();
_Surname = reader["Surname"].ToString ();
_Honours = reader["Honours"].ToString ();
_BusinessPrefix = reader["BusinessPrefix"].T oString();
_Premises = reader["Premises"].ToStrin g();
_Throughfare = reader["Throughfare"].ToSt ring();
_Locality = reader["Locality"].ToStrin g();
_Postcode = reader["Postcode"].ToStrin g();
}
}
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.
using System.Web.UI.HtmlControls
/// <summary>
/// Summary description for Data999
/// </summary>
///
public class Data999
{
private string _DataTitle;
public string DataTitle
{
get { return _DataTitle; }
set { _DataTitle = value; }
}
private string _Forename;
public string Forename
{
get { return _Forename; }
set { _Forename = value; }
}
private string _Surname;
public string Surname
{
get { return _Surname; }
set { _Surname = value; }
}
private string _Honours;
public string Honours
{
get { return _Honours; }
set { _Honours = value; }
}
private string _BusinessPrefix;
public string BusinessPrefix
{
get { return _BusinessPrefix; }
set { _BusinessPrefix = value; }
}
private string _Premises;
public string Premises
{
get { return _Premises; }
set { _Premises = value; }
}
private string _Throughfare;
public string Throughfare
{
get { return _Throughfare; }
set { _Throughfare = value; }
}
private string _Locality;
public string Locality
{
get { return _Locality; }
set { _Locality = value; }
}
private string _Postcode;
public string Postcode
{
get { return _Postcode; }
set { _Postcode = value; }
}
private string _addedBy;
public string addedBy
{
get { return _addedBy; }
set { _addedBy = value; }
}
private string _TelephoneNumber;
public string TelephoneNumber
{
get { return _TelephoneNumber; }
set { _TelephoneNumber = value; }
}
private string _Deleted;
public string Deleted
{
get { return _Deleted; }
set { _Deleted = value; }
}
public Data999(IDataReader reader)
{
_addedBy = reader["addedBy"].ToString
_TelephoneNumber = reader["TelephoneNumber"].
_Deleted = reader["Deleted"].ToString
_DataTitle = reader["DataTitle"].ToStri
_Forename = reader["Forename"].ToStrin
_Surname = reader["Surname"].ToString
_Honours = reader["Honours"].ToString
_BusinessPrefix = reader["BusinessPrefix"].T
_Premises = reader["Premises"].ToStrin
_Throughfare = reader["Throughfare"].ToSt
_Locality = reader["Locality"].ToStrin
_Postcode = reader["Postcode"].ToStrin
}
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.