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.Netcalling 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

yai 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 statementand also i didn't pass any parameter for idthis 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 codingsi verify all the codings but i cant able to find out why this errors will occurone 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 arraywhen 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.