2.0 : config GridView to use SPs ?

[John A Grandy]

It looks like MS wants you to use config a SQLDataSource , hand coding the
SELECT, INSERT, UPDATE, DELETE SQL , and then assigning
GridView.DataSourceID = SQLDataSource ...

But what if you prefer to encapsulate all your DML in SPs ? Is it possible
to config the SQLDataSource with SPs ? If not, is there an alternative to
MS's preferred method for config'ing a GridView ?

[Jeff Lynch]

I usually write a BLL which calls the sprocs from public methods and then
use the ObjectDataSource pointing to the BLL.

--
Jeff Lynch
"Ramblings From A [Microsoft] Connected Universe"
http://codebetter.com/blogs/jeff.lynch
"John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:O4**************@TK2MSFTNGP10.phx.gbl...

It looks like MS wants you to use config a SQLDataSource , hand coding the
SELECT, INSERT, UPDATE, DELETE SQL , and then assigning
GridView.DataSourceID = SQLDataSource ...

But what if you prefer to encapsulate all your DML in SPs ? Is it
possible to config the SQLDataSource with SPs ? If not, is there an
alternative to MS's preferred method for config'ing a GridView ?

[John A Grandy]

Hi Jeff.

I'm too sleepy .... what's a BLL ?

Thanks.
"Jeff Lynch" <je********@newsgroup.nospam> wrote in message
news:On*************@tk2msftngp13.phx.gbl...

I usually write a BLL which calls the sprocs from public methods and then
use the ObjectDataSource pointing to the BLL.

--
Jeff Lynch
"Ramblings From A [Microsoft] Connected Universe"
http://codebetter.com/blogs/jeff.lynch
"John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:O4**************@TK2MSFTNGP10.phx.gbl...

It looks like MS wants you to use config a SQLDataSource , hand coding
the SELECT, INSERT, UPDATE, DELETE SQL , and then assigning
GridView.DataSourceID = SQLDataSource ...

But what if you prefer to encapsulate all your DML in SPs ? Is it
possible to config the SQLDataSource with SPs ? If not, is there an
alternative to MS's preferred method for config'ing a GridView ?

[sloan]

The BLL is the "BusinessLogicLayer".

You need to use:
ObjectDataSource

and then create something like a custom collection

MyEmpCollection : CollectionBase

Where.. you will put Emp objects inside of your MyEmpCollection

...
If you don't know how to create CollectionBase ('s), then check
http://spaces.msn.com/sholliday/ 9/21/2005 entry

You can ingore the XmlSerializer stuff, and just get the CollectionBase
stuff.


"John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:O4**************@TK2MSFTNGP10.phx.gbl...

It looks like MS wants you to use config a SQLDataSource , hand coding the
SELECT, INSERT, UPDATE, DELETE SQL , and then assigning
GridView.DataSourceID = SQLDataSource ...

But what if you prefer to encapsulate all your DML in SPs ? Is it possible to config the SQLDataSource with SPs ? If not, is there an alternative to
MS's preferred method for config'ing a GridView ?

[John A Grandy]

Normally I'd do that ... because I'm a OO , multi-tier guy ...

..... but I'm just trying to test out this DataView control to see if it's
worth using. The provided wizards should work against simple table with
simple select,insert,update,delete sps .... shouldn't they ?

Or is this another "botched wizard" from MS ?

"sloan" <sl***@ipass.net> wrote in message
news:eK**************@TK2MSFTNGP11.phx.gbl...

The BLL is the "BusinessLogicLayer".

You need to use:
ObjectDataSource

and then create something like a custom collection

MyEmpCollection : CollectionBase

Where.. you will put Emp objects inside of your MyEmpCollection

..
If you don't know how to create CollectionBase ('s), then check
http://spaces.msn.com/sholliday/ 9/21/2005 entry

You can ingore the XmlSerializer stuff, and just get the CollectionBase
stuff.


"John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:O4**************@TK2MSFTNGP10.phx.gbl...

It looks like MS wants you to use config a SQLDataSource , hand coding
the
SELECT, INSERT, UPDATE, DELETE SQL , and then assigning
GridView.DataSourceID = SQLDataSource ...

But what if you prefer to encapsulate all your DML in SPs ? Is it

possible

to config the SQLDataSource with SPs ? If not, is there an alternative
to
MS's preferred method for config'ing a GridView ?

[Angelo Cook]

Its another botched component, I have been able to do just about everything
(edit, update and delete) but can not get the insert figured out.

I would like to use the footer to hold the input row, that part is easy, and
use an image button/link to implement the insert. well unless I create a an
onclick postback routine on the insert image, it does not work. When i am
able to get it to work the resulting refresh of data does not reflect the
newlly added row or the deleted row in the event of a delete.

"John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:u2**************@TK2MSFTNGP10.phx.gbl...

Normally I'd do that ... because I'm a OO , multi-tier guy ...

.... but I'm just trying to test out this DataView control to see if it's
worth using. The provided wizards should work against simple table with
simple select,insert,update,delete sps .... shouldn't they ?

Or is this another "botched wizard" from MS ?

"sloan" <sl***@ipass.net> wrote in message
news:eK**************@TK2MSFTNGP11.phx.gbl...

The BLL is the "BusinessLogicLayer".

You need to use:
ObjectDataSource

and then create something like a custom collection

MyEmpCollection : CollectionBase

Where.. you will put Emp objects inside of your MyEmpCollection

..
If you don't know how to create CollectionBase ('s), then check
http://spaces.msn.com/sholliday/ 9/21/2005 entry

You can ingore the XmlSerializer stuff, and just get the CollectionBase
stuff.


"John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:O4**************@TK2MSFTNGP10.phx.gbl...

It looks like MS wants you to use config a SQLDataSource , hand coding
the
SELECT, INSERT, UPDATE, DELETE SQL , and then assigning
GridView.DataSourceID = SQLDataSource ...

But what if you prefer to encapsulate all your DML in SPs ? Is it

possible

to config the SQLDataSource with SPs ? If not, is there an alternative
to
MS's preferred method for config'ing a GridView ?