Solve the binary conversion problem

weiranli00

code show as below:
SqlCommand cmd = new SqlCommand ("UserIsExict", conn);
cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add (new SqlParameter ("@ Uid", SqlDbType.Binary, 30));
cmd.Parameters ["@ Uid"]. Value = Encoding.UTF32.GetBytes (paraUid);

cmd.Parameters.Add (new SqlParameter ("@ UserName", SqlDbType.Binary, 30));
cmd.Parameters ["@ UserName"]. Direction = ParameterDirection.Output;

conn.Open ();
cmd.ExecuteNonQuery ();
conn.Close ();

I want to get the value of the parameter "@UserName" in cmd and convert it to string type. The parameter "@UserName" is binary type.

sms119

string str;
str = cmd.Parameters ["@ UserName"]. value.ToString ();

weiranli00

This wo n’t work, you ca n’t get it

weiranli00

It seems that the obtained value is empty and cannot be displayed

sms119

It cannot be converted. . Still can't get

weiranli00

Oh, I see, the string displayed after conversion is blank anyway

xyx0312575

Convert.ToBase64String (inputValue);

xyx0312575

Convert.FromBase64String (inputValue);

rirgw1

ParameterDirection.Output;

To:

 ParameterDirection.ReturnValue;

weiranli00

Let me try