simple array problem

okay this is what would seem to be a simple problem... but I am stumped. I am taking multiple columns from an sql db and putting into an object array. Then I put all the objects in a string array. I would like to assign each value in the string array to a variable.

here is my load_array method

private void load_array()

{

/* create connection */

SqlConnection conn = new SqlConnection("Data Source=192.168.168.134\\MSSQLLITMARK;Initial Catalog=Litmark;User id=sa;password=**************;");

SqlCommand cmd = new SqlCommand("SELECT Images_ID FROM tbImages WHERE Images_CarID = @car_id", conn);

cmd.Parameters.AddWithValue("@car_id", car_id);

try

{

/* array list to hold data */

ArrayList list = new ArrayList();

conn.Open();

SqlDataReader reader = cmd.ExecuteReader();

while (reader.Read())

{

object[] values = new object[reader.FieldCount].ToArray();

reader.GetValues(values);

list.Add(values);

}

/* now convert to a string array */

foreach (object[] row in list)

{

string[] details = new string[row.Length];

int columnIndex = 0;

foreach(object column in row)

{

details[columnIndex++] = Convert.ToString(column);

}

/* Assign the itmes in the string array to picture boxes. */

/* I have global variables picID1 - picID5 that I would like to assign the data in string[] */

for (int i = 0; i < details.Length; i++)

{

MessageBox.Show("array : " + details[i]);

}

catch (Exception ex)

{

MessageBox.Show("error: " + ex.Message.ToString());

}

Try this,

private void LoadImages()

{

System.Collections.ArrayList list = new System.Collections.ArrayList();

// Separate your db code

using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(""))

{

using (System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand("", conn))

{

command.Parameters.AddWithValue("@car_id", "");

try

{

conn.Open();

using (System.Data.SqlClient.SqlDataReader reader = command.ExecuteReader())

{

if (reader.HasRows)

while (reader.Read())

list.Add(reader["Images_ID"]); // More than 1 field create a struct or classs

}

catch (Exception)

{

}

if (list.Count > 0)

{

for (int i = 0; i < list.Count; i++)

{

string imageID = list[i].ToString();

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Felipe Ramos16y ago
Try this,

private void LoadImages()
   {
   System.Collections.ArrayList list = new System.Collections.ArrayList();

   // Separate your db code
   using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(""))
   {
   using (System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand("", conn))
   {
   command.Parameters.AddWithValue("@car_id", "");
   try
   {
   conn.Open();

   using (System.Data.SqlClient.SqlDataReader reader = command.ExecuteReader())
   {
   if (reader.HasRows)
   while (reader.Read())
   list.Add(reader["Images_ID"]); // More than 1 field create a struct or classs

   }
   }
   catch (Exception)
   {
   }
   }
   }

   if (list.Count > 0)
   {
   for (int i = 0; i < list.Count; i++)
   {
   string imageID = list[i].ToString();
   }
   }
   }