public void arrayExecute(GameObject[] spawnArray, string type) { reader=command.ExecuteReader(); int sentinal=0; while(reader.Read()) { Debug.Log(reader[0]); spawnArray[sentinal] = new GameObject(reader[0].ToString()); spawnArray[sentinal].AddComponent<FoodStats>(); Debug.Log(spawnArray[sentinal].name.ToString() + " spawned"); spawnArray[sentinal].GetComponent<FoodStats>().calories = int.Parse(reader[1].ToString()); //int.Parse(reader[4].ToString()); if (spawnArray[sentinal].GetComponent<FoodStats>().calories != null) { Debug.Log(spawnArray[sentinal].name.ToString() + " calories calculated" + " " + spawnArray[sentinal].GetComponent<FoodStats>().calories.ToString()); } else { Debug.Log("Skipped"); } spawnArray[sentinal].GetComponent<FoodStats>().setFoodType(type); Debug.Log(spawnArray[sentinal].name.ToString() + " type set"); sentinal++; } reader.Close(); }
public void Execute() { reader=command.ExecuteReader(); while(reader.Read()) { Debug.Log(reader[0]); //mystring = reader[0].ToString(); mynum= int.Parse(reader[0].ToString()); Debug.Log(mynum + "edit"); /* for(int counter=0; counter<4; counter++) { Debug.Log(reader[counter]); } */ } reader.Close(); }