SQL INSERT query....not inserting varbinary(max) data

Question

0.00/5 (No votes)

See more:

I am inserting some information using this code.
but i face problem in inserting "password"
password collummn is a varbinary(MAX) type.
but when I run this code and see the result in my database. every entries correct but in password collumn it is sowing that "< binary data >" not sowing password which is in Binary form.

C#

SqlCommand smd;
 private void saveInformation(string command)
 {
     try
     {
         string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ToString();
         sc = new SqlConnection(connectString);
         smd = new SqlCommand(command, sc);
         sc.Open();
         smd.ExecuteNonQuery();
     }
     catch (Exception ex)
     {
         errormsg.Text= ex.Message;
     }

 }

 protected void bemember_Click(object sender, EventArgs e)
 {
     string Name =  name.Text;
     string Email = email.Text;
     string Passtxt = pass.Text;
     byte[] Pass = GetSHA1(Email, Passtxt);
     string command = "Insert into userInfo (username,password,email) values('"+Name+"', CAST('"+Pass+"' AS varbinary(max)),'"+Email+"')";
     saveInformation(command);
 }

 private static byte[] GetSHA1(string userID, string password)
 {
     SHA1CryptoServiceProvider sha = new SHA1CryptoServiceProvider();
     return sha.ComputeHash(System.Text.Encoding.ASCII.GetBytes(userID + password));
 }pre>

Posted 11-Oct-12 23:12pm

jeetveer

Updated 11-Oct-12 23:18pm

v4

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

arunrv · Answer 1 · 2012-10-11T23:33:00

Why cant you store procedure for that
1St create a store Procedure like this
Here Pass coloum datatypeis varbinary(MAX) in table

SQL

create procedure [dbo].[SP_Insert]
(@username varchar(20),@password varchar(20),@Pass varbinary(max))
as begin
-- Your Insert Query here
  insert into Table1(username ,password ,Pass ) values (@username,@password,@Pass)
end

/////////////// In C# code you can write code like this

C#

byte[] Pass = GetSHA1(Email, Passtxt);
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ToString();


           SqlConnection con=new SqlConnection(connectString );
           cmd.CommandType = CommandType.StoredProcedure;
           cmd.CommandText = "SP_Insert";
           cmd.Connection = con;
           con.open();

           cmd.Parameters.Add("@username",name.Text );
            cmd.Parameters.Add("@password",pass.Text );
             cmd.Parameters.Add("@Pass",Pass  );// your bute[] variable Pass
              cmd.ExecuteReader();
             con.close()

Hope this may help you..........................................

SQL INSERT query....not inserting varbinary(max) data

1 solution

Solution 1

Add your solution here

Preview 0

SQL INSERT query....not inserting varbinary(max) data

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us