update Binary field in sql server

Question

I have a string which is an encrypted binary value

(0x00C11EA094DC7F45AD2B13F42E26ED03010000006018F6DFCEC8BAFC47AC2854C21A5B00FEFA7C3035A9A4EF7AEBB9FDADBF7FA4B2E6392EA0DC4614).

I need to pass the exact above string to a VarBinary column in SQL Server from .net.

How can I do this?

Regards Rajeesh

anon · Accepted Answer · 2013-05-30 20:56:06Z

1

You can use

        var input = "your value string";
        var connectionString = "";

        using(var connection = new SqlConnection(connectionString))
        {
           connection.Open();
           using(var command = new SqlCommand("your query : stored procedure", connection))
           {
             command.CommandType = CommandType.StoredProcedure;

             // your parameter in your stored procedure
             SqlParameter parameter = new SqlParameter("@parameter", SqlDbType.VarBinary); 
             parameter.Direction = ParameterDirection.Input;
             parameter.Value = Encoding.ASCII.GetBytes(input);

             command.Parameters.Add(parameter);
             command.ExecuteNonQuery();
            }
         }

edited May 30, 2013 at 20:56

anon

4,6284 gold badges37 silver badges55 bronze badges

answered Jul 5, 2012 at 9:50

Aghilas Yakoub

29k5 gold badges49 silver badges51 bronze badges

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

1 Comment

user1503526 Over a year ago

Encoding.ASCII.GetBytes(input) will give us a new binary string and not the one i have in the input variable.... Are u getting my point?

Collectives™ on Stack Overflow

update Binary field in sql server

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related