Getting multiple rows from a stored procedure

[Gy7oizwU]

Hi Guys

I was just wondering if someone could help me out or point me in the right direction with my problem.

I am using Visual Studio and connecting to a database. I am able to return the parameters of a stored proc and use it in my frontend provided it is only 1 row of data. I now want to get multiple rows (EG - Select * from table) from a stored proc and use that data in a ListBox but i am not sure how to "get" the multiple parameters.

This is what i did to get one row.

		ConnectDB();
		SqlCommand^ searchAnimal = gcnew SqlCommand("sp_viewAnimal", cn);
		searchAnimal->CommandType = CommandType::StoredProcedure;
		searchAnimal->Parameters->Add(gcnew SqlParameter("@name", b));
		searchAnimal->Parameters["@name"]->Direction = ParameterDirection::Input;
		searchAnimal->Parameters->Add(gcnew SqlParameter("@surname", c));
		searchAnimal->Parameters["@surname"]->Direction = ParameterDirection::Input;
		searchAnimal->Parameters->Add(gcnew SqlParameter("@AnimalNameIn", a));
		searchAnimal->Parameters["@AnimalNameIn"]->Direction = ParameterDirection::Input;

		searchAnimal->Parameters->Add("@Gender", SqlDbType::VarChar, 30);
		searchAnimal->Parameters["@Gender"]->Direction = ParameterDirection::Output;
		searchAnimal->Parameters->Add("@DateOfBirth", SqlDbType::Date, 30);
		searchAnimal->Parameters["@DateOfBirth"]->Direction = ParameterDirection::Output;
		searchAnimal->Parameters->Add("@Photo", SqlDbType::VarBinary, 500000);
		searchAnimal->Parameters["@Photo"]->Direction = ParameterDirection::Output;
		searchAnimal->Parameters->Add("@AnimalType", SqlDbType::VarChar, 30);
		searchAnimal->Parameters["@AnimalType"]->Direction = ParameterDirection::Output;

		searchAnimal->ExecuteNonQuery();
		String^ gender = searchAnimal->Parameters["@Gender"]->Value->ToString();
		String^ date = searchAnimal->Parameters["@DateOfBirth"]->Value->ToString();
		String^ animalType = searchAnimal->Parameters["@AnimalType"]->Value->ToString();

Thanks in advance