By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,534 Members | 865 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,534 IT Pros & Developers. It's quick & easy.

Dataenvironment for .Net

P: n/a
Hello,

I am trying to learn how to work in Visual Studio .Net 2005 and after
searching for a lot, I don't see any answer.

Actually, In VB6 I use the dataenvironment.
For my application, I have more than 1500 stored procedures / Functions
so I have put them all in a Dataenvironment so when I need something
from the database, I do DB.SPName and I immediately have a recordset.

It seem that in .Net, it is not possible anymore.
I have to create a command then add the parameters one by one...
(some procedures have 30 parameters)

I have also tried with the datasets, but there is nothing to initialize
the dataset immediately with a recordset (and parameters)

Can someone tell me how to do it or where I can find some informations
/or Tutorial to do it?

Thank you
Marc Allard
Allcomp
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Marc

This is the equivalent forum for 2005 beta testing

VB Language 2005
http://forums.microsoft.com/msdn/Sho...spx?ForumID=64

Cor

Nov 21 '05 #2

P: n/a

I miss that DataEnvironment from VB6.....

However, you can do one of 2 things that 'resemble' the DataEnvironment
.....at least for .net 2003 (I'm not familiar with 2005 yet):

i) From Sever Explorer - Connect to SQL Database and navigate to the Stored
Procs. Drag and drop them onto the forms that will be calling these stored
Procs. It will automatically create an SQL Connection object and an object
for each . You can then reference them on the form that is calling the
stored proc...

ii) Create a Master Form and store all Stored Procs there. Then make them
public and reference them from there. This is essentially the same as i)
execpt all stored procs are on one form with public access

Not quite the nice DataEnvironment but it offers you 'some similarity'

Gerry
"Allcomp" wrote:
Hello,

I am trying to learn how to work in Visual Studio .Net 2005 and after
searching for a lot, I don't see any answer.

Actually, In VB6 I use the dataenvironment.
For my application, I have more than 1500 stored procedures / Functions
so I have put them all in a Dataenvironment so when I need something
from the database, I do DB.SPName and I immediately have a recordset.

It seem that in .Net, it is not possible anymore.
I have to create a command then add the parameters one by one...
(some procedures have 30 parameters)

I have also tried with the datasets, but there is nothing to initialize
the dataset immediately with a recordset (and parameters)

Can someone tell me how to do it or where I can find some informations
/or Tutorial to do it?

Thank you
Marc Allard
Allcomp

Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.