Solved

IDataReader System.IndexOutOfRangeException on Class File Object

Posted on 2008-10-24
3
579 Views
Last Modified: 2012-05-05
Hi,

I'm building a class file, and I am getting an System.IndexOutOfRangeException: 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"].ToString(); in the public Data999(IDataReader reader) section


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();

Open in new window

0
Comment
Question by:krapvag
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 6

Expert Comment

by:Werrock
ID: 22798146
Could you add the business object once more. I cannot see it.
0
 
LVL 1

Author Comment

by:krapvag
ID: 22799446
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();

      }
}
0
 
LVL 6

Accepted Solution

by:
Werrock earned 125 total points
ID: 22799705
Yeah, its probably since the column does not exists. This has been addressed before at:
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_23257624.html

So please confirm that the column exists and try to check it before calling or handle exceptions by catching them in the constructor.
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a simple method to resize a control at runtime.  It includes ready-to-use source code and a complete sample demonstration application.  We'll also talk about C# Extension Methods. Introduction In one of my applications…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question