how do I call varchar(50) from C#

Can you please provide code sample,
I just need to receive all my out put values (Result of stored procedure) to my C# code

Thanks,
Praveen

I disagree - OP is using an out parameter as opposed to a return value

i am just beginner ,my knowledge is very limited....

for below code I am getting above error

using (var connection = new SqlConnection("data source=TP-PC;Persist Security Info=false;database=Asset;user id=sa;password=asd123...;Connection Timeout = 0"))
using (var command = new SqlCommand("codesearch", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Code", TxtSearch.Text.ToString());

SqlParameter op1 = new SqlParameter();
op1.ParameterName = "@Name";
op1.SqlDbType = System.Data.SqlDbType.VarChar;
op1.Direction = System.Data.ParameterDirection.Output;

SqlParameter op2 = new SqlParameter();
op2.ParameterName = "@Description";
op2.SqlDbType = System.Data.SqlDbType.VarChar;
op2.Direction = System.Data.ParameterDirection.Output;

command.Parameters.Add(op1);
command.Parameters.Add(op2);

connection.Open();

command.ExecuteNonQuery();
connection.Close();
string code1 = op1.Value.ToString();
string code2 = op2.Value.ToString();
}

My procedure

ALTER procedure [dbo].[codesearch]
(
@Code varchar(50),
@Name varchar(50) out,
@Description varchar(50) out
)
AS
Begin

select @Name = Name,@Description = Description from MstAsset where Code= @Code

End
and for below code I am getting int value

using (var connection = new SqlConnection("data source=TP-PC;Persist Security Info=false;database=Asset;user id=sa;password=asd123...;Connection Timeout = 0"))
using (var command = new SqlCommand("codesec", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Name", TxtSearch.Text.ToString());

SqlParameter op1 = new SqlParameter();
op1.ParameterName = "@ItemKey";
op1.SqlDbType = System.Data.SqlDbType.Int;
op1.Direction = System.Data.ParameterDirection.Output;

command.Parameters.Add(op1);

connection.Open();
command.ExecuteNonQuery();
connection.Close();
string val = op1.Value.ToString();
}

my procedure

ALTER procedure [dbo].[codesec]
(
@Name varchar(50),
@ItemKey int out
)
AS

begin

select @ItemKey =ItemKey from MstAsset where Name= @Name

end