sql - Getting Data MS Access then Placing it inside VBNET texbox -

-

i'm trying figure out what's wrong code, i'm trying extract value of employe id selected dropdown, information of employee , place in textbox vb.net form, there's error whenever select employee id it's giving me error message of : "an unhandled exception of type 'system.data.oledb.oledbexception' occurred in system.data.dll

additional information: no value given 1 or more required parameters."

thus highlighting reader, i'm not sure what's problem, have initialized reader... please guide me. thanks

private sub enumtext_selectedindexchanged(sender object, e eventargs) handles enumtext.selectedindexchanged           dim dbsource = "data source= c:\databse\company_db.accdb"         con.connectionstring = "provider=microsoft.ace.oledb.12.0; data source= c:\databse\company_db.accdb"          dim sqlquery string         dim sqlcommand new oledbcommand         dim sqladapter new oledbdataadapter         dim table new datatable          dim empnum string         dim empfname string         dim emplname string         dim empdept string         dim empstat string         dim empyears string          empnum = enumtext.text         empfname = empfnametext.text         emplname = emplnametext.text         empdept = depttext.text         empstat = stattext.text         empyears = yearstext.text          sqlquery = "select * tbl_empinfo empid empnum"          sqlcommand             .commandtext = sqlquery             .connection = con             .parameters.addwithvalue("empid", empnum)             sqladapter                 .selectcommand = sqlcommand                 .fill(table)             end             datagridview1                 .datasource = table             end         end          dim path = "data source= c:\databse\company_db.accdb"         dim command = "select * tbl_empinfo empid empnum"         querydata(path, command)           con.close()      end sub     private sub querydata(pathdb string, command string)         pathdb = "data source= c:\databse\company_db.accdb"         using connection new system.data.oledb.oledbconnection("provider=microsoft.ace.oledb.12.0;data source=" & pathdb)             using da new system.data.oledb.oledbcommand(command, con)                 con.open()                  dim reader = da.executereader()                 if reader.read()                     empfnametext.text = reader("firstname")                     emplnametext.text = reader("lastname")                 end if                  con.close()             end using         end using     end sub

you need prefix parameter empnum @: @empnum. see answer: how pass parameter vb.net example.


Comments

Post a Comment

Popular posts from this blog

c# - Unity IoC Lifetime per HttpRequest for UserStore -

-
i'm trying clean default implementation of accountcontroller.cs comes out of box in new mvc5/owin security implementation. have modified constructor this: private usermanager<applicationuser> usermanager; public accountcontroller(usermanager<applicationuser> usermanager) { this.usermanager = usermanager; } also, have created lifetime manager unity looks this: public class httpcontextlifetimemanager<t> : lifetimemanager, idisposable { private httpcontextbase _context = null; public httpcontextlifetimemanager() { _context = new httpcontextwrapper(httpcontext.current); } public httpcontextlifetimemanager(httpcontextbase context) { if (context == null) throw new argumentnullexception("context"); _context = context; } public void dispose() { this.removevalue(); } public override object get...
Read more

Change the color of an oval at click in Java AWT -

-
i have draw ovals in java, , @ click change color. beginning tried change color after 20 ms, doesn't work. my code is: public class mycomponentnew extends frame { public graphics2d g2d; public mycomponentnew(string title) { super(title); setsize(400, 550); } @override public void paint(graphics g) { this.g2d = (graphics2d) g; this.g2d.setcolor(color.red); this.g2d.filloval(10, 55, 50, 100); } public void changecolor () { this.g2d.setcolor(color.blue); this.g2d.filloval(10, 55, 50, 100); } } and in class main method have: mycomponentnew m; m = new mycomponentnew("fereastra cu baloane"); m.setvisible(true); m.addwindowlistener(new windowadapter() { @override public void windowclosing(windowevent we) { system.exit(0); } }); try { thread.sleep(20); } catch(interruptedexception e) {} m.changecolor(); the color of oval remains red. ...
Read more

I am trying to solve the error message 'incompatible ranks 0 and 1 in assignment' in a fortran 95 program. -

-
i writing program in fortran find velocity of parachuting person in relation time. keep getting error can't fix. new programming , appreciated. the error is v(i+1)=v(i)+[32-((c*v(i)*v(i))/m)]*(h) 1 error: incompatible ranks 0 , 1 in assignment @ (1) and program is program para integer :: real :: v(11) !velocity real :: q !initial velocity real :: h !time step real :: c !drag coefficient real :: m !mass ! gravity equal 32 ft/s^2 write (*,*)'enter time step' read(*,*)h write(*,*)'enter initial velocity' read(*,*)q write(*,*)'enter drag coefficient' read(*,*)c write(*,*)'enter mass' read(*,*)m i=1,10 ! 1 10, 1 being interval. end v(i+1)=v(i)+[32-((c*v(i)*v(i))/m)]*(h) q=v(1) end program you cannot use [] normal parenthesis in expressions. array constructor, [ items ] means array items elements. end do should after line.
Read more