c# - Oracle Stored Procedure not returning any value -


i'm calling oracle stored procedure c# login form it's not returning value. dt.rows.count below 0 , if part of if-else statement never executed, gets else part.

c# code:

string sconnectionstring = "data source=xe;user id=system;password=system;";  oracleconnection myconnection = new oracleconnection(sconnectionstring); myconnection.open();  oraclecommand mycommand = new oraclecommand("spvalidatedba", myconnection);  mycommand.commandtype = commandtype.storedprocedure; mycommand.commandtext = "spvalidatedba"; mycommand.parameters.add("username", oracledbtype.varchar2, 50); mycommand.parameters["username"].value = txtusrid.text.tostring(); mycommand.parameters.add("userpassword", oracledbtype.varchar2, 50); mycommand.parameters["userpassword"].value = txtpassword.text.tostring(); mycommand.parameters.add("datacount", oracledbtype.int32, 20).direction = parameterdirection.output; oracledatareader myreader = mycommand.executereader(); datatable dt = new datatable(); dt.load(myreader);   if (dt.rows.count>0)     {         custommsgbox.show("\tlogin successful\t" + environment.newline +           "welcome db utilities tool", "db utilities tool", "ok", "cancel");         dba dba = new dba();         dba.show();         this.hide();     }  else     custommsgbox.show("please enter correct username/password",     "db utilities tool", "ok", "cancel");         myconnection.close(); }

oracle stored procedure:

create or replace procedure spvalidatedba(     username in varchar2,     userpassword in varchar2,   datacount out integer)   begin select count(*) datacount dba_user user_name=username ,     user_pwd=userpassword , user_role = 'dba';     end spvalidatedba;

please note table dba_user contains 1 row values as:

user_name   user_pwd    user_role    dask       password     dba

thus, datacount in above stored procedure should return 1 row value 1 when inputs login form dask(username) & password(userpassword), it's not returning anything.

can please tell me i'm going wrong this? need issue resolved soon.

you not returning result set sp datatable empty. returning value in output parameter. use executenonquery , read value parameter.

try this

mycommand.executenonquery(); int datacount = 0; if(mycommand.parameters["datacount"] ! =null) {   datacount = convert.toint32(mycommand.parameters["datacount"].value); }  if(datacount > 0) {    custommsgbox.show("..."); }

Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

javascript - jQuery show full size image on click -

pretty self explanatory not workking . i want display full image when user click on image... yes know there tons of plugins but i want keep simple. any idea ? css : .full { display: none; width: 500px; height: 500px; margin-left: 100px; margin-top: -300px; position: fixed; background-color: #f00; z-index: 6; } .thumbnail { width: 50px; height: 50px; } html: <img class="thumbnail" src="http://4.bp.blogspot.com/-uhbdp2esxng/txneptvi92i/aaaaaaaaaky/upfqis7zto0/s1600/rihanna-wallpaper.jpg"> jquery: $(document).ready(function() { $('.thumbnail').on('click', function() { var img = $('<img />',{src:this.src,'class':'full'}); $('.full').html(img).show(); console.log('done!'); }); }); try looking how jquery works. $(document).ready(function() { $('.thumbnail').on('click', function(...
Read more