Creating an array of OleDbparameter

[Susmita]

Dear Experts,
I was trying to create an array of OleDbParameter using the following code snippet, but it gave me a NullReference Exception - "Object Reference not set to an instance of an object."

OleDbParameter [] params = new OleDbParameter[2];
SPparams[0].ParameterName = "BeginningDate";
SPparams[0].Value = Convert.ToDateTime("1/1/95");

But if I changed the above array declaration/creation statement to this, it works fine:

OleDbParameter [] params = {new OleDbParameter(), new OleDbParameter()};

My question is: Is the first-form not the correct way of declaring and creating an array? Pls. note that similar code has been used in msdn for illustrating the usage of CopyTo() method of OleDbParameterCollection class.

Thanks in advance.
Susmita

 

[JurkMonkey]

OleDbParameter [] params = new OleDbParameter[2];

SPparams[0] = new OleDbParameter();

SPparams[0].ParameterName = "BeginningDate";
SPparams[0].Value = Convert.ToDateTime("1/1/95");

 

[Susmita]

Thanks for the reply.
But I would like to know what does the statement
OleDbParameter [] params = new OleDbParameter[2];
exactly do? I thought that it allocates and initializes the memory for the array.

Susmita

 

[JurkMonkey]

It certainly allocates the memory but it does not initialize it. You have to create the object and assign it to that "reserved" chunk of memory.

When you do { new object1, new object2, new object3 } you are actually creating new objects directly into the array.