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

"Data Environment" for VB.net ?

P: n/a
Hello,
Sorry for the cross-posting, I first posted this message to the vb.6 NG
(wrong group) <g>.

Are there any add-in or tools out there (for VB.NET ) that would allow one
to drag and drop database fields onto a form. (similar to the
DataEnvironment in vb.6) ?

I am looking for one that could set the validation rules for each TextBox
based on the definition of the fields in the tables

I know there is the Data Form Wizard but that's not what I need.

TIA

Nov 20 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Yeah, you want to look at DataAdapters and Datasets, which are all part of
the ADO.NET package.

However they have completly different designers, because after all the .NET
environment is completly different, there is no separate DataEnvironment
(which I did like but I like DA's more now).

Also, remember ADO.NET is disconnected where as DE's were connected
recordsets. (the connection was kept alive through the life of the
recordset), ado.net does not.

HTH,
CJ

"P. Prosper" <mo**************@moca-coop.com> wrote in message
news:eQ**************@TK2MSFTNGP11.phx.gbl...
Hello,
Sorry for the cross-posting, I first posted this message to the vb.6 NG
(wrong group) <g>.

Are there any add-in or tools out there (for VB.NET ) that would allow one
to drag and drop database fields onto a form. (similar to the
DataEnvironment in vb.6) ?

I am looking for one that could set the validation rules for each TextBox
based on the definition of the fields in the tables

I know there is the Data Form Wizard but that's not what I need.

TIA

Nov 20 '05 #2

P: n/a
Just to add onto what CJ said, you are now disconnected. You can define a
LOT of validation in your dataset, but you aren't hooked to the db so you
won't necessarily know if your value is ok or not until you submit the
update (although most of the stuff, like types, autoincrement , allownull
etc can be done client side).
"CJ Taylor" <[cege] at [tavayn] dit commmmm> wrote in message
news:e8**************@TK2MSFTNGP09.phx.gbl...
Yeah, you want to look at DataAdapters and Datasets, which are all part of
the ADO.NET package.

However they have completly different designers, because after all the ..NET environment is completly different, there is no separate DataEnvironment
(which I did like but I like DA's more now).

Also, remember ADO.NET is disconnected where as DE's were connected
recordsets. (the connection was kept alive through the life of the
recordset), ado.net does not.

HTH,
CJ

"P. Prosper" <mo**************@moca-coop.com> wrote in message
news:eQ**************@TK2MSFTNGP11.phx.gbl...
Hello,
Sorry for the cross-posting, I first posted this message to the vb.6 NG
(wrong group) <g>.

Are there any add-in or tools out there (for VB.NET ) that would allow one to drag and drop database fields onto a form. (similar to the
DataEnvironment in vb.6) ?

I am looking for one that could set the validation rules for each TextBox based on the definition of the fields in the tables

I know there is the Data Form Wizard but that's not what I need.

TIA


Nov 20 '05 #3

P: n/a
Thanks for your quick answers,
What I am looking for, is the ability to drag and drop table fields onto the
form. Couldn't find a way to do that with the dataset.

"William Ryan eMVP" <do********@comcast.nospam.net> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
Just to add onto what CJ said, you are now disconnected. You can define a
LOT of validation in your dataset, but you aren't hooked to the db so you
won't necessarily know if your value is ok or not until you submit the
update (although most of the stuff, like types, autoincrement , allownull
etc can be done client side).
"CJ Taylor" <[cege] at [tavayn] dit commmmm> wrote in message
news:e8**************@TK2MSFTNGP09.phx.gbl...
Yeah, you want to look at DataAdapters and Datasets, which are all part of
the ADO.NET package.

However they have completly different designers, because after all the

.NET
environment is completly different, there is no separate DataEnvironment
(which I did like but I like DA's more now).

Also, remember ADO.NET is disconnected where as DE's were connected
recordsets. (the connection was kept alive through the life of the
recordset), ado.net does not.

HTH,
CJ

"P. Prosper" <mo**************@moca-coop.com> wrote in message
news:eQ**************@TK2MSFTNGP11.phx.gbl...
Hello,
Sorry for the cross-posting, I first posted this message to the vb.6 NG (wrong group) <g>.

Are there any add-in or tools out there (for VB.NET ) that would allow

one to drag and drop database fields onto a form. (similar to the
DataEnvironment in vb.6) ?

I am looking for one that could set the validation rules for each TextBox based on the definition of the fields in the tables

I know there is the Data Form Wizard but that's not what I need.

TIA



Nov 20 '05 #4

P: n/a
Wait until Whidbey ;-). It's still pretty easy though, drag the dataset and
just set the databindings, it's very easy.
"P. Prosper" <mo**************@moca-coop.com> wrote in message
news:Oh*************@TK2MSFTNGP10.phx.gbl...
Thanks for your quick answers,
What I am looking for, is the ability to drag and drop table fields onto the form. Couldn't find a way to do that with the dataset.

"William Ryan eMVP" <do********@comcast.nospam.net> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
Just to add onto what CJ said, you are now disconnected. You can define a
LOT of validation in your dataset, but you aren't hooked to the db so you won't necessarily know if your value is ok or not until you submit the
update (although most of the stuff, like types, autoincrement , allownull etc can be done client side).
"CJ Taylor" <[cege] at [tavayn] dit commmmm> wrote in message
news:e8**************@TK2MSFTNGP09.phx.gbl...
Yeah, you want to look at DataAdapters and Datasets, which are all part
of the ADO.NET package.

However they have completly different designers, because after all the .NET
environment is completly different, there is no separate
DataEnvironment (which I did like but I like DA's more now).

Also, remember ADO.NET is disconnected where as DE's were connected
recordsets. (the connection was kept alive through the life of the
recordset), ado.net does not.

HTH,
CJ

"P. Prosper" <mo**************@moca-coop.com> wrote in message
news:eQ**************@TK2MSFTNGP11.phx.gbl...
> Hello,
> Sorry for the cross-posting, I first posted this message to the
vb.6 NG > (wrong group) <g>.
>
> Are there any add-in or tools out there (for VB.NET ) that would

allow one
> to drag and drop database fields onto a form. (similar to the
> DataEnvironment in vb.6) ?
>
> I am looking for one that could set the validation rules for each

TextBox
> based on the definition of the fields in the tables
>
> I know there is the Data Form Wizard but that's not what I need.
>
> TIA
>
>
>



Nov 20 '05 #5

P: n/a
Guess I'll have to wait :-)

Tx william

"William Ryan eMVP" <do********@comcast.nospam.net> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Wait until Whidbey ;-). It's still pretty easy though, drag the dataset and just set the databindings, it's very easy.
"P. Prosper" <mo**************@moca-coop.com> wrote in message
news:Oh*************@TK2MSFTNGP10.phx.gbl...
Thanks for your quick answers,
What I am looking for, is the ability to drag and drop table fields onto the
form. Couldn't find a way to do that with the dataset.

"William Ryan eMVP" <do********@comcast.nospam.net> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
Just to add onto what CJ said, you are now disconnected. You can define a
LOT of validation in your dataset, but you aren't hooked to the db so you won't necessarily know if your value is ok or not until you submit the
update (although most of the stuff, like types, autoincrement , allownull etc can be done client side).
"CJ Taylor" <[cege] at [tavayn] dit commmmm> wrote in message
news:e8**************@TK2MSFTNGP09.phx.gbl...
> Yeah, you want to look at DataAdapters and Datasets, which are all part
of
> the ADO.NET package.
>
> However they have completly different designers, because after all

the .NET
> environment is completly different, there is no separate

DataEnvironment > (which I did like but I like DA's more now).
>
> Also, remember ADO.NET is disconnected where as DE's were connected
> recordsets. (the connection was kept alive through the life of the
> recordset), ado.net does not.
>
> HTH,
> CJ
>
> "P. Prosper" <mo**************@moca-coop.com> wrote in message
> news:eQ**************@TK2MSFTNGP11.phx.gbl...
> > Hello,
> > Sorry for the cross-posting, I first posted this message to the vb.6
NG
> > (wrong group) <g>.
> >
> > Are there any add-in or tools out there (for VB.NET ) that would

allow one
> > to drag and drop database fields onto a form. (similar to the
> > DataEnvironment in vb.6) ?
> >
> > I am looking for one that could set the validation rules for each
TextBox
> > based on the definition of the fields in the tables
> >
> > I know there is the Data Form Wizard but that's not what I need.
> >
> > TIA
> >
> >
> >
>
>



Nov 20 '05 #6

P: n/a
Prosper,
In addition to the other comments:

I use a Component, as it has a visual designer!

Use 'Project - Add Component' to create a new Component in your project.

Drag & drop your connection, commands, and data adapters to the design
surface. Or directly from Server Explorer.

Use the properties window to modify properties of the above elements.

The only downside of using a Component over the Data Environment is you need
to manually add code for any methods you want your Component to support,
where as the Data Environment added code automatically for you. I normally
make the methods a little higher level then the Data Environments, so its
not a big deal for me... For example I may have single Fill & Update
methods, that call Fill & Update on each Data Adapter in the component. Or I
may add individual Fill & Update or GetReader methods. It really depends on
the requirements for the project...

If you double click on the Component later you are back in the same visual
designer. If you click 'View Code' on the Component you see the code...

Hope this helps
Jay
"P. Prosper" <mo**************@moca-coop.com> wrote in message
news:eQ**************@TK2MSFTNGP11.phx.gbl...
Hello,
Sorry for the cross-posting, I first posted this message to the vb.6 NG
(wrong group) <g>.

Are there any add-in or tools out there (for VB.NET ) that would allow one
to drag and drop database fields onto a form. (similar to the
DataEnvironment in vb.6) ?

I am looking for one that could set the validation rules for each TextBox
based on the definition of the fields in the tables

I know there is the Data Form Wizard but that's not what I need.

TIA

Nov 20 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.