get return from sql c#

Question

I need to get the return of one select that comes from a procedure. I saw about using the ExecuteReader, but I’m not getting the data that’s coming in. To procedure is fine

As the return of procedure it’s gonna be something like this and both varchar.

Item | Name Item

given a | given b
given c | given c

I thought of creating a matrix of 2 by n lines.

The problem is when it comes to ExecuteReader to get the values of the item and the item name Here is my code

         string[][] retorno = new string[2][];
        string constr = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
        using(SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand("Sp_SelectContratoGestores"))
            {

                cmd.CommandTimeout = 300;
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Connection = con;
                con.Open();
                while (cmd.ExecuteReader().Read())
                {

                    retorno[0][contador] = cmd.ExecuteReader().ToString();
                    contador++;
                }
                con.Close();
            }
        }

Answer 1

Modify this part of your code:

while (cmd.ExecuteReader().Read())
{
   retorno[0][contador] = cmd.ExecuteReader().ToString();
   contador++;
}

To:

SqlDataReader reader = cmd.ExecuteReader();

while (reader.Read())
{
   retorno[0][contador] = reader["NOME_DA_SUA_COLUNA"].ToString();
   contador++;
}

Answer 2

Example:

string constr = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand("Sp_SelectContratoGestores"))
            {

                cmd.CommandTimeout = 300;
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Connection = con;
                con.Open();
                SqlDataReader reader = cmd.ExecuteReader();
                if (!reader.HasRows)
                    throw new Exception("Não há registros");

                while (reader.Read())
                {
                    string dado0 = reader["dado0"].ToString();
                    int dado1 = int.Parse(reader["dado1"].ToString());

                }
            }
        }