MySQL and C#.Net Stored Procedure and multiple parameter -

-

i developing (converting application db ms sql mysql) application using c#.net , mysql. c# code , stored procedure working perfect in ms sql when trying ingrate mysql getting parameter error. c# code below , mysql stored procedure running (tested in editor using call key work , parameter) 

 public datatable alapvalidateuser(string email, string password,string type)     {         datatable dt = new datatable();         cmd = new mysqlcommand("useridvalidation");         cmd.commandtype = commandtype.storedprocedure;         cmd.connection = cnn;         string pass = reencryptpassword(password);          mysqlparameter pramemail = new mysqlparameter("@v_emailid", email);         pramemail.direction = parameterdirection.input;         cmd.parameters.add(pramemail);          mysqlparameter prampassword = new mysqlparameter("@v_password", pass);         prampassword.direction = parameterdirection.input;         cmd.parameters.add(prampassword);          mysqldataadapter adap = new mysqldataadapter(cmd);         if (cnn.state != connectionstate.open ||             cnn.state == connectionstate.broken ||             cnn.state != connectionstate.connecting ||             cnn.state != connectionstate.executing ||             cnn.state != connectionstate.fetching)             cnn.open();          adap.fill(dt);         cnn.close();         return dt;     }

mysql stored procedure here:

create definer=`root`@`localhost` procedure `useridvalidation`(v_emailid national varchar(100),v_password  national varchar(50)) begin    select userid ,email,bloodgroup ,bloodgroupid,country countryslno ,countryname ,state ,district ,location,fname,lname ,donortype ,lastlogin ,validated ,profileimage       ,maritalstatus ,sex ,height ,weight  ,healthstatus       ,myfilelocation vwuser email = v_emailid ,    password = v_password , validated = 'y'; end$$

during execution exception below:

"incorrect number of arguments procedure alap.useridvalidation; expected 2, got 1"

can please me find out error.

update: mysql connector v.6.6.5. have checked in debug mode in c# parameter correct , can see both paramter in command object. next trying filling adapter hence command object passing mysql connector , there paramter missing. have tried add same 1st parameter creating 3rd line gettinng error same paramter exist. test sure purely mysql or mysql connector bug. dont know how bug can exists in such db many people using mysql. suman

this bug of sql , have received solution mysql team. have implemented changes in mysql stored procedure , got solution. mysql reply below

hi suman,

i have reproduced issue described, , exists workaround works fine , keep speed in migration mysql. problem here national usage in definition of parameters routine. if want define particular character set can define routine this:

create definer=`root`@`localhost` procedure `useridvalidation`(v_emailid varchar(100) ***character set utf8***,v_password varchar(50) character set utf8) begin .... rest of code

or can use

create definer=`root`@`localhost` procedure `useridvalidation`(v_emailid varchar(100),v_password varchar(50)) begin     ....

the default character set in server utf8 , equivalent national according documentation.

you can check more information here:

http://dev.mysql.com/doc/refman/5.5/en/charset-national.html

please let me know if workaround worked you.


Comments

Post a Comment

Popular posts from this blog

Perl - how to grep a block of text from a file -

-
it can in xml or text format. how in general grep block of text in perl? <track type="ws"> <range> <rangestart>0</rangestart> <rangeend>146.912</rangeend> <locationindex>0</locationindex> <propertyindex>0</propertyindex> </range> </track> <track type="ps" id="1"> <range> <rangestart>0</rangestart> <rangeend>146.912</rangeend> <locationindex>1</locationindex> <propertyindex>1</propertyindex> </range> </track> i want grep type="ps" , till </range> . one solution open file, read line line , match block. open(fh, "file.txt"); foreach $line (<fh>) { if ($line =~ m/type="cc"(.*?)<\/range>/) { print $1; } } but there more optimal solution without reading file line l
Read more

delphi - How to remove all the grips on a coolbar if I have several coolbands? -

-
Image
if set mycoolbar.fixedorder true,only grip on first band hidden. well,if use delphi 7 create vcl forms application,then put coolbar on , create 3 coolbans hold other controls,only grip , top coolbands can hidden setting mycoolbar.fixedorder:=true. i've uploaded picture make things clear. you got fixedorder property wrong. fixed property not allow bands rearranged if set true . setting property of coolbar true keep user changing bands order @ runtime, user can still move , resize bands. can give advice can do, actual solution problem, well, have wait answer. my advice use 3 coolbars in row , setting "fixedorder" property true , bandborderstyle bsnone . way grip hidden on of them. about property, it's not bug of ide, actual preference of property.
Read more

javascript - Animating array of divs; only the final element is modified -

-
this baffling me @ moment. i'm experienced programmer looking throw bit of surprise fiancee on countdown page our wedding. desired effect simulated confetti falling behind main page. setup follows: i have array of divs in javascript. each div absolutely positioned on page. have interval set updates every 50 or milliseconds. on each tick, run loop on array of divs, , calculations , update positions. problem problem having, however, though can see divs created, stored array, , modified (in case, each has slight randomized rotation) during initialization phase, once tick update position starts, div stored in whatever last slot of array gets position updated. tried hard-coding each div index testing purposes, strictly last element update position. upon printing current "left" , "top" style values each div before , after calculations shows value has been changed, no visible change noticeable. here's basic code: javascript var container;
Read more