C# Error: Error converting nvarchar datatype to int. HELP! -
i'm having hard time c# application. everytime run code below, gives me error convertion of nvarchar datatype int. have tried casting doesn't seem work.
connectionstring myconnstring = new connectionstring(); string connstring = myconnstring.getconnectionstring(); sqlconnection connvalidate = new sqlconnection(connstring);  sqlcommand cmdvalidate = new sqlcommand("xxx", connvalidate); cmdvalidate.commandtype = commandtype.storedprocedure;  cmdvalidate.parameters.add(new sqlparameter("@accountid", currentuser)); cmdvalidate.parameters.add(new sqlparameter("@periodmonth", convert.tostring(comboboxmonth.selecteditem).trim().toupper())); cmdvalidate.parameters.add(new sqlparameter("@periodyear", convert.toint32(comboboxyear.selectedvalue)));  connvalidate.open();  int32 result = convert.toint32(cmdvalidate.executescalar());  connvalidate.dispose(); connvalidate.close();   here stored procedure using:
alter procedure [dbo].[xxx]     @accountid char(6),     @periodmonth char(10),     @periodyear int,     @date int,     @periodid int,     @inventoryid int,     @productoutid int     select @periodid = periodid periods     periodmonth = @periodmonth , periodyear = @periodyear , accountid = @accountid      select @inventoryid = inventoryid fact      periodid = @periodid , accountid = @accountid      select @productoutid = productoutid inventory     inventoryid = @inventoryid      select dailyoutid dailyout     productoutid = @productoutid , date = @date return   what want here check whether period of same month , year entered user existing in database. basically, stored procedure should return value if period entered exists, if so, messagebox shown user alerting existence of same period. thank much! :)
- start sql profiler can capture exact sql being sent server.
 - copy , paste sql query analyzer or sql management studio.
 - run it, perferably in debug mode, , tell line number has problem.
 
my guess periods.periodmonth isn't char(10), need see line error on.
Comments
Post a Comment