Null Exception of array: not initialising from Oracle database

Question

I have connected my Visual studio 2013 to Oracle XE 11 Database. I'm trying to retrieve information from the tables I have in the database using the following code, but it seems that the array decor isn't getting initialised with the values I'm setting it with in the foreach loop. Please help.

conn.Open(); // it is an OleDbConnection

String[] decor;

DataTable table1 = new DataTable();

OleDbDataAdapter oda1 = new OleDbDataAdapter("select name from Product where Commodity_Type='decor'",conn);

oda1.Fill(table1);

int j=0;

foreach (DataRow row in table1.Rows)

            {

                decor[j] = row["name"].ToString();

                j++;

            }

score 3 · Answer 1 · edited Nov 20 '15 at 07:27

3

You did not initialise the variable decor

decor = new String[(table1.rows.Count())]

and that's the error you should have found by yourself.

edited Nov 20 '15 at 07:27

Maheswaran Ravisankar

17,652
6
47
69

answered Nov 20 '15 at 06:48

Slasko

407
2
8

score 0 · Accepted Answer · answered Nov 20 '15 at 06:59

Try this code: You need to initialized decor after filling the table.

conn.Open();
DataTable table1 = new DataTable();
OleDbDataAdapter oda1 = new OleDbDataAdapter("select name from Product where Commodity_Type='decor'",conn);
oda1.Fill(table1);
String[] decor = new String[(table1.rows.Count())]
int j=0;
foreach (DataRow row in table1.Rows) {
     decor[j] = row["name"].ToString();
     j++;
}

Null Exception of array: not initialising from Oracle database

2 Answers2