Multidimensional array

[Mike]

Hi,

How can I declare and instantiate a multidimensional array that I need to return after having populated it from a DB. Here is the code:

string[,] g = new string[2,];
int i = 0;
while(rdr.Read())
{
g[0, i] = rdr.GetString(1) + " " + rdr.GetString(2);
g[1, i] = Convert.ToString(rdr.GetInt32(0)) + "~" +
rdr.GetString(3) + "~" +
rdr.GetString(4) + "~" +
rdr.GetString(5) + "~";
i++;
}

What is wrong with the above code? I try everything...

Thanks.
Mike

[Ken Kolda]

Arrays declared with square brackets are fixed-sized, not dynamic in the way you're trying to treat it. Use an ArrayList to dynamically add the rows to the array and then convert it over to a fixed-size array. For example,

ArrayList ga = new ArrayList();

int i = 0;
while (rdr.Read())
{
string[] gi = new string[2];
gi[0] = rdr.GetString(1) + " " + rdr.GetString(2);
gi[1] = Convert.ToString(rdr.GetInt32(0)) + "~" +
rdr.GetString(3) + "~" +
rdr.GetString(4) + "~" +
rdr.GetString(5) + "~" };
ga.Add(gi);
}

string[][] g = (string[][]) ga.ToArray(typeof(string[]));

Ken
"Mike" <no****@nospam.com> wrote in message news:uQ*************@TK2MSFTNGP12.phx.gbl...

Hi,

How can I declare and instantiate a multidimensional array that I need to return after having populated it from a DB. Here is the code:

string[,] g = new string[2,];
int i = 0;
while(rdr.Read())
{
g[0, i] = rdr.GetString(1) + " " + rdr.GetString(2);
g[1, i] = Convert.ToString(rdr.GetInt32(0)) + "~" +
rdr.GetString(3) + "~" +
rdr.GetString(4) + "~" +
rdr.GetString(5) + "~";
i++;
}

What is wrong with the above code? I try everything...

Thanks.
Mike

[Mike]

Thanks Ken.



"Ken Kolda" <ke*******@elliemae-nospamplease.com> wrote in message news:#f**************@TK2MSFTNGP10.phx.gbl...
Arrays declared with square brackets are fixed-sized, not dynamic in the way you're trying to treat it. Use an ArrayList to dynamically add the rows to the array and then convert it over to a fixed-size array. For example,

ArrayList ga = new ArrayList();

int i = 0;
while (rdr.Read())
{
string[] gi = new string[2];
gi[0] = rdr.GetString(1) + " " + rdr.GetString(2);
gi[1] = Convert.ToString(rdr.GetInt32(0)) + "~" +
rdr.GetString(3) + "~" +
rdr.GetString(4) + "~" +
rdr.GetString(5) + "~" };
ga.Add(gi);
}

string[][] g = (string[][]) ga.ToArray(typeof(string[]));

Ken
"Mike" <no****@nospam.com> wrote in message news:uQ*************@TK2MSFTNGP12.phx.gbl...

Hi,

How can I declare and instantiate a multidimensional array that I need to return after having populated it from a DB. Here is the code:

string[,] g = new string[2,];
int i = 0;
while(rdr.Read())
{
g[0, i] = rdr.GetString(1) + " " + rdr.GetString(2);
g[1, i] = Convert.ToString(rdr.GetInt32(0)) + "~" +
rdr.GetString(3) + "~" +
rdr.GetString(4) + "~" +
rdr.GetString(5) + "~";
i++;
}

What is wrong with the above code? I try everything...

Thanks.
Mike