HighTechTalks DotNet Forums  

WinForms & dataGrid. How to UPDATE/DELETE?

Dotnet Data Tools microsoft.public.dotnet.datatools


Discuss WinForms & dataGrid. How to UPDATE/DELETE? in the Dotnet Data Tools forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Ronald Kloverod
 
Posts: n/a

Default WinForms & dataGrid. How to UPDATE/DELETE? - 01-24-2005 , 06:39 AM






I've read the article "Data Binding with Windows Forms and ADO.NET" on the
Microsoft site. This is a walk-through article showing how to make an
application with data binding.

I've made the exercise, and everything wokrs fine regarding selection of
data. Updates and (row-)deletion is also working fine in the GUI, but no
data is being saved back to the database. I've search around, mostly looking
for events like for example UpdateRow and DeleteRow, but can't find anything
(the idea was to call the qqlDataAdapter.DeleteCommand /...UpdateCommand
here)

Anybody out there that can help me with the Update/delete operations? (Yes,
the datasets have been genereated with UPDATE/DELETE otions, in addition to
Select).

Note - this is the WindowsForms version of DataGrid, not the Web-based one.

Thanks,
Ronald.



Reply With Quote
  #2  
Old   
Relaxin
 
Posts: n/a

Default Re: WinForms & dataGrid. How to UPDATE/DELETE? - 01-28-2005 , 01:28 AM






You need to use the qqlDataAdapter.Update( <dataset> (optional)<tablename>)

This will use the INSERT, DELETE and/or UPDATE Commands as needed for each
"changed" record within the dataset.

Hope this helps.

"Ronald Kloverod" <ronald.kloverod (AT) xexcom (DOT) no> wrote

Quote:
I've read the article "Data Binding with Windows Forms and ADO.NET" on the
Microsoft site. This is a walk-through article showing how to make an
application with data binding.

I've made the exercise, and everything wokrs fine regarding selection of
data. Updates and (row-)deletion is also working fine in the GUI, but no
data is being saved back to the database. I've search around, mostly
looking
for events like for example UpdateRow and DeleteRow, but can't find
anything
(the idea was to call the qqlDataAdapter.DeleteCommand /...UpdateCommand
here)

Anybody out there that can help me with the Update/delete operations?
(Yes,
the datasets have been genereated with UPDATE/DELETE otions, in addition
to
Select).

Note - this is the WindowsForms version of DataGrid, not the Web-based
one.

Thanks,
Ronald.





Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.