Getting started with DataAdapters, DataSets, DagaGrids
sqlDataAdapter is a conduit between SQL server and a DataSet. A DataGrid binds to a DataSet; doesn’t know a thing about sqlDataAdapter.
The capability of TEXT type sqlCommands has certain limitations. Can’t assign @@IDENTITY to a parameter.
Set the DefaultValue property of a DataSet’s columns to avoid “doesn’t allow null” errors. Use System.Guid.Empty for rowguids.
When a DataGrid is used to modify the data sorting it alters the underlying DataSet; which in turn modifies any other DataGrid that may share the DataSet.
Events are dispatched to all registered handlers. There is no need or capability to indicate whether the handler “consumes” the event.