Erreur: System.IndexOutOfRangeException: CVID

Est-ce que quelqu'un a deja rencontre une erreur pareille ?

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 cvid
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: CVID

Source Error:

Line 55:         protected virtual CVDetails GetCVsFromReader(IDataReader reader, bool readBody)
Line 56:         {
Line 57:              CVDetails cv = new CVDetails(
Line 58:                 (int)reader["CVID"],
Line 59:                 reader["FirstName"].ToString(),


Source File: c:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\WebSites\KoeinProject\App_Code\DAL\CVsProvider.cs    Line: 57

C'est le code qui contient la ligne d'erreur :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
        protected virtual CVDetails GetCVsFromReader(IDataReader reader)
        {
            return GetCVsFromReader(reader, true);
        }
        protected virtual CVDetails GetCVsFromReader(IDataReader reader, bool readBody)
        {
             CVDetails cv = new CVDetails(
                (int)reader["CVID"],
                reader["FirstName"].ToString(),
                reader["MiddleName"].ToString(),
                reader["LastName"].ToString(),
                reader["DateOfBirth"].ToString(),
                reader["PlaceOfBirth"].ToString(),
                reader["NationalityAtBirth"].ToString(),
                reader["MaritalStatus"].ToString(),
                reader["Sex"].ToString(),
                null,
                reader["Education"].ToString(),
                reader["Address1"].ToString(),
                reader["Address2"].ToString(),
                reader["ExpectedSalary"].ToString(),
                reader["CareerObjective"].ToString(),
                reader["AvailabilityForWork"].ToString(),
                reader["PhoneNumber"].ToString(),
                reader["Languages"].ToString(),
                reader["ComputerSkills"].ToString(),
                reader["ImageURL"].ToString());
 
 
            if (readBody)
                cv.Experience = reader["Experience"].ToString();
 
            return cv;
        }

Bah à première vue, la colonne CVID n'existe pas ou est null dans le reader.

J'utilise l'architecture 3 tiers (DAL - BLL - Interface utilisateur)

Je travaille sur une seule table: CV
J'arrive a faire des insertions mais je n'arrive pas a afficher tous les champs d'un CV dans une page!! et je n'arrive pas a trouver cette erreur!

Les deux classes suivantes font partie de la couche DAL:

SqlCVsProvider:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
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;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Web.Caching;
 
 
namespace MB.SiteName.DAL.SqlClient
{
    public class SqlCVsProvider : CVsProvider
    {
 
        /// Returns a collection with all the CVs
        /// </summary>
        public override List<CVDetails> GetCVs()
        {
            using (SqlConnection cn = new SqlConnection(this.ConnectionString))
            {
                SqlCommand cmd = new SqlCommand("CVs_GetCVs", cn);
                cmd.CommandType = CommandType.StoredProcedure;
                cn.Open();
                return GetCVCollectionFromReader(ExecuteReader(cmd));
            }
        }
 
        /// Returns an existing CV with the specified ID
 
        public override CVDetails GetCVByID(int cvID)
        {
            using (SqlConnection cn = new SqlConnection(this.ConnectionString))
            {
                SqlCommand cmd = new SqlCommand("CVs_GetCVByID", cn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@CVID", SqlDbType.Int).Value = cvID;
                cn.Open();
                IDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
                if (reader.Read())
                    return GetCVFromReader(reader);
                else
                    return null;
            }
        }
 
 
        /// Deletes a CV
 
        public override bool DeleteCV(int cvID)
        {
            using (SqlConnection cn = new SqlConnection(this.ConnectionString))
            {
                SqlCommand cmd = new SqlCommand("CVs_DeleteCV", cn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@CVID", SqlDbType.Int).Value = cvID;
                cn.Open();
                int ret = ExecuteNonQuery(cmd);
                return (ret == 1);
            }
        }
 
 
        /// Updates a CV
 
        public override bool UpdateCV(CVDetails cv)
        {
            using (SqlConnection cn = new SqlConnection(this.ConnectionString))
            {
                SqlCommand cmd = new SqlCommand("CVs_UpdateCV", cn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@CVID", SqlDbType.Int).Value = cv.CVID;
                cmd.Parameters.Add("@FirstName", SqlDbType.NVarChar).Value = cv.FirstName;
                cmd.Parameters.Add("@MiddleName", SqlDbType.NVarChar).Value = cv.MiddleName;
                cmd.Parameters.Add("@LastName", SqlDbType.NVarChar).Value = cv.LastName;
                cmd.Parameters.Add("@DateOfBirth", SqlDbType.NVarChar).Value = cv.DateOfBirth;
                cmd.Parameters.Add("@PlaceOfBirth", SqlDbType.NVarChar).Value = cv.PlaceOfBirth;
                cmd.Parameters.Add("@NationalityAtBirth", SqlDbType.NVarChar).Value = cv.NationalityAtBirth;
                cmd.Parameters.Add("@MaritalStatus", SqlDbType.NVarChar).Value = cv.MaritalStatus;
                cmd.Parameters.Add("@Sex", SqlDbType.NVarChar).Value = cv.Sex;
                cmd.Parameters.Add("@Experience", SqlDbType.NVarChar).Value = cv.Experience;
                cmd.Parameters.Add("@Education", SqlDbType.NVarChar).Value = cv.Education;
                cmd.Parameters.Add("@Address1", SqlDbType.NVarChar).Value = cv.Address1;
                cmd.Parameters.Add("@Address2", SqlDbType.NVarChar).Value = cv.Address2;
                cmd.Parameters.Add("@ExpectedSalary", SqlDbType.NVarChar).Value = cv.ExpectedSalary;
                cmd.Parameters.Add("@CareerObjective", SqlDbType.NVarChar).Value = cv.CareerObjective;
                cmd.Parameters.Add("@AvailabilityForWork", SqlDbType.NVarChar).Value = cv.AvailabilityForWork;
                cmd.Parameters.Add("@PhoneNumber", SqlDbType.NVarChar).Value = cv.PhoneNumber;
                cmd.Parameters.Add("@Languages", SqlDbType.NVarChar).Value = cv.Languages;
                cmd.Parameters.Add("@ComputerSkills", SqlDbType.NVarChar).Value = cv.ComputerSkills;
                cmd.Parameters.Add("@ImageURL", SqlDbType.NVarChar).Value = cv.ImageURL;
                cn.Open();
                int ret = ExecuteNonQuery(cmd);
                return (ret == 1);
            }
        }
 
 
        /// Creates a new cv
 
        public override int InsertCV(CVDetails cv)
        {
            using (SqlConnection cn = new SqlConnection(this.ConnectionString))
            {
                SqlCommand cmd = new SqlCommand("CVs_InsertCV", cn);
                cmd.CommandType = CommandType.StoredProcedure;
 
                cmd.Parameters.Add("@FirstName", SqlDbType.NVarChar).Value = cv.FirstName;
                cmd.Parameters.Add("@Middlename", SqlDbType.NVarChar).Value = cv.MiddleName;
                cmd.Parameters.Add("@LastName", SqlDbType.NVarChar).Value = cv.LastName;
                cmd.Parameters.Add("@DateOfBirth", SqlDbType.NVarChar).Value = cv.DateOfBirth;
                cmd.Parameters.Add("@PlaceOfBirth", SqlDbType.NVarChar).Value = cv.PlaceOfBirth;
                cmd.Parameters.Add("@NationalityAtBirth", SqlDbType.NVarChar).Value = cv.NationalityAtBirth;
                cmd.Parameters.Add("@MaritalStatus", SqlDbType.NVarChar).Value = cv.MaritalStatus;
                cmd.Parameters.Add("@Sex", SqlDbType.NVarChar).Value = cv.Sex;
                cmd.Parameters.Add("@Experience", SqlDbType.NVarChar).Value = cv.Experience;
                cmd.Parameters.Add("@Education", SqlDbType.NVarChar).Value = cv.Education;
                cmd.Parameters.Add("@Address1", SqlDbType.NVarChar).Value = cv.Address1;
                cmd.Parameters.Add("@Address2", SqlDbType.NVarChar).Value = cv.Address2;
                cmd.Parameters.Add("@ExpectedSalary", SqlDbType.NVarChar).Value = cv.ExpectedSalary;
                cmd.Parameters.Add("@CareerObjective", SqlDbType.NVarChar).Value = cv.CareerObjective;
                cmd.Parameters.Add("@AvailabilityForWork", SqlDbType.NVarChar).Value = cv.AvailabilityForWork;
                cmd.Parameters.Add("@PhoneNumber", SqlDbType.NVarChar).Value = cv.PhoneNumber;
                cmd.Parameters.Add("@Languages", SqlDbType.NVarChar).Value = cv.Languages;
                cmd.Parameters.Add("@ComputerSkills", SqlDbType.NVarChar).Value = cv.ComputerSkills;
                cmd.Parameters.Add("@ImageURL", SqlDbType.NVarChar).Value = cv.ImageURL;
 
                cmd.Parameters.Add("@CVID", SqlDbType.Int).Direction = ParameterDirection.Output;
                cn.Open();
                int ret = ExecuteNonQuery(cmd);
                return (int)cmd.Parameters["@CVID"].Value;
            }
        }
 
 
 
 
    }
}

CvsProvider:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
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;
using System.Collections.Generic;
 
namespace MB.SiteName.DAL
{
 
    public abstract class CVsProvider : DataAccess
    {
        static private CVsProvider _instance = null;
 
        /// Returns an instance of the provider type specified in the config file
 
        static public CVsProvider Instance
        {
            get
            {
                if (_instance == null)
                    _instance = (CVsProvider)Activator.CreateInstance(
                       Type.GetType(Globals.Settings.CVs.ProviderType));
                return _instance;
            }
        }
 
        public CVsProvider()
        {
            this.ConnectionString = Globals.Settings.CVs.ConnectionString;
            this.EnableCaching = Globals.Settings.CVs.EnableCaching;
            this.CacheDuration = Globals.Settings.CVs.CacheDuration;
        }
 
        // methods that work with Cvs
        public abstract List<CVDetails> GetCVs(); 
        public abstract CVDetails GetCVByID(int cvID);
        public abstract bool DeleteCV(int cvID);
        public abstract bool UpdateCV(CVDetails cv);
        public abstract int InsertCV(CVDetails cv);
 
        /// Returns a new PRCategoryDetails instance filled with the DataReader's current record data
 
        protected virtual CVDetails GetCVFromReader(IDataReader reader)
        {
           return new CVDetails(
          (int)reader["CVID"],
           reader["FirstName"].ToString(),
           reader["MiddleName"].ToString(),
           reader["LastName"].ToString(),
           reader["DateOfBirth"].ToString(),
           reader["PlaceOfBirth"].ToString(),
           reader["NationalityAtBirth"].ToString(),
           reader["MaritalStatus"].ToString(),
           reader["Sex"].ToString(),
           reader["Experience"].ToString(),
           reader["Education"].ToString(),
           reader["Address1"].ToString(),
           reader["Address2"].ToString(),
           reader["ExpectedSalary"].ToString(),
           reader["CareerObjective"].ToString(),
           reader["AvailabilityForWork"].ToString(),
           reader["PhoneNumber"].ToString(),
           reader["Languages"].ToString(),
           reader["ComputerSkills"].ToString(),
           reader["ImageURL"].ToString());
 
        }
 
 
        /// Returns a collection of CVDetails objects with the data read from the input DataReader
 
        protected virtual List<CVDetails> GetCVCollectionFromReader(IDataReader reader)
        {
            List<CVDetails> cv = new List<CVDetails>();
            while (reader.Read())
                cv.Add(GetCVFromReader(reader));
            return cv;
        }
    }
 
}

Comme je te l'ai dit, la colonne CVID n'existe pas dans le reader que tu utilises. Vérifie que CVs_GetCVByID renvoie aussi le champ CVID.

Je vous remercie !!!!!!!!!! C'etait une erreur dans le "Stored Procedure: GetCVByID" et j'ai pas fait attention que j'ai pas selectionne le CVID !!

When u're angry, u can't find ur errors lol even though I reviewed the same procedure zillion times !!

Merci Beaucoup pour votre aide !!