How can I add items to an array while the array's index is growing

[JnrJnr]

I'm going to leave out most details so say for instance i have a combobox and when I select a car from the combobox I have a variable called Index that grows with each selection of the combobox. that variable is the index of my array called myArray. So when the combobox selects then the index of the array grows. There is also a SQL select statemant that retreives a value called myCar.

string[] myArray;

int Index;

private void Combobox_SelectedIndexChanged(object sender, EventArgs e)
{
SqlCommand getCar = new SqlCommand("select Car from myTable where carID = '"+ 3 +"' ", myConnection);[/code]
[code]myCar = getCar.ExecuteNoneQuery();

Index ++;
myArray = new string[Index];
MyArray[Index] = myCar.ToString();
}

The array obviously gets all it's indexes but only the last index in the array has the value of myCar and the rest is null.
The reason is because I'm declaring the array over and over each time with the new keyword.

How can I keep all the 'myCars' in the Array everytime the array's index grows?

Your Help would be appreciated

[Anton Zinchenko]

Instead of creating a new array each time, use

Array.Resize(ref array, newsize)

. Or you can use a collection:

List<string> myCollection = new List<string>();
private void Combobox_SelectedIndexChanged(object sender, EventArgs e)
{
SqlCommand getCar = new SqlCommand("select Car from myTable where carID = '"+ 3 +"' ", myConnection);
myCar = getCar.ExecuteNoneQuery();
 
myCollection.Add(myCar.ToString());
}

[JnrJnr]

Thanx Anton, Resizing the array works for me!
Bytes is awesome, Replies are more awesome