asp.net - Web Service: Decimal Not Being Passed to Database Correctly -

-

i have web service , can see data member of 0.03 being passed web service database showing 0.000. column in database defined decimal(18,4). data member of business class defined decimal. using visual studio 2010, sql server 2008 , .net 4.0. why isn't 0.03 appearing in database column rather 0.000?

int createapp;  shortsaleinvestorreviewserviceclient _service = new shortsaleinvestorreviewserviceclient();  decimal currentinterestrate = txtcurrentinterestrate.text != string.empty ? decimal.parse(txtcurrentinterestrate.text) : new decimal();  createapp = _service.updateshortsaleapplication(currentinterestrate);

the web service through linq calls stored procedure update table.

alter procedure [dbo].[updateshortsaleapplication]                  @ishortsaleapplicationid int,    @icurrentinterestrate decimal,        update [shortsaleapplications] set [currentinterestrate] = @icurrentinterestrate     shortsaleapplicationid = @ishortsaleapplicationid

when stepping through above code, can see "0.03" being passed web-service linq stored procedure. underlying column in database shows "0.0000". column in database defined decimal(18,4). how else can debug or fix?

you have not set precision , scale decimal variable in stored procedure , creating problem.

alter procedure [dbo].[updateshortsaleapplication]
@ishortsaleapplicationid int,
@icurrentinterestrate decimal,

by default sql server takes precision 18 , scale 0.link

p (precision) maximum total number of decimal digits stored, both left , right of decimal point. precision must value 1 through maximum precision of 38. the default precision 18. s (scale) number of decimal digits stored right of decimal point. number substracted p determine maximum number of digits left of decimal point. maximum number of decimal digits can stored right of decimal point. scale must value 0 through p. scale can specified if precision specified. the default scale 0; therefore, 0 <= s <= p. maximum storage sizes vary, based on precision.

change

the column in database defined decimal(18,4)


Comments

Post a Comment

Popular posts from this blog

c++ - OpenCV Error: Assertion failed <scn == 3 ::scn == 4> in unknown function, -

-
i read alot other solution still confused should mine... #include <opencv2/objdetect/objdetect.hpp> #include <opencv2/highgui/highgui.hpp> #include <opencv2/imgproc/imgproc.hpp> #include <iostream> #include <stdio.h> using namespace std; using namespace cv; int main(int argc, const char** argv) { //create cascade classifier object used face detection cascadeclassifier face_cascade; //use haarcascade_frontalface_alt.xml library face_cascade.load("haarcascade_frontalface_alt.xml"); //setup video capture device , link first capture device videocapture capturedevice; capturedevice.open(0); //setup image files used in capture process mat captureframe; mat grayscaleframe; //create window present results namedwindow("outputcapture", 1); //create loop capture , find faces while (true) { //capture new image frame capturedevice >> captureframe; ...
Read more

php - render data via PDO::FETCH_FUNC vs loop -

-
i've been using 2 methods render data. the first one: function name($id,$name){ return '<div id="'.$id.'">'.$name.'</div>'; } echo implode($pdo->query("select id,name user")->fetchall(pdo::fetch_func,'name')); the second one: $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); foreach($users $user){ echo name($user->id,$user->name); } i don't understand how pdo::fetch_func works. tried figure out. however, not well-documented. could please explain fetch mode? , also, 1 performs better? thank you. both methods wrong , have learn how use templates , how separate business logic presentation logic. $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); tpl::assign('users', $users); is code business logic part. then in template <?php foreach $users $row): ?> <div id="<?=$...
Read more

The canvas has been tainted by cross-origin data in chrome only -

-
uncaught securityerror: failed execute 'getimagedata' on 'canvasrenderingcontext2d': canvas has been tainted cross-origin data i getting above error in chrome. code(following) works fine in mozilla. have not corss domain issue. why above error in chrome? var wheel_canvas, wheel_context, can_w, can_h, wheel_grd; var large_radius = 160; var small_radius = 120; var wheel_canvas = document.getelementbyid('wheel_canvas'); var wheel_context = wheel_canvas.getcontext('2d'); var can_w = $(wheel_canvas).width(); var can_h = $(wheel_canvas).height(); var centerx = can_w / 2, centery = can_h / 2; var wheel_grd = null; test('#ff0000'); function test(hex) { $('#clrpicker').css({'left': 210, 'top': 210 }); inverted = hexbw(hex); $('#color_val_show').val(hex); current_color_hex_val_selected = hex; $('#color_val_show').css({'color':inverted,'background':hex}); fillgradient...
Read more