.NET run stored procedure, get output

Question

I am running this stored procedure with .NET like so:

public List<showWhatClass> showWhatMethod(string deviceWhat, int tagWhat, Decimal latit, Decimal longit, int Process, string CallNext, int CallNextVar)
{
    showWhatCell = new List<showWhatClass>();

    try
    {
        using (connection = new SqlConnection(connectionString))
        {
            using (SqlCommand command = new SqlCommand("iosShowWhat", connection))
            {
                command.CommandType = CommandType.StoredProcedure;

                command.Parameters.AddWithValue("@DeviceId", deviceWhat);
                command.Parameters.AddWithValue("@TagId", tagWhat);
                command.Parameters.AddWithValue("@Latitude", latit);
                command.Parameters.AddWithValue("@Longitude", longit);
                command.Parameters.AddWithValue("@Process", Process);
                command.Parameters.AddWithValue("@CallNext", CallNext);
                command.Parameters.AddWithValue("@CallNextVar", CallNextVar);

                connection.Open();
                SqlDataReader reader = command.ExecuteReader();

                while (reader.Read())
                {
                    showWhatClass item = new showWhatClass();
                    item.CallNext = reader.GetValue(0).ToString();
                    item.CallNextVar = (int)reader.GetValue(1);
                    showWhatCell.Add(item);
                }
            }
        }
    }
    finally
    {
        connection.Close();
    }

    return showWhatCell;
}

The stored procedure returns the following message:

When I run this I get the following returned:

<ArrayOfshowWhatClass xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/WebServiceAPI.Models"/>

which is empty

my question is what am I doing wrong, how come nothing is returning when I run this with .NET but does return the message in SQL Server.

Here is my showWhatClass

public class showWhatClass
{
        public string CallNext { get; set; }
        public int CallNextVar { get; set; }
}

Screenshot which you have posted is of `Messages` tab or `Results` tab? — Rahul Singh, Dec 16 '15 at 18:11
So check your `Results` tab cz there you will find the actual results of your query. `Messages` tab is to display messages like _rows affected_, custom messages which you print using _print_ keyword. — Rahul Singh, Dec 16 '15 at 18:16
Never tried that but a simple search took me [here](http://stackoverflow.com/questions/7663844/c-sharp-handle-on-sql-server-message-output). Also why you wan't to read your results like this? Its weird approach! — Rahul Singh, Dec 16 '15 at 18:19

score 0 · Answer 1 · answered Dec 17 '15 at 00:36

0

Try to change your parameters:

command.Parameters.AddWithValue("@DeviceId", deviceWhat);

to the following:

command.Parameters.Add("@DeviceId", SqlDbType.Int).Value = deviceWhat;

answered Dec 17 '15 at 00:36

Khazratbek

1,656
2
10
17

all of them, try to change and execute again. Hope it helps – Khazratbek Dec 17 '15 at 00:36

.NET run stored procedure, get output

1 Answers1