c# - InvalidCastException when converting String to String -


i've got unexplained error when working on controller class in rest api i'm working on.

the api takes datacomponent , gets data view. 1 of columns in view engineeringname(varchar(250), null)

when i'm iterating on dataset build jsonobject debugger shows me error:

an exception of type 'system.invalidcastexception' occurred in restfulwebapi.dll not handled in user code

this line fails on:

string engineername = row["engineername"].tostring();

the debugger's immediate window shows me when error occurs , check value is:

>>> ?row["engineername"]     >>> "j bloggs"

and

 >>> ?row["engineername"].tostring()      >>> "j bloggs"

i'm not sure other information can supply guys provide minimal, complete, , verifiable example please tell me if need else.

edits below:

stack trace:

restfulwebapi.dll!restfulwebapi.controllers.ole_foundationscontroller.getall() line 86 c#

(refers line i've supplied)

it seem visual studio's stack traces work in way refers line, exception may on line above (in cases). in case invalidcastexception referring line 86, castexception occuring on line 85.


-

Comments

Post a Comment

Popular posts from this blog

elasticsearch python client - work with many nodes - how to work with sniffer -

i have 1 cluster 2 nodes. i trying understand best practise connect nodes, , check failover when there downtime on 1 node. from documentation : es = elasticsearch( ['esnode1', 'esnode2'], # sniff before doing sniff_on_start=true, # refresh nodes after node fails respond sniff_on_connection_fail=true, # , every 60 seconds sniffer_timeout=60 ) so tried connect nodes this: client = elasticsearch([ip1, ip2],sniff_on_start=true, sniffer_timeout=10,sniff_on_connection_fail=true) where ip1/ip2 machine ip's (for example 10.0.0.1, 10.0.0.2) in order test it, terminated ip2 (or put non existent if) now, when trying connect, get: transporterror: transporterror(n/a, 'unable sniff hosts - no viable hosts found.') even ip1 exist , up. if trying connect this: es = elasticsearch([ip1, ip2]) then can see in log if client not getting response ip2, move ip1, , return valid response. so missing here something? thought s...
Read more

angular - Is it possible to get native element for formControl? -

i've got angular2 reactive form . created formcontrol s , assigned input fields by [formcontrol]=... . understand creates nativeelement <-> formcontrol link. my question: possible nativeelement formcontrol ? wanna myformcontrol.nativeelement.focus() i can share 1 terrible solution works me. in reactive forms can use either 1) formcontroldirective ts mycontrol = new formcontrol('') template <input type="text" [formcontrol]="mycontrol"> or 2) formcontrolname ts myform: formgroup; constructor(private fb: formbuilder) {} ngoninit() { this.myform = this.fb.group({ foo: '' }); } template <form [formgroup]="myform"> <input type="text" formcontrolname="foo"> </form> so these directives write patch like 1) formcontroldirective const originformcontrolngonchanges = formcontroldirective.prototype.ngonchanges; formcontroldirective.proto...
Read more

Upload file with tags through OwnCloud or NextCloud API -

i have database of files tagged. now, upload these files owncloud or nextcloud server , pass on existing tags show tags in respective system. wasnt able yet find way how in documentation, have idea how it? thanks! i made available source code of (remote) file tagging micro-service nextcloud on github ( https://github.com/julianthome/taggy ). implementation consists of 2 parts: 1) taggy client uploading files nextcloud server, , invoking taggy server; 2) taggy server adding specified tags uploaded files. i polish code further within next days. planning add ssl support important because username , password transmitted unencrypted taggy server. server uses these credentials in order check whether user can authenticated before tagging files. please let me know if have other ideas, suggestions or feedback ;) kind regards
Read more