Code:
/ Dotnetfx_Vista_SP2 / Dotnetfx_Vista_SP2 / 8.0.50727.4016 / DEVDIV / depot / DevDiv / releases / whidbey / NetFxQFE / 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
- X509ChainPolicy.cs
- ResumeStoryboard.cs
- DbParameterCollectionHelper.cs
- Transform.cs
- NameValueConfigurationCollection.cs
- ExtendedPropertiesHandler.cs
- TcpAppDomainProtocolHandler.cs
- NativeActivityAbortContext.cs
- BamlVersionHeader.cs
- DesignBindingPicker.cs
- BitmapCodecInfo.cs
- UnhandledExceptionEventArgs.cs
- WindowsNonControl.cs
- WebControl.cs
- TrustSection.cs
- FileVersionInfo.cs
- PnrpPermission.cs
- RsaSecurityTokenParameters.cs
- CaseInsensitiveHashCodeProvider.cs
- TransformDescriptor.cs
- ToolStripRenderEventArgs.cs
- ProfileSection.cs
- Translator.cs
- EncoderBestFitFallback.cs
- ServerValidateEventArgs.cs
- WebPartZone.cs
- _PooledStream.cs
- CursorConverter.cs
- StylusButtonEventArgs.cs
- MethodExpression.cs
- StrongNamePublicKeyBlob.cs
- DataSourceControlBuilder.cs
- CaseStatement.cs
- AddIn.cs
- EntityCodeGenerator.cs
- SmtpMail.cs
- Stroke2.cs
- PropertyGrid.cs
- DataGridViewCellValidatingEventArgs.cs
- ExpressionPrinter.cs
- EntityConnection.cs
- DeflateStreamAsyncResult.cs
- AdCreatedEventArgs.cs
- ConnectionPoolManager.cs
- entitydatasourceentitysetnameconverter.cs
- ScrollPattern.cs
- SQLChars.cs
- BrowserTree.cs
- InlineCollection.cs
- SystemPens.cs
- EpmContentSerializerBase.cs
- ZipFileInfo.cs
- CompilationUnit.cs
- XmlIncludeAttribute.cs
- DataSourceExpressionCollection.cs
- RemoteWebConfigurationHostStream.cs
- RootAction.cs
- PriorityItem.cs
- DynamicActivityProperty.cs
- MappingModelBuildProvider.cs
- SelectiveScrollingGrid.cs
- XmlDomTextWriter.cs
- WindowInteropHelper.cs
- SqlUdtInfo.cs
- ThreadSafeMessageFilterTable.cs
- RotateTransform.cs
- NumericUpDownAccelerationCollection.cs
- XmlSchemaProviderAttribute.cs
- DrawingGroup.cs
- TextWriterTraceListener.cs
- ManualResetEvent.cs
- CompareValidator.cs
- GroupBox.cs
- ProtocolElementCollection.cs
- UInt32Storage.cs
- Binding.cs
- SqlParameter.cs
- AllMembershipCondition.cs
- MediaTimeline.cs
- DesigntimeLicenseContext.cs
- TemplatedWizardStep.cs
- IndentedWriter.cs
- MsmqIntegrationAppDomainProtocolHandler.cs
- DataExpression.cs
- WrappedReader.cs
- SqlTrackingService.cs
- Animatable.cs
- SqlUdtInfo.cs
- LostFocusEventManager.cs
- DataServices.cs
- COM2ColorConverter.cs
- Request.cs
- TextAdaptor.cs
- PersistenceIOParticipant.cs
- DecimalAverageAggregationOperator.cs
- MethodRental.cs
- ValidatedControlConverter.cs
- X509CertificateCollection.cs
- StringFormat.cs
- FocusWithinProperty.cs