asp.net - C# SqlDataReader No data exists for the row/column -

-

i've been away programming while i've got need it.

i have problem sql datareader using sql server compact edition 4.0 (vs2012 built-in).

string connstring = "data source=c:\\..(path here)..\\vacationsdb.sdf"; sqlceconnection conn = new sqlceconnection(connstring); string strsql = "select * vacation vacationno = @val";  using (sqlcecommand cmd = new sqlcecommand(strsql, conn)) {     //read search value from text field     cmd.parameters.addwithvalue("@val", vacationno_txt.text);     conn.open();      sqlcedatareader reader = cmd.executereader();     fname_txt.text = reader.getstring(0);     mname_txt.text = reader.getstring(1);     /*      * .. snip      */     vacationno_txt.text = reader.getstring(11);     conn.close(); }

i keep getting error: "invalidoperationexception unhandled. no data exists row/column." , error points @ fname_txt.text = reader.getstring(0);

but there data there because "submit" button it's code working , i've checked in database table itself.

any tips? thank you.

datareaders start out before first row.

to read first row, call read() once.
if there no first row, read() return false.


Comments

Post a Comment

Popular posts from this blog

mod rewrite - Using "?" when rewriting the URL -

-
i have been researching weeks looking how rewritting file/directory complementary "?" or "question mark" what need: http://mydomain.com/demo01.php to like: http://mydomain.com/?theme=jerus theme > simple directory need use websites products(in case themes) jerus > name of theme extra info: i plan on rewritting every url individually refrain wildcard varibles.** wouldn't easy instead of doing url rewriting put php in directory called theme , name index.php? http://mydomain.com/theme/?t=jerus but if you're re-writing urls make rule acutally make route this: http://mydomain.com/theme/jerus/ which waaaay prettier see question: using clean urls in restful api
Read more

Admob integration with pygame in android -

-
hello curious know solution integrating admob app written in pygame subset android. have tried below things did' t work me :( still nothing working me may there no way :( try 1: followed google https://developers.google.com/mobile-ads-sdk/docs/admob/fundamentals#android solution has no code change build.xml modification didt works me :( try 2: tried below solutio also. http://www.michenux.net/android-admob-tutorial-461.html did't work me :( try 3: tried hack pythonactivity.java. getting below related errors. have googleadmobadssdk-6.4.1.jar in \pgs4a-0.9.4\libs path still below kind of error. below code: protected void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); //vrbilgi setcontentview(r_layout_main); // setcontentview(r.layout.main); // create adview // adview = new adview(this, adsize.banner, my_ad_unit_id); adview = new adview(this, adsize.banner,"a15...
Read more

.htaccess: Transfer name to index.php if not directory public -

-
i have piece of code: options followsymlinks <ifmodule mod_rewrite.c> rewriteengine on rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewritecond %{request_filename} !-l rewriterule ^(.*)$ index.php?url=$1 [l] </ifmodule> <ifmodule !mod_rewrite.c> errordocument 404 /index.php </ifmodule> i don't know how allow directory name "public" inside folder .htaccess, other names dir should transfered index.php. how that? add rewritecond exclude public directory rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewritecond %{request_filename} !-l rewritecond %{request_uri} ^/public(/.*)?$ rewriterule ^(.*)$ index.php?url=$1 [l] now, redirection work /public directories only. if want url have rest of path that's below public url=subfolder/page.php /public/subfolder/page.php use rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewrit...
Read more