Binary SQL Data Type

[NathanV]

I have a password field in a SQL Server db that stores passwords as an MD5
encrypted binary(16) value.

I'd like to get the value of this field out of the table to compare to user
inputted text.

I'd like to get the value out of the table in the byte[] form, with
something like this:

byte[] b = reader.????

Then do something like:

if (b == MyEncryptMethod(tbPass.text)
{

}

Thanks!
Any suggestions?

[Shiva]

byte[] b = (byte[])reader("<password_col_name>");

"NathanV" <Na*****@discussions.microsoft.com> wrote in message
news:FA**********************************@microsof t.com...
I have a password field in a SQL Server db that stores passwords as an MD5
encrypted binary(16) value.

I'd like to get the value of this field out of the table to compare to user
inputted text.

I'd like to get the value out of the table in the byte[] form, with
something like this:

byte[] b = reader.????

Then do something like:

if (b == MyEncryptMethod(tbPass.text)
{

}

Thanks!
Any suggestions?