Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Batch updates with GridView

Reply
Thread Tools

Batch updates with GridView

 
 
McGeeky
Guest
Posts: n/a
 
      05-09-2007
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



 
Reply With Quote
 
 
 
 
bruce barker
Guest
Posts: n/a
 
      05-09-2007
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
>
>
>

 
Reply With Quote
 
 
 
 
McGeeky
Guest
Posts: n/a
 
      05-10-2007
Thanks so much for that.

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


"bruce barker" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
> >
> >
> >



 
Reply With Quote
 
AG
Guest
Posts: n/a
 
      05-10-2007
Check out this project. It contains a bulk edit gridview.
http://www.codeplex.com/ASPNetRealWorldContr


--

AG
Email: discuss at adhdata dot com



"McGeeky" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
>
>
>



 
Reply With Quote
 
McGeeky
Guest
Posts: n/a
 
      05-11-2007
Thanks!

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


"AG" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> Check out this project. It contains a bulk edit gridview.
> http://www.codeplex.com/ASPNetRealWorldContr
>
>
> --
>
> AG
> Email: discuss at adhdata dot com
>
>
>
> "McGeeky" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > 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
> >
> >
> >

>
>



 
Reply With Quote
 
McGeeky
Guest
Posts: n/a
 
      05-11-2007
Strange... there is no way to download the source code for it.

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


"McGeeky" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks!
>
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
>
> "AG" <(E-Mail Removed)> wrote in message
> news:#(E-Mail Removed)...
> > Check out this project. It contains a bulk edit gridview.
> > http://www.codeplex.com/ASPNetRealWorldContr
> >
> >
> > --
> >
> > AG
> > Email: discuss at adhdata dot com
> >
> >
> >
> > "McGeeky" <(E-Mail Removed)> wrote in message
> > news:%(E-Mail Removed)...
> > > 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
> > >
> > >
> > >

> >
> >

>
>



 
Reply With Quote
 
AG
Guest
Posts: n/a
 
      05-11-2007
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" <(E-Mail Removed)> wrote in message
news:eQiS$(E-Mail Removed)...
> Strange... there is no way to download the source code for it.
>
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
>
> "McGeeky" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Thanks!
>>
>> --
>> McGeeky
>> http://mcgeeky.blogspot.com
>>
>>
>> "AG" <(E-Mail Removed)> wrote in message
>> news:#(E-Mail Removed)...
>> > Check out this project. It contains a bulk edit gridview.
>> > http://www.codeplex.com/ASPNetRealWorldContr
>> >
>> >
>> > --
>> >
>> > AG
>> > Email: discuss at adhdata dot com
>> >
>> >
>> >
>> > "McGeeky" <(E-Mail Removed)> wrote in message
>> > news:%(E-Mail Removed)...
>> > > 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
>> > >
>> > >
>> > >
>> >
>> >

>>
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Batch Updates from a Grid rbrowning1958 ASP .Net 2 04-13-2008 08:56 AM
User Interface and Batch Inserts/Updates Dimitris Milonas ASP .Net 0 11-25-2007 10:41 PM
Batch/Block-Mode updates to Select Lists - How to avoid? scripts.contact@gmail.com Javascript 16 03-25-2007 03:55 AM
Batch Update in GridView control, is it possible? LearnMore.John@gmail.com ASP .Net 2 06-23-2006 01:50 PM
GridView Hierarchical View - Gridview in Gridview =?Utf-8?B?bWdvbnphbGVzMw==?= ASP .Net 1 05-09-2006 06:48 PM



Advertisments