Problem with string array?

public static string[] values;
int countValues = 0;

using (var connection = new MySqlConnection(connString))
{
    connection.Open();
    string query = "select * from showvalues where idvalue = '" + idStatus + "'";
    using (var command2 = new MySqlCommand(query, connection))
    {
        using (var reader2 = command2.ExecuteReader())
        {
            // Get the count of rows returned by the query
            int rowCount = (int)reader2["RowCount"];
            values = new string[rowCount]; // Initialize the values array with the appropriate size

            while (reader2.Read())
            {
                listBoxMeasurement.Items.Add(reader2.GetString("textinfo"));
                values[countValues] = reader2.GetString("textinfo");
                countValues++;
            }

            countValues = 0;
            connection.Close();
        }
    }
}

Hi Ken

The error "Object reference not set to an instance of an object" occurs when you try to access a member of an object that is currently set to null (i.e., the object has not been instantiated or initialized). In your case, it seems like the values array is not initialized, causing the error.

To fix this issue, you need to initialize the values array before using it. Since you don't know the exact number of values you'll be retrieving from the database, you can use a List to dynamically store the values and then convert it to an array if needed. Here's how you can modify your code to use a List:

public static List values = new List(); // Initialize the List

using (var connection = new MySqlConnection(connString))
{
    connection.Open();
    string query = "select * from showvalues where idvalue = '" + idStatus + "'";
    using (var command2 = new MySqlCommand(query, connection))
    {
        using (var reader2 = command2.ExecuteReader())
        {
            while (reader2.Read())
            {
                listBoxMeasurement.Items.Add(reader2.GetString("textinfo"));
                values.Add(reader2.GetString("textinfo")); // Add values to the List
            }
            connection.Close();
        }
    }
}

// If you need the values as an array, you can convert the List to an array:
string[] valuesArray = values.ToArray();