Save DataGridView changes to database through multiple layers
-
Hi, I have worked through the MSDN example of Creating an N-Tier Data Application. However, I'm struggling to get started with my 'save changes' functionality for a
DataGridView
. Can anyone offer any advice? My solution consists of SQL Server 2008 (I'm using the NorthWind sample database to go along with the walkthrough linked above), a Data Access Tier, Data Entity Tier, DataService and Presentation Layer and currently my app displays theDataSet
in twoDataGridView
s. I understand the order of method invocations that is required to achieve what I want, but I'm struggling to get started with the coding of it. I.e capturing the changes made in theDataGridView
, saving them to theDataSet
and then committing theDataSet
to the database via the DataService and Data Access Tier. Apologies for the long post and if I have missed out any info that would help you answer my question. Anthony -
Hi, I have worked through the MSDN example of Creating an N-Tier Data Application. However, I'm struggling to get started with my 'save changes' functionality for a
DataGridView
. Can anyone offer any advice? My solution consists of SQL Server 2008 (I'm using the NorthWind sample database to go along with the walkthrough linked above), a Data Access Tier, Data Entity Tier, DataService and Presentation Layer and currently my app displays theDataSet
in twoDataGridView
s. I understand the order of method invocations that is required to achieve what I want, but I'm struggling to get started with the coding of it. I.e capturing the changes made in theDataGridView
, saving them to theDataSet
and then committing theDataSet
to the database via the DataService and Data Access Tier. Apologies for the long post and if I have missed out any info that would help you answer my question. AnthonyFYI: your hyperlink is incorrect, it refers to your own message. :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.
-
FYI: your hyperlink is incorrect, it refers to your own message. :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.
Ah so it did, as I've corrected it. Thanks for pointing that out.