c# error about array (Object reference not set to an instance of an object.)

Question

error image http://i.stack.imgur.com/AC5sE.png

i want to add data to dataz but found error when build

This my code

int i = 0;
string[][,] dataz = null;
conn.Open();

OleDbCommand db = conn.CreateCommand();
db.CommandType = CommandType.Text;
db.CommandText = "select name,img from [building] order by id asc ";

OleDbDataReader oReader = db.ExecuteReader();


while (oReader.Read())
{

        string name = oReader.GetString(0);
        string img = oReader.GetString(1);
        dataz[i] = new string[,] { { "name", name }, { "img", img } };
        i++;

}
conn.Close();

Editing your question doesn't mean that it's not a duplicate... — Lee Taylor, Dec 07 '14 at 21:58

score -2 · Answer 1 · answered Dec 07 '14 at 21:24

-2

Use Linq To SQL

var data = 
    ctx.Buildings.OrderBy(x => x.id).Select(x => new { x.name, x.img }).ToArray();

answered Dec 07 '14 at 21:24

Boris Gappov

2,427
14
22

Please elaborate why your answer is the solution to the problem. – Qix - MONICA WAS MISTREATED Dec 07 '14 at 22:30
The problem can be solved at different levels. I hope my solution will interest novice programmer, he learns with Linq That SQL or another ORM – Boris Gappov Dec 08 '14 at 07:33

c# error about array (Object reference not set to an instance of an object.)

1 Answers1