I know this has been addressed before as I've googled for examples however the majority of the sites I come to are filled with bad links as their dates go back from the late 90s up to 2006. So hasn't quite helped with my search.
The IBM Redbook Integrating DB2 Universal Database for iSeries with Microsoft ADO .NET has given me some insight but seems to target Java and C++. And still I am a little confused. So looking for something a little simple that I can explore and branch out of on my own. I primarly program in RPGILE on a I5 development box and I write programs to convert data from one vendor system into our system. Been programming in RPG for about 17 years now. I took both C++ and Visual Basic back in the late 90s in college however never touched it again since till now. Some for VB is easy enough but other a decent learning curve but I'm progressing ok. Now enough of me babbling here is what I want to do:
I can do this with MS Access however I want to write a stand alone program to do the same. Give it a feeling of accomplishment if I am able to develop something on my own this way. As it'll help teach me how to evolve beyond. This project will be a simple account look up. I will have 3 forms. The 1st form is the connection one. I want it to ask for user name and password (masking the password) with two buttons Connect and Exit. I can code the Exit easily enough however I want to make sure the connection closes if active when exit is chosen. So will need some insight on that. Otherwise it's a simple Me.Close()
Then the 2nd form contains two buttons one for Enter and the 2nd to Exit (or maybe log off). There will be a label and a text field asking for a old encounter number. Once Enter is hit it will using the connection query a file just to make this easy TESTFILE out of TESTLIB. Then it will pull the information into the 3rd form showing the old encounter, new encounter number and the patient's name. Along with a button to go back to the selection form.
So basically how with VB do I make that connection to the system and select the table? And yes client access is installed.
Thanks and hopefully I presented enough information.
The IBM Redbook Integrating DB2 Universal Database for iSeries with Microsoft ADO .NET has given me some insight but seems to target Java and C++. And still I am a little confused. So looking for something a little simple that I can explore and branch out of on my own. I primarly program in RPGILE on a I5 development box and I write programs to convert data from one vendor system into our system. Been programming in RPG for about 17 years now. I took both C++ and Visual Basic back in the late 90s in college however never touched it again since till now. Some for VB is easy enough but other a decent learning curve but I'm progressing ok. Now enough of me babbling here is what I want to do:
I can do this with MS Access however I want to write a stand alone program to do the same. Give it a feeling of accomplishment if I am able to develop something on my own this way. As it'll help teach me how to evolve beyond. This project will be a simple account look up. I will have 3 forms. The 1st form is the connection one. I want it to ask for user name and password (masking the password) with two buttons Connect and Exit. I can code the Exit easily enough however I want to make sure the connection closes if active when exit is chosen. So will need some insight on that. Otherwise it's a simple Me.Close()
Then the 2nd form contains two buttons one for Enter and the 2nd to Exit (or maybe log off). There will be a label and a text field asking for a old encounter number. Once Enter is hit it will using the connection query a file just to make this easy TESTFILE out of TESTLIB. Then it will pull the information into the 3rd form showing the old encounter, new encounter number and the patient's name. Along with a button to go back to the selection form.
So basically how with VB do I make that connection to the system and select the table? And yes client access is installed.
Thanks and hopefully I presented enough information.
Comment