Failed to convert parameter value from a String to a Byte[].

Question

hi,
in cs page i am going to insert some values and the coversion of bytefile to the sql table using stored procedure. i assign the value to the parameter.when i execute it
cmd.executenonquery()//Failed to convert parameter value from a String to a Byte[].
this error will occur.How to solve this

krithika muthukrishnan · Answer

already i perform this modification at that time also the same error will occur

Krishna Garad · Answer

use like this and see the difference what you have done and why this error is occuring cmd.Parameters.Add("@mail", SqlDbType.VarChar); cmd.Parameters[0].Value = mail; cmd.Parameters.Add("@pword", SqlDbType.VarChar); cmd.Parameters[1].Value = pword; cmd.Parameters.Add("@cpword", SqlDbType.VarChar); cmd.Parameters[2].Value = cpword; cmd.Parameters.Add("@mobno", SqlDbType.NChar); cmd.Parameters[3].Value = mobno; cmd.Parameters.Add("@name1", SqlDbType.VarChar); cmd.Parameters[4].Value = name1; cmd.Parameters.Add("@dob", SqlDbType.VarChar); cmd.Parameters[5].Value = dob; cmd.Parameters.Add("@gender", SqlDbType.VarChar); cmd.Parameters[6].Value = gender; cmd.Parameters.Add("@currentlocation", SqlDbType.VarChar); cmd.Parameters[7].Value = currentlocation ; cmd.Parameters.Add("@address", SqlDbType.VarChar); cmd.Parameters[8].Value = address; cmd.Parameters.Add("@totexp", SqlDbType.VarChar); cmd.Parameters[9].Value = totexp; cmd.Parameters.Add("@preferlocation ", SqlDbType.VarChar); cmd.Parameters[10].Value = preferlocation; cmd.Parameters.Add("@functionalarea", SqlDbType.VarChar); cmd.Parameters[11].Value = fnctalarea; cmd.Parameters.Add("@currentrole", SqlDbType.VarChar); cmd.Parameters[12].Value = currentrole; cmd.Parameters.Add("@areaofspecific", SqlDbType.VarChar); cmd.Parameters[13].Value = areaofspecific; cmd.Parameters.Add("@ugcourse", SqlDbType.VarChar); cmd.Parameters[14].Value = ug1course; cmd.Parameters.Add("@ugspecify", SqlDbType.VarChar); cmd.Parameters[15].Value = ug1specify; cmd.Parameters.Add("@uginstitute", SqlDbType.VarChar); cmd.Parameters[16].Value = ug1institute; cmd.Parameters.Add("@ugyop", SqlDbType.VarChar); cmd.Parameters[17].Value = ug1yop; cmd.Parameters.Add("@pgcourse", SqlDbType.VarChar); cmd.Parameters[18].Value = pg1course; cmd.Parameters.Add("@pgspecify", SqlDbType.VarChar); cmd.Parameters[19].Value = pg1specify; cmd.Parameters.Add("@pginstitute", SqlDbType.VarChar); cmd.Parameters[20].Value = pg1institute; cmd.Parameters.Add("@pgyop", SqlDbType.VarChar); cmd.Parameters[21].Value = pg1yop; cmd.Parameters.Add("@resume", SqlDbType.VarBinary); cmd.Parameters[22].Value = buffer;

Krishna Garad · Answer

I think first you need to learn Ado.Net,calling stored procedure and other to do this work. Check out the sequence of parameter in stored procedure and the sequence you are passing from front end.

krithika muthukrishnan · Answer

ya,i checked the number of parameters passed and then number of values in insert statement both have the same number of values and in same order, now also the same error will occur. And then i have one doubt while creating a table i mention the field id with autoincrement.but i didn't mention the id field in insert statement,and also i didn't pass any parameter for id,this one may cause the error?

Krishna Garad · Answer

Count the no. of parameters declare in stored procedure and no .of parameter you are passing. as well in Isert statement of Stored procedure check how many parameters you are inserting and mind it the sequence also in both places.

krithika muthukrishnan · Answer

hi, after i modifying , Procedure or function registrations has too many arguments specified.error will occur how can i solve this thank you

Krishna Garad · Answer

Cause Of error every time you were passing parameter[0].value it's pick up the last parameter value which is varchar how many parameter you are adding be carefull about exact parameter exact value.

Suthish Nair · Answer

use StreamReader instead of BinaryReader

krithika muthukrishnan · Answer

hi, here i attached my codings,i verify all the codings but i cant able to find out why this errors will occur,one who find it pls tell me. thank u

krithika muthukrishnan · Answer

Now i'm creating a job website.after converting the file to a byte array,when i am going to insert the bytearray file and then other textbox values to a sql table using stored procedure. Failed to convert parameter value from a String to a Byte[].this error will occur.

Krishna Garad · Answer

after successfull execution also you are unable to do same work. See Here

Krishna Garad · Answer

Upload .cs file with stored procedure.

Failed to convert parameter value from a String to a Byte[].

Answers (12)