Code:
/ Net / Net / 3.5.50727.3053 / DEVDIV / depot / DevDiv / releases / whidbey / netfxsp / ndp / fx / src / Data / System / Data / Odbc / OdbcDataAdapter.cs / 1 / OdbcDataAdapter.cs
//------------------------------------------------------------------------------ //// Copyright (c) Microsoft Corporation. All rights reserved. // //[....] //[....] //----------------------------------------------------------------------------- using System; using System.ComponentModel; using System.Data; using System.Data.Common; using System.Threading; namespace System.Data.Odbc { [ DefaultEvent("RowUpdated"), ToolboxItem("Microsoft.VSDesigner.Data.VS.OdbcDataAdapterToolboxItem, " + AssemblyRef.MicrosoftVSDesigner), // WebData 97832 Designer("Microsoft.VSDesigner.Data.VS.OdbcDataAdapterDesigner, " + AssemblyRef.MicrosoftVSDesigner) ] #if WINFSInternalOnly internal #else public #endif sealed class OdbcDataAdapter : DbDataAdapter, IDbDataAdapter, ICloneable { static private readonly object EventRowUpdated = new object(); static private readonly object EventRowUpdating = new object(); private OdbcCommand _deleteCommand, _insertCommand, _selectCommand, _updateCommand; public OdbcDataAdapter() : base() { GC.SuppressFinalize(this); } public OdbcDataAdapter(OdbcCommand selectCommand) : this() { SelectCommand = selectCommand; } public OdbcDataAdapter(string selectCommandText, OdbcConnection selectConnection) : this() { SelectCommand = new OdbcCommand(selectCommandText, selectConnection); } public OdbcDataAdapter(string selectCommandText, string selectConnectionString) : this() { OdbcConnection connection = new OdbcConnection(selectConnectionString); SelectCommand = new OdbcCommand(selectCommandText, connection); } private OdbcDataAdapter(OdbcDataAdapter from) : base(from) { GC.SuppressFinalize(this); } [ DefaultValue(null), ResCategoryAttribute(Res.DataCategory_Update), ResDescriptionAttribute(Res.DbDataAdapter_DeleteCommand), Editor("Microsoft.VSDesigner.Data.Design.DBCommandEditor, " + AssemblyRef.MicrosoftVSDesigner, "System.Drawing.Design.UITypeEditor, " + AssemblyRef.SystemDrawing), ] new public OdbcCommand DeleteCommand { get { return _deleteCommand; } set { _deleteCommand = value; } } IDbCommand IDbDataAdapter.DeleteCommand { get { return _deleteCommand; } set { _deleteCommand = (OdbcCommand)value; } } [ DefaultValue(null), ResCategoryAttribute(Res.DataCategory_Update), ResDescriptionAttribute(Res.DbDataAdapter_InsertCommand), Editor("Microsoft.VSDesigner.Data.Design.DBCommandEditor, " + AssemblyRef.MicrosoftVSDesigner, "System.Drawing.Design.UITypeEditor, " + AssemblyRef.SystemDrawing), ] new public OdbcCommand InsertCommand { get { return _insertCommand; } set { _insertCommand = value; } } IDbCommand IDbDataAdapter.InsertCommand { get { return _insertCommand; } set { _insertCommand = (OdbcCommand)value; } } [ DefaultValue(null), ResCategoryAttribute(Res.DataCategory_Fill), ResDescriptionAttribute(Res.DbDataAdapter_SelectCommand), Editor("Microsoft.VSDesigner.Data.Design.DBCommandEditor, " + AssemblyRef.MicrosoftVSDesigner, "System.Drawing.Design.UITypeEditor, " + AssemblyRef.SystemDrawing), ] new public OdbcCommand SelectCommand { get { return _selectCommand; } set { _selectCommand = value; } } IDbCommand IDbDataAdapter.SelectCommand { get { return _selectCommand; } set { _selectCommand = (OdbcCommand)value; } } [ DefaultValue(null), ResCategoryAttribute(Res.DataCategory_Update), ResDescriptionAttribute(Res.DbDataAdapter_UpdateCommand), Editor("Microsoft.VSDesigner.Data.Design.DBCommandEditor, " + AssemblyRef.MicrosoftVSDesigner, "System.Drawing.Design.UITypeEditor, " + AssemblyRef.SystemDrawing), ] new public OdbcCommand UpdateCommand { get { return _updateCommand; } set { _updateCommand = value; } } IDbCommand IDbDataAdapter.UpdateCommand { get { return _updateCommand; } set { _updateCommand = (OdbcCommand)value; } } [ ResCategoryAttribute(Res.DataCategory_Update), ResDescriptionAttribute(Res.DbDataAdapter_RowUpdated), ] public event OdbcRowUpdatedEventHandler RowUpdated { add { Events.AddHandler(EventRowUpdated, value); } remove { Events.RemoveHandler(EventRowUpdated, value); } } [ ResCategoryAttribute(Res.DataCategory_Update), ResDescriptionAttribute(Res.DbDataAdapter_RowUpdating), ] public event OdbcRowUpdatingEventHandler RowUpdating { add { OdbcRowUpdatingEventHandler handler = (OdbcRowUpdatingEventHandler) Events[EventRowUpdating]; // MDAC 58177, 64513 // prevent someone from registering two different command builders on the adapter by // silently removing the old one if ((null != handler) && (value.Target is OdbcCommandBuilder)) { OdbcRowUpdatingEventHandler d = (OdbcRowUpdatingEventHandler) ADP.FindBuilder(handler); if (null != d) { Events.RemoveHandler(EventRowUpdating, d); } } Events.AddHandler(EventRowUpdating, value); } remove { Events.RemoveHandler(EventRowUpdating, value); } } object ICloneable.Clone() { return new OdbcDataAdapter(this); } override protected RowUpdatedEventArgs CreateRowUpdatedEvent(DataRow dataRow, IDbCommand command, StatementType statementType, DataTableMapping tableMapping) { return new OdbcRowUpdatedEventArgs(dataRow, command, statementType, tableMapping); } override protected RowUpdatingEventArgs CreateRowUpdatingEvent(DataRow dataRow, IDbCommand command, StatementType statementType, DataTableMapping tableMapping) { return new OdbcRowUpdatingEventArgs(dataRow, command, statementType, tableMapping); } override protected void OnRowUpdated(RowUpdatedEventArgs value) { OdbcRowUpdatedEventHandler handler = (OdbcRowUpdatedEventHandler) Events[EventRowUpdated]; if ((null != handler) && (value is OdbcRowUpdatedEventArgs)) { handler(this, (OdbcRowUpdatedEventArgs) value); } base.OnRowUpdated(value); } override protected void OnRowUpdating(RowUpdatingEventArgs value) { OdbcRowUpdatingEventHandler handler = (OdbcRowUpdatingEventHandler) Events[EventRowUpdating]; if ((null != handler) && (value is OdbcRowUpdatingEventArgs)) { handler(this, (OdbcRowUpdatingEventArgs) value); } base.OnRowUpdating(value); } } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007. //------------------------------------------------------------------------------ //// Copyright (c) Microsoft Corporation. All rights reserved. // //[....] //[....] //----------------------------------------------------------------------------- using System; using System.ComponentModel; using System.Data; using System.Data.Common; using System.Threading; namespace System.Data.Odbc { [ DefaultEvent("RowUpdated"), ToolboxItem("Microsoft.VSDesigner.Data.VS.OdbcDataAdapterToolboxItem, " + AssemblyRef.MicrosoftVSDesigner), // WebData 97832 Designer("Microsoft.VSDesigner.Data.VS.OdbcDataAdapterDesigner, " + AssemblyRef.MicrosoftVSDesigner) ] #if WINFSInternalOnly internal #else public #endif sealed class OdbcDataAdapter : DbDataAdapter, IDbDataAdapter, ICloneable { static private readonly object EventRowUpdated = new object(); static private readonly object EventRowUpdating = new object(); private OdbcCommand _deleteCommand, _insertCommand, _selectCommand, _updateCommand; public OdbcDataAdapter() : base() { GC.SuppressFinalize(this); } public OdbcDataAdapter(OdbcCommand selectCommand) : this() { SelectCommand = selectCommand; } public OdbcDataAdapter(string selectCommandText, OdbcConnection selectConnection) : this() { SelectCommand = new OdbcCommand(selectCommandText, selectConnection); } public OdbcDataAdapter(string selectCommandText, string selectConnectionString) : this() { OdbcConnection connection = new OdbcConnection(selectConnectionString); SelectCommand = new OdbcCommand(selectCommandText, connection); } private OdbcDataAdapter(OdbcDataAdapter from) : base(from) { GC.SuppressFinalize(this); } [ DefaultValue(null), ResCategoryAttribute(Res.DataCategory_Update), ResDescriptionAttribute(Res.DbDataAdapter_DeleteCommand), Editor("Microsoft.VSDesigner.Data.Design.DBCommandEditor, " + AssemblyRef.MicrosoftVSDesigner, "System.Drawing.Design.UITypeEditor, " + AssemblyRef.SystemDrawing), ] new public OdbcCommand DeleteCommand { get { return _deleteCommand; } set { _deleteCommand = value; } } IDbCommand IDbDataAdapter.DeleteCommand { get { return _deleteCommand; } set { _deleteCommand = (OdbcCommand)value; } } [ DefaultValue(null), ResCategoryAttribute(Res.DataCategory_Update), ResDescriptionAttribute(Res.DbDataAdapter_InsertCommand), Editor("Microsoft.VSDesigner.Data.Design.DBCommandEditor, " + AssemblyRef.MicrosoftVSDesigner, "System.Drawing.Design.UITypeEditor, " + AssemblyRef.SystemDrawing), ] new public OdbcCommand InsertCommand { get { return _insertCommand; } set { _insertCommand = value; } } IDbCommand IDbDataAdapter.InsertCommand { get { return _insertCommand; } set { _insertCommand = (OdbcCommand)value; } } [ DefaultValue(null), ResCategoryAttribute(Res.DataCategory_Fill), ResDescriptionAttribute(Res.DbDataAdapter_SelectCommand), Editor("Microsoft.VSDesigner.Data.Design.DBCommandEditor, " + AssemblyRef.MicrosoftVSDesigner, "System.Drawing.Design.UITypeEditor, " + AssemblyRef.SystemDrawing), ] new public OdbcCommand SelectCommand { get { return _selectCommand; } set { _selectCommand = value; } } IDbCommand IDbDataAdapter.SelectCommand { get { return _selectCommand; } set { _selectCommand = (OdbcCommand)value; } } [ DefaultValue(null), ResCategoryAttribute(Res.DataCategory_Update), ResDescriptionAttribute(Res.DbDataAdapter_UpdateCommand), Editor("Microsoft.VSDesigner.Data.Design.DBCommandEditor, " + AssemblyRef.MicrosoftVSDesigner, "System.Drawing.Design.UITypeEditor, " + AssemblyRef.SystemDrawing), ] new public OdbcCommand UpdateCommand { get { return _updateCommand; } set { _updateCommand = value; } } IDbCommand IDbDataAdapter.UpdateCommand { get { return _updateCommand; } set { _updateCommand = (OdbcCommand)value; } } [ ResCategoryAttribute(Res.DataCategory_Update), ResDescriptionAttribute(Res.DbDataAdapter_RowUpdated), ] public event OdbcRowUpdatedEventHandler RowUpdated { add { Events.AddHandler(EventRowUpdated, value); } remove { Events.RemoveHandler(EventRowUpdated, value); } } [ ResCategoryAttribute(Res.DataCategory_Update), ResDescriptionAttribute(Res.DbDataAdapter_RowUpdating), ] public event OdbcRowUpdatingEventHandler RowUpdating { add { OdbcRowUpdatingEventHandler handler = (OdbcRowUpdatingEventHandler) Events[EventRowUpdating]; // MDAC 58177, 64513 // prevent someone from registering two different command builders on the adapter by // silently removing the old one if ((null != handler) && (value.Target is OdbcCommandBuilder)) { OdbcRowUpdatingEventHandler d = (OdbcRowUpdatingEventHandler) ADP.FindBuilder(handler); if (null != d) { Events.RemoveHandler(EventRowUpdating, d); } } Events.AddHandler(EventRowUpdating, value); } remove { Events.RemoveHandler(EventRowUpdating, value); } } object ICloneable.Clone() { return new OdbcDataAdapter(this); } override protected RowUpdatedEventArgs CreateRowUpdatedEvent(DataRow dataRow, IDbCommand command, StatementType statementType, DataTableMapping tableMapping) { return new OdbcRowUpdatedEventArgs(dataRow, command, statementType, tableMapping); } override protected RowUpdatingEventArgs CreateRowUpdatingEvent(DataRow dataRow, IDbCommand command, StatementType statementType, DataTableMapping tableMapping) { return new OdbcRowUpdatingEventArgs(dataRow, command, statementType, tableMapping); } override protected void OnRowUpdated(RowUpdatedEventArgs value) { OdbcRowUpdatedEventHandler handler = (OdbcRowUpdatedEventHandler) Events[EventRowUpdated]; if ((null != handler) && (value is OdbcRowUpdatedEventArgs)) { handler(this, (OdbcRowUpdatedEventArgs) value); } base.OnRowUpdated(value); } override protected void OnRowUpdating(RowUpdatingEventArgs value) { OdbcRowUpdatingEventHandler handler = (OdbcRowUpdatingEventHandler) Events[EventRowUpdating]; if ((null != handler) && (value is OdbcRowUpdatingEventArgs)) { handler(this, (OdbcRowUpdatingEventArgs) value); } base.OnRowUpdating(value); } } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007.
Link Menu
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- ReliableSessionBindingElement.cs
- _NegoStream.cs
- CacheChildrenQuery.cs
- Odbc32.cs
- HMACSHA1.cs
- NameSpaceExtractor.cs
- HttpResponse.cs
- CurrencyWrapper.cs
- WebUtil.cs
- ResourceManagerWrapper.cs
- FloaterBaseParaClient.cs
- FrameworkObject.cs
- SimpleFileLog.cs
- AssociationSetMetadata.cs
- MetadataSet.cs
- WebPartsPersonalizationAuthorization.cs
- ContainerTracking.cs
- ParseElement.cs
- ServicePointManager.cs
- DataGridViewRowConverter.cs
- Assign.cs
- TextEditorSpelling.cs
- ClrPerspective.cs
- Transform.cs
- CodeStatement.cs
- UseAttributeSetsAction.cs
- FlowchartSizeFeature.cs
- CircleHotSpot.cs
- DesignerAdapterUtil.cs
- BuilderPropertyEntry.cs
- CodeDOMUtility.cs
- DataControlFieldTypeEditor.cs
- ArithmeticException.cs
- SponsorHelper.cs
- TemplateBamlTreeBuilder.cs
- QueuePropertyVariants.cs
- MouseEvent.cs
- TreeNodeSelectionProcessor.cs
- TextBox.cs
- NumericPagerField.cs
- EditorZone.cs
- XmlSchemaException.cs
- DbConnectionOptions.cs
- Publisher.cs
- AutomationPatternInfo.cs
- itemelement.cs
- CommandEventArgs.cs
- XmlDictionaryString.cs
- ColorConverter.cs
- OutKeywords.cs
- X509ChainElement.cs
- SqlConnection.cs
- WindowsTokenRoleProvider.cs
- DataGridItemCollection.cs
- Point3DValueSerializer.cs
- MarkupExtensionReturnTypeAttribute.cs
- FtpWebRequest.cs
- XmlHierarchicalEnumerable.cs
- TextEditor.cs
- ResXResourceSet.cs
- HitTestWithGeometryDrawingContextWalker.cs
- LoginCancelEventArgs.cs
- DateTimeSerializationSection.cs
- Package.cs
- UpWmlPageAdapter.cs
- BrowsableAttribute.cs
- ManagementNamedValueCollection.cs
- TypeSource.cs
- XmlQueryCardinality.cs
- BitmapEffectInput.cs
- RegisteredScript.cs
- ForeignConstraint.cs
- VisualBasicReference.cs
- DefaultTextStoreTextComposition.cs
- BitmapScalingModeValidation.cs
- CodeStatement.cs
- DataGridViewCellParsingEventArgs.cs
- ObjRef.cs
- ConfigXmlDocument.cs
- MouseDevice.cs
- ColumnWidthChangedEvent.cs
- AnonymousIdentificationModule.cs
- TextRange.cs
- ConvertEvent.cs
- CompiledQueryCacheEntry.cs
- ClassHandlersStore.cs
- _NestedMultipleAsyncResult.cs
- RunClient.cs
- WebPartDescription.cs
- TransactionFormatter.cs
- ListViewUpdatedEventArgs.cs
- TextTabProperties.cs
- Geometry3D.cs
- ClientSettingsSection.cs
- HiddenFieldDesigner.cs
- InstalledVoice.cs
- DateBoldEvent.cs
- EventArgs.cs
- DataViewListener.cs
- MoveSizeWinEventHandler.cs