Understanding the LoadOption Enumeration
Selected LoadOption value:
PreserveChanges
Upsert
OverwriteChanges
DataAdapter.FillLoadOption = LoadOption.PreserveChanges
Row 0
Current Values
Original Values
RowState Property
When First Filled:
ISLAT
Island Trading
Cowes
ISLAT
Island Trading
Cowes
Unchanged
Unchanged
Unchanged
After Editing Rows:
ISLAT
New Name
Cowes
ISLAT
Island Trading
Cowes
Modified
Modified
Modified
After Refreshing Rows:
ISLAT
New Name
Cowes
ISLAT
Island Trading
Cowes
Modified
Modified
Modified
Row 1
Current Values
Original Values
RowState Property
When First Filled:
LETSS
Let's Stop N Shop
San Francisco
LETSS
Let's Stop N Shop
San Francisco
Unchanged
Unchanged
Unchanged
After Editing Rows:
-NULL-
-NULL-
-NULL-
LETSS
Let's Stop N Shop
San Francisco
Deleted
Deleted
Deleted
After Refreshing Rows:
-NULL-
-NULL-
-NULL-
LETSS
Let's Stop N Shop
San Francisco
Deleted
Deleted
Deleted
Row 2
Current Values
Original Values
RowState Property
When First Filled:
[n/a]
[n/a]
[n/a]
[n/a]
[n/a]
[n/a]
[n/a]
[n/a]
[n/a]
After Editing Rows:
ADDED
New Customer
Alfreton
-NULL-
-NULL-
-NULL-
Added
Added
Added
After Refreshing Rows:
ADDED
New Customer
Alfreton
-NULL-
-NULL-
-NULL-
Added
Added
Added
[
view source
]
©2005
Dave And Al.net