469,344 Members | 5,548 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,344 developers. It's quick & easy.

VB 2005 and retrieving data through stored procedures

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
Oct 24 '06 #1
0 2204

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Hursh | last post: by
6 posts views Thread by Wojciech Wendrychowicz | last post: by
3 posts views Thread by Arpan | last post: by
11 posts views Thread by Nemisis | last post: by
7 posts views Thread by =?Utf-8?B?R3JlZw==?= | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.