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
Loading
krithika muthukrishnanPosted Feb 1, 2011, 5:35 AM
Krishna GaradPosted Feb 1, 2011, 2:24 AM
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 GaradPosted Feb 1, 2011, 2:13 AM
krithika muthukrishnanPosted Feb 1, 2011, 2:00 AM
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 GaradPosted Feb 1, 2011, 1:11 AM
krithika muthukrishnanPosted Feb 1, 2011, 12:41 AM
after i modifying , Procedure or function registrations has too many arguments specified.error will occur how can i solve this
thank you
Krishna GaradPosted Jan 31, 2011, 11:19 PM
Suthish NairPosted Jan 31, 2011, 1:47 PM
krithika muthukrishnanPosted Jan 31, 2011, 8:28 AM
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
Krishna GaradPosted Jan 31, 2011, 7:14 AM
krithika muthukrishnanPosted Jan 31, 2011, 7:10 AM
Failed to convert parameter value from a String to a Byte[].this error will occur.
Krishna GaradPosted Jan 31, 2011, 6:51 AM
See Here