Attempted to access an element as a type incompatible with the array.

Question

0.00/5 (No votes)

See more:

Dear People

Im having a problem with array. On my form_load im executing an sql statement by using an OleDbDataReader object. Here is my code...

MSIL

public partial class DtposMDIParentSystem : Form
    {
        
        List<string[]> result = new List<string[]>();
        
        public DtposMDIParentSystem()
        {
            InitializeComponent();
        }
        
        private void DtposMDIParentSystem_Load(object sender, EventArgs e)
        {
            //create the database connection
            OleDbConnection aConnection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\AP_AE\Desktop\DTPOS_APP\DataBase\DtposDatabase.accdb;");
            
            //connection = new OleDbConnection(connectionString);
            //create the command object and store the sql query
            OleDbCommand aCommand = new OleDbCommand("SELECT * FROM Food", aConnection);
            try
            {
                aConnection.Open();
                //create the datareader object to connect to table
                OleDbDataReader reader = aCommand.ExecuteReader();
                int i = 0;
                while (reader.Read())
                {
                    result.Add(new string[reader.FieldCount]);
                    reader.GetValues(result[i]);
                }
                reader.Close();
                aConnection.Close();

            }
            catch (InvalidOperationException ex)
            {
                MessageBox.Show("Invalid Masseage = " + ex.Message);
            
            }
}

When I run my application I get a message saying

ArrayTypeMismatchException was unhandled

Attempted to access an element as a type incompatible with the array.

Any help would be very very greatfull...

thanks in advance

Kind regards

Roni

Posted 12-Dec-10 8:37am

LAPEC

Add a Solution

Comments

Dr.Walt Fair, PE 12-Dec-10 15:06pm

What are you trying to do here:
result.Add(new string[reader.FieldCount]);
Where is result defined?

Manfred Rudolf Bihy 12-Dec-10 15:24pm

@Walt:Third line in his code!

2 solutions

Solution 2

If you are more comfortable dealing with DataTables than List<>s, you might consider putting your data into a DataTable using this:

C#

public class DBUtilities
{
    public static DataTable ReaderToTable(DbDataReader reader)
    {
        DataTable newTable = new DataTable();
        DataColumn col;
        DataRow row;
        int i;

        for (i = 0; i < reader.FieldCount; i++)
        {
            col = new DataColumn();
            col.ColumnName = reader.GetName(i);
            col.DataType = reader.GetFieldType(i);

            newTable.Columns.Add(col);
        }

        while (reader.Read())
        {
            row = newTable.NewRow();
            for (i = 0; i < reader.FieldCount; i++)
            {
                row[i] = reader[i];
            }

            newTable.Rows.Add(row);
        }

        return newTable;
    }
}

you would use it in your code like this:

C#

public partial class DtposMDIParentSystem : Form
    {
        
        DataTable result = null;
        
        public DtposMDIParentSystem()
        {
            InitializeComponent();
        }
        
        private void DtposMDIParentSystem_Load(object sender, EventArgs e)
        {
            //create the database connection
            OleDbConnection aConnection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\AP_AE\Desktop\DTPOS_APP\DataBase\DtposDatabase.accdb;");
            
            //connection = new OleDbConnection(connectionString);
            //create the command object and store the sql query
            OleDbCommand aCommand = new OleDbCommand("SELECT * FROM Food", aConnection);
            try
            {
                aConnection.Open();
                //create the datareader object to connect to table
                OleDbDataReader reader = aCommand.ExecuteReader();
                result = DBUtilities.ReaderToTable(reader);

                reader.Close();
                aConnection.Close();

            }
            catch (InvalidOperationException ex)
            {
                MessageBox.Show("Invalid Masseage = " + ex.Message);
            
            }
}

Posted 12-Dec-10 10:18am

Henry Minute

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)

Manfred Rudolf Bihy · Accepted Answer · 2010-12-12T09:23:00

Hi Lapec,

your problem is in the declaration of result:

List<string[]>

and this line here:

reader.GetValues(result[i])

The reader is trying to store something into the string array that is most likely not a string. What ever is returned from the DB not all columns are of string type. You might have success by turning all of the columns of table food into strings, but that might not work for the DB your using.

Try to go like this: List<object[]> result = ...
Then later on when you access what was read you'd have to detect the type and make an explicit cast to access whatever is there.

Modification:

C#

List<object[]> result = new List<Object[]>();
...
result.Add(new Object[reader.FieldCount]);
reader.GetValues(result[i]);

Cheers

Manfred