How to approach: Index was outside the bounds of the array error

Question

0.00/5 (No votes)

See more:

I'm importing data given to me into a connected database. However rather than use the wizard it's required that I do the import using a web form. The data given to me is not in the best format.

My code is posted below along with comments of what the code is doing and comments of where I am having issues

C#

protected void uxImportBtn_Click(object sender, EventArgs e)
        {
            var accountTrackerImportSVC = new AccountTrackerImportSVC();
            // Imports Table
            var dtInfo = GetContent();

            foreach (DataRow drItem in dtInfo.Rows)
            {
                // Get Worker Num From LastName_PreferredFirstName
                var dataCustodian = drItem["DataCustodian"].ToString();
                var fullName = dataCustodian.Split(' ','/');
                var firstName = fullName[0];
                var lastName = fullName[1]; // Error Thrown Here

                var dtWorkerNum = AccountTrackerImportDAL.ViewWorkerNumByLastNameFirstName(lastName, firstName);

When I debug my web page I can see that 'Contractor' is being passed on to the dataCustodian variable. With the code that I have and by the format of that particular field, I won't be able to split on a 'space' or '/'.

My var firstName = 'Contractor' and the lastName be grabbed is one for the next entry. I don't have middle names, middle initials, or foreign names. I just need to know how to solve this issue.

Any ideas on how account for this in my code?

Posted 11-Aug-15 4:27am

Member 11820531

Add a Solution

Comments

Daniel Pfeffer 11-Aug-15 10:40am

If dataCustodian does not contain any spaces or slashes, fullName[] will have only one element. This is possible e.g. if you have only a last name, but no first name. I don't see a test for this condition.

Member 11820531 11-Aug-15 10:50am

That's the exact issue that I'm going through right now. I take it a test condition would consist of if else statement right? Sorry if my question seems elementary, I'm still learning the ins and outs of C#.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2015-08-11T04:54:00

"That's the exact issue that I'm going through right now. I take it a test condition would consist of if else statement right? Sorry if my question seems elementary, I'm still learning the ins and outs of C#."
Yes:

C#

string dataCustodian = drItem["DataCustodian"].ToString();
string[] fullName = dataCustodian.Split(' ','/');
if (fullName.Length >= 2)
   {
   string firstName = fullName[0];
   string lastName = fullName[1];
   ...