Code:
/ Net / Net / 3.5.50727.3053 / DEVDIV / depot / DevDiv / releases / whidbey / netfxsp / ndp / fx / src / Data / System / Data / Odbc / OdbcParameterCollection.cs / 1 / OdbcParameterCollection.cs
//------------------------------------------------------------------------------ //// Copyright (c) Microsoft Corporation. All rights reserved. // //[....] //[....] //----------------------------------------------------------------------------- namespace System.Data.Odbc { using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Data.Common; using System.Data.ProviderBase; using System.Diagnostics; using System.Runtime.InteropServices; [ Editor("Microsoft.VSDesigner.Data.Design.DBParametersEditor, " + AssemblyRef.MicrosoftVSDesigner, "System.Drawing.Design.UITypeEditor, " + AssemblyRef.SystemDrawing), ListBindable(false) ] #if WINFSInternalOnly internal #else public #endif sealed partial class OdbcParameterCollection : DbParameterCollection { private bool _rebindCollection; // The collection needs to be (re)bound private static Type ItemType = typeof(OdbcParameter); internal OdbcParameterCollection() : base() { } internal bool RebindCollection { get { return _rebindCollection; } set { _rebindCollection = value; } } [ Browsable(false), DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden) ] new public OdbcParameter this[int index] { get { return (OdbcParameter)GetParameter(index); } set { SetParameter(index, value); } } [ Browsable(false), DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden) ] new public OdbcParameter this[string parameterName] { get { return (OdbcParameter)GetParameter(parameterName); } set { SetParameter(parameterName, value); } } public OdbcParameter Add(OdbcParameter value) { // MDAC 59206 Add((object)value); return value; } [ EditorBrowsableAttribute(EditorBrowsableState.Never)] [ ObsoleteAttribute("Add(String parameterName, Object value) has been deprecated. Use AddWithValue(String parameterName, Object value). http://go.microsoft.com/fwlink/?linkid=14202", false) ] // 79027 public OdbcParameter Add(string parameterName, object value) { // MDAC 59206 return Add(new OdbcParameter(parameterName, value)); } public OdbcParameter AddWithValue(string parameterName, object value) { // MDAC 79027 return Add(new OdbcParameter(parameterName, value)); } public OdbcParameter Add(string parameterName, OdbcType odbcType) { return Add(new OdbcParameter(parameterName, odbcType)); } public OdbcParameter Add(string parameterName, OdbcType odbcType, int size) { return Add(new OdbcParameter(parameterName, odbcType, size)); } public OdbcParameter Add(string parameterName, OdbcType odbcType, int size, string sourceColumn) { return Add(new OdbcParameter(parameterName, odbcType, size, sourceColumn)); } public void AddRange(OdbcParameter[] values) { // V1.2.3300 AddRange((Array)values); } // Walks through the collection and binds each parameter // internal void Bind(OdbcCommand command, CMDWrapper cmdWrapper, CNativeBuffer parameterBuffer){ for(int i = 0; i < Count; ++i) { this[i].Bind(cmdWrapper.StatementHandle, command, checked((short)(i+1)), parameterBuffer, true); } _rebindCollection = false; } internal int CalcParameterBufferSize(OdbcCommand command){ // Calculate the size of the buffer we need int parameterBufferSize = 0; for(int i = 0; i < Count; ++i) { if (_rebindCollection) { this[i].HasChanged = true; } this[i].PrepareForBind(command, (short)(i+1), ref parameterBufferSize); parameterBufferSize = (parameterBufferSize + (IntPtr.Size-1)) & ~(IntPtr.Size-1); // align buffer; } return parameterBufferSize; } // Walks through the collection and clears the parameters // internal void ClearBindings () { for(int i = 0; i < Count; ++i) { this[i].ClearBinding(); } } override public bool Contains(string value) { // WebData 97349 return (-1 != IndexOf(value)); } public bool Contains(OdbcParameter value) { return (-1 != IndexOf(value)); } public void CopyTo(OdbcParameter[] array, int index) { CopyTo((Array)array, index); } private void OnChange() { _rebindCollection = true; } internal void GetOutputValues (CMDWrapper cmdWrapper) { // mdac 88542 - we will not read out the parameters if the collection has changed if (!_rebindCollection) { CNativeBuffer parameterBuffer = cmdWrapper._nativeParameterBuffer; for(int i = 0; i < Count; ++i) { this[i].GetOutputValue(parameterBuffer); } } } public int IndexOf(OdbcParameter value) { return IndexOf((object)value); } public void Insert(int index, OdbcParameter value) { Insert(index, (object)value); } public void Remove(OdbcParameter value) { Remove((object)value); } } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007. //------------------------------------------------------------------------------ //// Copyright (c) Microsoft Corporation. All rights reserved. // //[....] //[....] //----------------------------------------------------------------------------- namespace System.Data.Odbc { using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Data.Common; using System.Data.ProviderBase; using System.Diagnostics; using System.Runtime.InteropServices; [ Editor("Microsoft.VSDesigner.Data.Design.DBParametersEditor, " + AssemblyRef.MicrosoftVSDesigner, "System.Drawing.Design.UITypeEditor, " + AssemblyRef.SystemDrawing), ListBindable(false) ] #if WINFSInternalOnly internal #else public #endif sealed partial class OdbcParameterCollection : DbParameterCollection { private bool _rebindCollection; // The collection needs to be (re)bound private static Type ItemType = typeof(OdbcParameter); internal OdbcParameterCollection() : base() { } internal bool RebindCollection { get { return _rebindCollection; } set { _rebindCollection = value; } } [ Browsable(false), DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden) ] new public OdbcParameter this[int index] { get { return (OdbcParameter)GetParameter(index); } set { SetParameter(index, value); } } [ Browsable(false), DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden) ] new public OdbcParameter this[string parameterName] { get { return (OdbcParameter)GetParameter(parameterName); } set { SetParameter(parameterName, value); } } public OdbcParameter Add(OdbcParameter value) { // MDAC 59206 Add((object)value); return value; } [ EditorBrowsableAttribute(EditorBrowsableState.Never)] [ ObsoleteAttribute("Add(String parameterName, Object value) has been deprecated. Use AddWithValue(String parameterName, Object value). http://go.microsoft.com/fwlink/?linkid=14202", false) ] // 79027 public OdbcParameter Add(string parameterName, object value) { // MDAC 59206 return Add(new OdbcParameter(parameterName, value)); } public OdbcParameter AddWithValue(string parameterName, object value) { // MDAC 79027 return Add(new OdbcParameter(parameterName, value)); } public OdbcParameter Add(string parameterName, OdbcType odbcType) { return Add(new OdbcParameter(parameterName, odbcType)); } public OdbcParameter Add(string parameterName, OdbcType odbcType, int size) { return Add(new OdbcParameter(parameterName, odbcType, size)); } public OdbcParameter Add(string parameterName, OdbcType odbcType, int size, string sourceColumn) { return Add(new OdbcParameter(parameterName, odbcType, size, sourceColumn)); } public void AddRange(OdbcParameter[] values) { // V1.2.3300 AddRange((Array)values); } // Walks through the collection and binds each parameter // internal void Bind(OdbcCommand command, CMDWrapper cmdWrapper, CNativeBuffer parameterBuffer){ for(int i = 0; i < Count; ++i) { this[i].Bind(cmdWrapper.StatementHandle, command, checked((short)(i+1)), parameterBuffer, true); } _rebindCollection = false; } internal int CalcParameterBufferSize(OdbcCommand command){ // Calculate the size of the buffer we need int parameterBufferSize = 0; for(int i = 0; i < Count; ++i) { if (_rebindCollection) { this[i].HasChanged = true; } this[i].PrepareForBind(command, (short)(i+1), ref parameterBufferSize); parameterBufferSize = (parameterBufferSize + (IntPtr.Size-1)) & ~(IntPtr.Size-1); // align buffer; } return parameterBufferSize; } // Walks through the collection and clears the parameters // internal void ClearBindings () { for(int i = 0; i < Count; ++i) { this[i].ClearBinding(); } } override public bool Contains(string value) { // WebData 97349 return (-1 != IndexOf(value)); } public bool Contains(OdbcParameter value) { return (-1 != IndexOf(value)); } public void CopyTo(OdbcParameter[] array, int index) { CopyTo((Array)array, index); } private void OnChange() { _rebindCollection = true; } internal void GetOutputValues (CMDWrapper cmdWrapper) { // mdac 88542 - we will not read out the parameters if the collection has changed if (!_rebindCollection) { CNativeBuffer parameterBuffer = cmdWrapper._nativeParameterBuffer; for(int i = 0; i < Count; ++i) { this[i].GetOutputValue(parameterBuffer); } } } public int IndexOf(OdbcParameter value) { return IndexOf((object)value); } public void Insert(int index, OdbcParameter value) { Insert(index, (object)value); } public void Remove(OdbcParameter value) { Remove((object)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
- WebPartEditVerb.cs
- XamlStream.cs
- PassportAuthenticationEventArgs.cs
- MarkerProperties.cs
- OTFRasterizer.cs
- EdmFunctionAttribute.cs
- UserControl.cs
- AssociationSet.cs
- InheritanceContextChangedEventManager.cs
- VectorCollectionValueSerializer.cs
- RenderingBiasValidation.cs
- Int32Storage.cs
- BrushValueSerializer.cs
- ValidationHelper.cs
- ElementHost.cs
- QueryOperationResponseOfT.cs
- Helper.cs
- ExceptionWrapper.cs
- IItemContainerGenerator.cs
- ProgressBarRenderer.cs
- ActivityDesigner.cs
- diagnosticsswitches.cs
- ArgumentValue.cs
- SqlConnectionString.cs
- wgx_sdk_version.cs
- SecurityContextSecurityTokenAuthenticator.cs
- ToolZone.cs
- SyntaxCheck.cs
- RuntimeDelegateArgument.cs
- CTreeGenerator.cs
- RSAPKCS1KeyExchangeDeformatter.cs
- EntityParameter.cs
- CodeMethodInvokeExpression.cs
- lengthconverter.cs
- xsdvalidator.cs
- PtsHost.cs
- ObjectSet.cs
- CommentEmitter.cs
- RuntimeIdentifierPropertyAttribute.cs
- ScriptResourceAttribute.cs
- DesignConnectionCollection.cs
- OracleBoolean.cs
- ContentFilePart.cs
- SAPIEngineTypes.cs
- SvcMapFile.cs
- UserControlParser.cs
- MemberInfoSerializationHolder.cs
- SpecialNameAttribute.cs
- BaseProcessor.cs
- FileAuthorizationModule.cs
- WithParamAction.cs
- NotFiniteNumberException.cs
- WindowCollection.cs
- UIElementParaClient.cs
- ClientOptions.cs
- SimpleHandlerBuildProvider.cs
- KeyTime.cs
- DataTransferEventArgs.cs
- InfiniteIntConverter.cs
- TrustManagerPromptUI.cs
- ImageField.cs
- LogWriteRestartAreaState.cs
- ServerProtocol.cs
- QueueProcessor.cs
- BitmapEffectInput.cs
- BamlRecordHelper.cs
- PageBuildProvider.cs
- ObjectStateEntryOriginalDbUpdatableDataRecord.cs
- SymmetricAlgorithm.cs
- ElementAtQueryOperator.cs
- PtsHost.cs
- MenuCommandsChangedEventArgs.cs
- CustomAssemblyResolver.cs
- SqlDependencyListener.cs
- CompilationUnit.cs
- EncryptedPackage.cs
- LocalBuilder.cs
- DataGridItemCollection.cs
- SafeMemoryMappedFileHandle.cs
- ReadOnlyNameValueCollection.cs
- DataGridViewTopLeftHeaderCell.cs
- ActivityXRefPropertyEditor.cs
- EdmFunctionAttribute.cs
- TCEAdapterGenerator.cs
- EntityConnection.cs
- HelpKeywordAttribute.cs
- WindowsGraphicsWrapper.cs
- DataRecordObjectView.cs
- AssertFilter.cs
- CodeAssignStatement.cs
- SkipStoryboardToFill.cs
- ListBox.cs
- Token.cs
- SecurityProtocolCorrelationState.cs
- DLinqTableProvider.cs
- IISMapPath.cs
- ChtmlPhoneCallAdapter.cs
- ObjectDataSourceStatusEventArgs.cs
- SamlAuthorityBinding.cs
- RegexRunnerFactory.cs