472,145 Members | 1,514 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

VB 2005 and retrieving data through stored procedures

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

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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.