In my app, I get all the info/data that I want from an Access data base. In
one place I've the information displayed on a ListView.

I let a user click on any line and then an 'edit' button. This picks the info
from the line and displays the data in a DataGrid for editing. The
information displayed is 1 to 7 lines.

What I want to do is to change some text in a column ("description") that is
the same to all the info displayed in the DataGrid. I plan to have a TextBox
where the user makes the change and then clicks an update button. Later they
have to click another button (accept changes) to re-write the updated
information back to the Access data base).

My initial thought to do the update was to reload the data and instead of
using the data base "description" information, to substitute it with the
revised wording.

But maybe there is an easier way to simply just replace all the info in one
column with the updated text? If so, I'd appreciate some direction here.

LASTLY, in a ListView, how can you get a 'double' click to function? I would
like to allow a user to double click a line to bring up my edit shell (right
now it's a line click to highlight, then an edit button). I've tried:

Private Sub lvProjDisplay_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles lvProjDisplay.Click
... code here...
End Sub

... but this doesn't work. Anyone?

Thanks in advance!

Bruce

RE: Global Change to DataGrid by mohamed

mohamed
Sat Feb 21 06:31:14 CST 2004

hi
just save the new discription in the dataset. they use the update method
of a data adapter and pass to it as pram the dataset and a connection to
the access database .


Re: Global Change to DataGrid by Mr

Mr
Sat Feb 21 10:29:09 CST 2004

With Deft Fingers, mohamed.mossad@egdsc.microsoft.com (Mohamoss) wrote:

> just save the new discription in the dataset. they use the update method
>of a data adapter and pass to it as pram the dataset and a connection to
>the access database .

Ah yes. Sorry... but I probably didn't explain it correctly. I do know how
to update the data base... what I was wanting to do, was to 'first' update the
visual display on the DataGrid. The user has the additional option to Cancel
all Changes or Accept all Changes.

Regards,

Bruce