1
Hi,
I am pretty new to microsoft programming environment. I want to create
forms in visual basic 2005 studio that read data from stored procedures
and load into the forms for editing and new insertions back into the
database. I have created new projects using datasets that are filled by
three stored procedures that are bound to the forms using a datasource.
The problem is, we may be using Oracle as well as SQL Server to
retrieve this data and may also be moving our database to another
server later. So, should I really being creating a datasource within the
project and selecting the stored procedures into the project to add data
to the forms, or should I connect and load the data manually by writing
code to fill the datasets? It looks like when you create the datasource
in visual studio project, it asks you for the server, logon information, and
you have to specify which table and procedures you will use. Is this
information hardcoded so that I can't make it dynamic if our database
engine changes?
THanks!
Cathy
