convert byte array to hex in c#

Question

I need to run a stored procedure from code. One of the input parameters is rowVersion of the table. rowVersion is a byte array ( {0, 0, 0, 0, 0, 0, 13, 191} that's 0x0000000000000DBF in db). So if to add rowVersion this way :

cmd.Parameters.AddWithValue("@myPKRowversion", 0x0000000000000DBF);

my sp is working. But when I'm adding it like here:

uint a = 0x0000000000000DBF;
cmd.Parameters.AddWithValue("@myPKRowversion", a);

or if I convert byte Array to string like:

string a = "0x0000000000000DBF";
cmd.Parameters.AddWithValue("@myPKRowversion", a);

my sp is not working. What should I do to make my sp work?

Can't really test this, but 0x0000000000000DBF is detected by the IDE as being an Int32, not a UInt32. So your working example and your first non-working example aren't the same. Does it work if you use an int instead of a uint? — Tim
– Tim, Commented Jan 23, 2014 at 15:03
@Tim solution that JonSkeet suggested is working fine in my code. But anyway you are right also. When I changed uint to Int32 my sp does not give me error also! — Sasha
– Sasha, Commented Jan 23, 2014 at 15:13

Jon Skeet · Accepted Answer · 2014-01-23 15:01:15Z

3

I suggest you add it as a byte array. For example:

byte[] bytes = new byte[] { 0, 0, 0, 0, 0, 0, 13, 191 };
cmd.Parameters.Add("@myPKRowVersion", SqlDbType.Binary).Value = bytes;

If you're trying to specify bytes, the most natural type is a byte array...

answered Jan 23, 2014 at 15:01

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

convert byte array to hex in c#

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related