Batch updates with GridView

[McGeeky]

Hi. GridView's inbuilt capability to edit/update individual rows, one at a
time, is useful but inadequate for a scenario we currently face. I want the
user to be able to change values in multiple rows of the GridView and then
hit an "OK" button which then applies all the changes together as a single
unit. I also need the GridView to support paging; such that a user makes a
change in one page, navigates to another, nagivates back again and finds
that their original edit is still preserved, yet, not commited to the
database. Only when they hit "OK" will their changes on each of the GridView
pages be committed.

Are there any examples available that demonstrate this capability? I have
made a good start but would like to base my work on something already
proven. Challenges I currently face are; where to store the edits that the
user has made (in view state/code behind/session state), in what form to
store those edits (in a table class, an array etc.). I have figured out I
need to use a template column to show edit boxes on GridView. But another
challenge is then referencing the values in those edit boxes in the code
behind. Also, where to store the IDs of the rows, in hidden text boxes?

Any help/pointers much appreciated!!!!

--
McGeeky
http://mcgeeky.blogspot.com

[bruce barker]

load a dataset with the data and store in session. then bind/page the
gridview to the dataset. when the user hit ok, use an adapter to update
the database from the dataset. lots of examples of using disconnected
datasets.

-- bruce (sqlwork.com)

McGeeky wrote:

Hi. GridView's inbuilt capability to edit/update individual rows, one at a
time, is useful but inadequate for a scenario we currently face. I want the
user to be able to change values in multiple rows of the GridView and then
hit an "OK" button which then applies all the changes together as a single
unit. I also need the GridView to support paging; such that a user makes a
change in one page, navigates to another, nagivates back again and finds
that their original edit is still preserved, yet, not commited to the
database. Only when they hit "OK" will their changes on each of the GridView
pages be committed.

Are there any examples available that demonstrate this capability? I have
made a good start but would like to base my work on something already
proven. Challenges I currently face are; where to store the edits that the
user has made (in view state/code behind/session state), in what form to
store those edits (in a table class, an array etc.). I have figured out I
need to use a template column to show edit boxes on GridView. But another
challenge is then referencing the values in those edit boxes in the code
behind. Also, where to store the IDs of the rows, in hidden text boxes?

Any help/pointers much appreciated!!!!

--
McGeeky
http://mcgeeky.blogspot.com

[McGeeky]

Thanks so much for that.

--
McGeeky
http://mcgeeky.blogspot.com
"bruce barker" <no****@nospam.comwrote in message
news:Ow**************@TK2MSFTNGP04.phx.gbl...

load a dataset with the data and store in session. then bind/page the
gridview to the dataset. when the user hit ok, use an adapter to update
the database from the dataset. lots of examples of using disconnected
datasets.

-- bruce (sqlwork.com)

McGeeky wrote:

Hi. GridView's inbuilt capability to edit/update individual rows, one at

a

time, is useful but inadequate for a scenario we currently face. I want

the

user to be able to change values in multiple rows of the GridView and

then

hit an "OK" button which then applies all the changes together as a

single

unit. I also need the GridView to support paging; such that a user makes

a

change in one page, navigates to another, nagivates back again and finds
that their original edit is still preserved, yet, not commited to the
database. Only when they hit "OK" will their changes on each of the

GridView

pages be committed.

Are there any examples available that demonstrate this capability? I

have

made a good start but would like to base my work on something already
proven. Challenges I currently face are; where to store the edits that

the

user has made (in view state/code behind/session state), in what form to
store those edits (in a table class, an array etc.). I have figured out

I

need to use a template column to show edit boxes on GridView. But

another

challenge is then referencing the values in those edit boxes in the code
behind. Also, where to store the IDs of the rows, in hidden text boxes?

Any help/pointers much appreciated!!!!

--
McGeeky
http://mcgeeky.blogspot.com

[AG]

Check out this project. It contains a bulk edit gridview.
http://www.codeplex.com/ASPNetRealWorldContr
--

AG
Email: discuss at adhdata dot com

"McGeeky" <an**@anon.comwrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...

Hi. GridView's inbuilt capability to edit/update individual rows, one at a
time, is useful but inadequate for a scenario we currently face. I want
the
user to be able to change values in multiple rows of the GridView and then
hit an "OK" button which then applies all the changes together as a single
unit. I also need the GridView to support paging; such that a user makes a
change in one page, navigates to another, nagivates back again and finds
that their original edit is still preserved, yet, not commited to the
database. Only when they hit "OK" will their changes on each of the
GridView
pages be committed.

Are there any examples available that demonstrate this capability? I have
made a good start but would like to base my work on something already
proven. Challenges I currently face are; where to store the edits that the
user has made (in view state/code behind/session state), in what form to
store those edits (in a table class, an array etc.). I have figured out I
need to use a template column to show edit boxes on GridView. But another
challenge is then referencing the values in those edit boxes in the code
behind. Also, where to store the IDs of the rows, in hidden text boxes?

Any help/pointers much appreciated!!!!

--
McGeeky
http://mcgeeky.blogspot.com

[McGeeky]

Thanks!

--
McGeeky
http://mcgeeky.blogspot.com
"AG" <NO**********@newsgroups.nospamwrote in message
news:#z**************@TK2MSFTNGP02.phx.gbl...

Check out this project. It contains a bulk edit gridview.
http://www.codeplex.com/ASPNetRealWorldContr
--

AG
Email: discuss at adhdata dot com

"McGeeky" <an**@anon.comwrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...

Hi. GridView's inbuilt capability to edit/update individual rows, one at

a

time, is useful but inadequate for a scenario we currently face. I want
the
user to be able to change values in multiple rows of the GridView and

then

hit an "OK" button which then applies all the changes together as a

single

unit. I also need the GridView to support paging; such that a user makes

a

change in one page, navigates to another, nagivates back again and finds
that their original edit is still preserved, yet, not commited to the
database. Only when they hit "OK" will their changes on each of the
GridView
pages be committed.

Are there any examples available that demonstrate this capability? I

have

made a good start but would like to base my work on something already
proven. Challenges I currently face are; where to store the edits that

the

user has made (in view state/code behind/session state), in what form to
store those edits (in a table class, an array etc.). I have figured out

I

need to use a template column to show edit boxes on GridView. But

another

challenge is then referencing the values in those edit boxes in the code
behind. Also, where to store the IDs of the rows, in hidden text boxes?

Any help/pointers much appreciated!!!!

--
McGeeky
http://mcgeeky.blogspot.com

[McGeeky]

Strange... there is no way to download the source code for it.

--
McGeeky
http://mcgeeky.blogspot.com
"McGeeky" <an**@anon.comwrote in message
news:ea**************@TK2MSFTNGP03.phx.gbl...

Thanks!

--
McGeeky
http://mcgeeky.blogspot.com
"AG" <NO**********@newsgroups.nospamwrote in message
news:#z**************@TK2MSFTNGP02.phx.gbl...

Check out this project. It contains a bulk edit gridview.
http://www.codeplex.com/ASPNetRealWorldContr
--

AG
Email: discuss at adhdata dot com

"McGeeky" <an**@anon.comwrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...

Hi. GridView's inbuilt capability to edit/update individual rows, one

at

a

time, is useful but inadequate for a scenario we currently face. I

want

the
user to be able to change values in multiple rows of the GridView and

then

hit an "OK" button which then applies all the changes together as a

single

unit. I also need the GridView to support paging; such that a user

makes

a

change in one page, navigates to another, nagivates back again and

finds

that their original edit is still preserved, yet, not commited to the
database. Only when they hit "OK" will their changes on each of the
GridView
pages be committed.
>
Are there any examples available that demonstrate this capability? I

have

made a good start but would like to base my work on something already
proven. Challenges I currently face are; where to store the edits that

the

user has made (in view state/code behind/session state), in what form

to

store those edits (in a table class, an array etc.). I have figured

out

I

need to use a template column to show edit boxes on GridView. But

another

challenge is then referencing the values in those edit boxes in the

code

behind. Also, where to store the IDs of the rows, in hidden text

boxes?

>
Any help/pointers much appreciated!!!!
>
--
McGeeky
http://mcgeeky.blogspot.com
>
>
>

[AG]

I know and have posted that fact several times there, but no one replies.
However, you can download the dll from the Releases tab and it works.
I think I had a problem with the naming of the dll vs the reference, but
once I fixed that, it worked fine.

Here is the link to where I originally found out about it.
http://blogs.msdn.com/mattdotson/articles/490868.aspx

--

AG
Email: discuss at adhdata dot com

"McGeeky" <an**@anon.comwrote in message
news:eQ**************@TK2MSFTNGP06.phx.gbl...

Strange... there is no way to download the source code for it.

--
McGeeky
http://mcgeeky.blogspot.com
"McGeeky" <an**@anon.comwrote in message
news:ea**************@TK2MSFTNGP03.phx.gbl...

>Thanks!

--
McGeeky
http://mcgeeky.blogspot.com
"AG" <NO**********@newsgroups.nospamwrote in message
news:#z**************@TK2MSFTNGP02.phx.gbl...

Check out this project. It contains a bulk edit gridview.
http://www.codeplex.com/ASPNetRealWorldContr
--

AG
Email: discuss at adhdata dot com

"McGeeky" <an**@anon.comwrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...
Hi. GridView's inbuilt capability to edit/update individual rows, one

at

>a

time, is useful but inadequate for a scenario we currently face. I

want

the
user to be able to change values in multiple rows of the GridView and

then

hit an "OK" button which then applies all the changes together as a

single

unit. I also need the GridView to support paging; such that a user

makes

>a

change in one page, navigates to another, nagivates back again and

finds

that their original edit is still preserved, yet, not commited to the
database. Only when they hit "OK" will their changes on each of the
GridView
pages be committed.

Are there any examples available that demonstrate this capability? I

have

made a good start but would like to base my work on something already
proven. Challenges I currently face are; where to store the edits
that

the

user has made (in view state/code behind/session state), in what form

to

store those edits (in a table class, an array etc.). I have figured

out

>I

need to use a template column to show edit boxes on GridView. But

another

challenge is then referencing the values in those edit boxes in the

code

behind. Also, where to store the IDs of the rows, in hidden text

boxes?

>
Any help/pointers much appreciated!!!!

--
McGeeky
http://mcgeeky.blogspot.com