C# Odbc.OdbcStatementHandle类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了C#中System.Data.Odbc.OdbcStatementHandle类的典型用法代码示例。如果您正苦于以下问题：C# OdbcStatementHandle类的具体用法？C# OdbcStatementHandle怎么用？C# OdbcStatementHandle使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

OdbcStatementHandle类属于System.Data.Odbc命名空间，在下文中一共展示了OdbcStatementHandle类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: OdbcHandle

 internal OdbcHandle(OdbcStatementHandle parentHandle, ODBC32.SQL_ATTR attribute) : base(IntPtr.Zero, true)
 {
     ODBC32.RetCode code;
     this._handleType = ODBC32.SQL_HANDLE.DESC;
     bool success = false;
     RuntimeHelpers.PrepareConstrainedRegions();
     try
     {
         int num;
         parentHandle.DangerousAddRef(ref success);
         code = parentHandle.GetStatementAttribute(attribute, out this.handle, out num);
     }
     finally
     {
         if (success)
         {
             if (IntPtr.Zero != base.handle)
             {
                 this._parentHandle = parentHandle;
             }
             else
             {
                 parentHandle.DangerousRelease();
             }
         }
     }
     if (ADP.PtrZero == base.handle)
     {
         throw ODBC.FailedToGetDescriptorHandle(code);
     }
 }

开发者ID:pritesh-mandowara-sp，项目名称:DecompliedDotNetLibraries，代码行数:31，代码来源:OdbcHandle.cs

示例2: SQLBindCol

 static internal extern /*SQLRETURN*/ODBC32.RetCode SQLBindCol(
     /*SQLHSTMT*/OdbcStatementHandle StatementHandle,
     /*SQLUSMALLINT*/UInt16 ColumnNumber,
     /*SQLSMALLINT*/ODBC32.SQL_C TargetType,
     /*SQLPOINTER*/IntPtr TargetValue,
     /*SQLLEN*/IntPtr BufferLength,
     /*SQLLEN* */IntPtr StrLen_or_Ind);

开发者ID:uQr，项目名称:referencesource，代码行数:7，代码来源:UnsafeNativeMethods.cs

示例3: DisposeKeyInfoStatementHandle

 internal void DisposeKeyInfoStatementHandle()
 {
     OdbcStatementHandle handle = this._keyinfostmt;
     if (handle != null)
     {
         this._keyinfostmt = null;
         handle.Dispose();
     }
 }

开发者ID:pritesh-mandowara-sp，项目名称:DecompliedDotNetLibraries，代码行数:9，代码来源:CMDWrapper.cs

示例4: SQLBindParameter

 static internal extern /*SQLRETURN*/ODBC32.RetCode SQLBindParameter(
     /*SQLHSTMT*/OdbcStatementHandle StatementHandle,
     /*SQLUSMALLINT*/UInt16 ParameterNumber,
     /*SQLSMALLINT*/Int16 ParamDirection,
     /*SQLSMALLINT*/ODBC32.SQL_C SQLCType,
     /*SQLSMALLINT*/Int16 SQLType,
     /*SQLULEN*/IntPtr    cbColDef,
     /*SQLSMALLINT*/IntPtr ibScale,
     /*SQLPOINTER*/HandleRef rgbValue,
     /*SQLLEN*/IntPtr BufferLength,
     /*SQLLEN* */HandleRef StrLen_or_Ind);

开发者ID:uQr，项目名称:referencesource，代码行数:11，代码来源:UnsafeNativeMethods.cs

示例5: DisposeStatementHandle

 internal void DisposeStatementHandle()
 {
     this.DisposeKeyInfoStatementHandle();
     this.DisposeDescriptorHandle();
     OdbcStatementHandle handle = this._stmt;
     if (handle != null)
     {
         this._stmt = null;
         handle.Dispose();
     }
 }

开发者ID:pritesh-mandowara-sp，项目名称:DecompliedDotNetLibraries，代码行数:11，代码来源:CMDWrapper.cs

示例6: SQLNumResultCols

 static internal extern /*SQLRETURN*/ODBC32.RetCode SQLNumResultCols(
     /*SQLHSTMT*/OdbcStatementHandle  StatementHandle,
     /*SQLSMALLINT* */out Int16 ColumnCount);

开发者ID:uQr，项目名称:referencesource，代码行数:3，代码来源:UnsafeNativeMethods.cs

示例7: SQLMoreResults

 static internal extern /*SQLRETURN*/ODBC32.RetCode SQLMoreResults(
     /*SQLHSTMT*/OdbcStatementHandle  StatementHandle);

开发者ID:uQr，项目名称:referencesource，代码行数:2，代码来源:UnsafeNativeMethods.cs

示例8: Bind

 internal void Bind(OdbcStatementHandle hstmt, OdbcCommand command, short ordinal, CNativeBuffer parameterBuffer, bool allowReentrance)
 {
     ODBC32.SQL_C sql_c = this._prepared_Sql_C_Type;
     ODBC32.SQL_PARAM sql_param = this.SqlDirectionFromParameterDirection();
     int offset = this._preparedOffset;
     int sizeorprecision = this._preparedSize;
     object obj2 = this._preparedValue;
     int valueSize = this.GetValueSize(obj2, offset);
     int num4 = this.GetColumnSize(obj2, offset, ordinal);
     byte parameterPrecision = this.GetParameterPrecision(obj2);
     byte parameterScale = this.GetParameterScale(obj2);
     HandleRef buffer = parameterBuffer.PtrOffset(this._preparedValueOffset, this._preparedBufferSize);
     HandleRef intbuffer = parameterBuffer.PtrOffset(this._preparedIntOffset, IntPtr.Size);
     if (ODBC32.SQL_C.NUMERIC == sql_c)
     {
         if (((ODBC32.SQL_PARAM.INPUT_OUTPUT == sql_param) && (obj2 is decimal)) && (parameterScale < this._internalScale))
         {
             while (parameterScale < this._internalScale)
             {
                 obj2 = ((decimal) obj2) * 10M;
                 parameterScale = (byte) (parameterScale + 1);
             }
         }
         this.SetInputValue(obj2, sql_c, valueSize, parameterPrecision, 0, parameterBuffer);
         if (ODBC32.SQL_PARAM.INPUT != sql_param)
         {
             parameterBuffer.WriteInt16(this._preparedValueOffset, (short) ((parameterScale << 8) | parameterPrecision));
         }
     }
     else
     {
         this.SetInputValue(obj2, sql_c, valueSize, sizeorprecision, offset, parameterBuffer);
     }
     if (((this._hasChanged || (this._boundSqlCType != sql_c)) || ((this._boundParameterType != this._bindtype._sql_type) || (this._boundSize != num4))) || (((this._boundScale != parameterScale) || (this._boundBuffer != buffer.Handle)) || (this._boundIntbuffer != intbuffer.Handle)))
     {
         ODBC32.RetCode retcode = hstmt.BindParameter(ordinal, (short) sql_param, sql_c, this._bindtype._sql_type, (IntPtr) num4, (IntPtr) parameterScale, buffer, (IntPtr) this._preparedBufferSize, intbuffer);
         if (retcode != ODBC32.RetCode.SUCCESS)
         {
             if ("07006" == command.GetDiagSqlState())
             {
                 Bid.Trace("<odbc.OdbcParameter.Bind|ERR> Call to BindParameter returned errorcode [07006]\n");
                 command.Connection.FlagRestrictedSqlBindType(this._bindtype._sql_type);
                 if (allowReentrance)
                 {
                     this.Bind(hstmt, command, ordinal, parameterBuffer, false);
                     return;
                 }
             }
             command.Connection.HandleError(hstmt, retcode);
         }
         this._hasChanged = false;
         this._boundSqlCType = sql_c;
         this._boundParameterType = this._bindtype._sql_type;
         this._boundSize = num4;
         this._boundScale = parameterScale;
         this._boundBuffer = buffer.Handle;
         this._boundIntbuffer = intbuffer.Handle;
         if (ODBC32.SQL_C.NUMERIC == sql_c)
         {
             OdbcDescriptorHandle descriptorHandle = command.GetDescriptorHandle(ODBC32.SQL_ATTR.APP_PARAM_DESC);
             retcode = descriptorHandle.SetDescriptionField1(ordinal, ODBC32.SQL_DESC.TYPE, (IntPtr) 2L);
             if (retcode != ODBC32.RetCode.SUCCESS)
             {
                 command.Connection.HandleError(hstmt, retcode);
             }
             int num2 = parameterPrecision;
             retcode = descriptorHandle.SetDescriptionField1(ordinal, ODBC32.SQL_DESC.PRECISION, (IntPtr) num2);
             if (retcode != ODBC32.RetCode.SUCCESS)
             {
                 command.Connection.HandleError(hstmt, retcode);
             }
             num2 = parameterScale;
             retcode = descriptorHandle.SetDescriptionField1(ordinal, ODBC32.SQL_DESC.SCALE, (IntPtr) num2);
             if (retcode != ODBC32.RetCode.SUCCESS)
             {
                 command.Connection.HandleError(hstmt, retcode);
             }
             retcode = descriptorHandle.SetDescriptionField2(ordinal, ODBC32.SQL_DESC.DATA_PTR, buffer);
             if (retcode != ODBC32.RetCode.SUCCESS)
             {
                 command.Connection.HandleError(hstmt, retcode);
             }
         }
     }
 }

开发者ID:pritesh-mandowara-sp，项目名称:DecompliedDotNetLibraries，代码行数:85，代码来源:OdbcParameter.cs

示例9: FreeKeyInfoStatementHandle

        internal void FreeKeyInfoStatementHandle(ODBC32.STMT stmt) {
            OdbcStatementHandle handle = _keyinfostmt;
            if (null != handle) {
                try {
                    handle.FreeStatement(stmt);
                }
                catch (Exception e) {
                    // 
                    if (ADP.IsCatchableExceptionType(e)) {
                        _keyinfostmt = null;
                        handle.Dispose();
                    }

                    throw;
                }
            }
        }

开发者ID:krytht，项目名称:DotNetReferenceSource，代码行数:17，代码来源:OdbcCommand.cs

示例10: SQLTablesW

 static internal extern /*SQLRETURN*/ODBC32.RetCode SQLTablesW (
     /*SQLHSTMT*/OdbcStatementHandle StatementHandle,
     [In, MarshalAs(UnmanagedType.LPWStr)]
     /*SQLCHAR* */string CatalogName,
     /*SQLSMALLINT*/Int16 NameLen1,
     [In, MarshalAs(UnmanagedType.LPWStr)]
     /*SQLCHAR* */string SchemaName,
     /*SQLSMALLINT*/Int16 NameLen2,
     [In, MarshalAs(UnmanagedType.LPWStr)]
     /*SQLCHAR* */string TableName,
     /*SQLSMALLINT*/Int16 NameLen3,
     [In, MarshalAs(UnmanagedType.LPWStr)]
     /*SQLCHAR* */string TableType,
     /*SQLSMALLINT*/Int16 NameLen4);

开发者ID:uQr，项目名称:referencesource，代码行数:14，代码来源:UnsafeNativeMethods.cs

示例11: SQLSetStmtAttrW

 static internal extern /*SQLRETURN*/ODBC32.RetCode SQLSetStmtAttrW(
     /*SQLHSTMT*/OdbcStatementHandle          StatementHandle,
     /*SQLINTEGER*/Int32      Attribute,
     /*SQLPOINTER*/IntPtr     Value,
     /*SQLINTEGER*/Int32      StringLength);

开发者ID:uQr，项目名称:referencesource，代码行数:5，代码来源:UnsafeNativeMethods.cs

示例12: FreeStatementHandle

        internal void FreeStatementHandle(ODBC32.STMT stmt) {
            DisposeDescriptorHandle();

            OdbcStatementHandle handle = _stmt;
            if (null != handle) {
                try {
                    ODBC32.RetCode retcode;
                    retcode = handle.FreeStatement(stmt);
                    StatementErrorHandler(retcode);
                }
                catch (Exception e) {
                    // 
                    if (ADP.IsCatchableExceptionType(e)) {
                        _stmt = null;
                        handle.Dispose();
                    }

                    throw;
                }
            }
        }

开发者ID:krytht，项目名称:DotNetReferenceSource，代码行数:21，代码来源:OdbcCommand.cs

示例13: DisposeKeyInfoStatementHandle

 internal void DisposeKeyInfoStatementHandle() {
     OdbcStatementHandle handle = _keyinfostmt;
     if (null != handle) {
         _keyinfostmt = null;
         handle.Dispose();
     }
 }

开发者ID:krytht，项目名称:DotNetReferenceSource，代码行数:7，代码来源:OdbcCommand.cs

示例14: DisposeStatementHandle

        internal void DisposeStatementHandle() {
            DisposeKeyInfoStatementHandle();
            DisposeDescriptorHandle();

            OdbcStatementHandle handle = _stmt;
            if (null != handle) {
                _stmt = null;
                handle.Dispose();
            }
        }

开发者ID:krytht，项目名称:DotNetReferenceSource，代码行数:10，代码来源:OdbcCommand.cs

示例15: TrySetStatementAttribute

        void TrySetStatementAttribute (OdbcStatementHandle stmt, ODBC32.SQL_ATTR stmtAttribute, IntPtr value) {

            ODBC32.RetCode retcode = stmt.SetStatementAttribute(
                stmtAttribute,
                value,
                ODBC32.SQL_IS.UINTEGER);

            if (retcode == ODBC32.RetCode.ERROR) {

                string sqlState;
                stmt.GetDiagnosticField(out sqlState);

                if ((sqlState == "HYC00") || (sqlState == "HY092")) {
                    Connection.FlagUnsupportedStmtAttr(stmtAttribute);
                }
                else {
                    // now what? Should we throw?
                }
            }
        }

开发者ID:krytht，项目名称:DotNetReferenceSource，代码行数:20，代码来源:OdbcCommand.cs

示例16: SQLPrepareW

 static internal extern /*SQLRETURN*/ODBC32.RetCode SQLPrepareW(
     /*SQLHSTMT*/OdbcStatementHandle  StatementHandle,
     [In, MarshalAs(UnmanagedType.LPWStr)]
     /*SQLCHAR* */string   StatementText,
     /*SQLINTEGER*/Int32 TextLength);

开发者ID:uQr，项目名称:referencesource，代码行数:5，代码来源:UnsafeNativeMethods.cs

示例17: SQLRowCount

 static internal extern /*SQLRETURN*/ODBC32.RetCode SQLRowCount(
     /*SQLHSTMT*/OdbcStatementHandle  StatementHandle,
     /*SQLLEN* */out IntPtr RowCount);

开发者ID:uQr，项目名称:referencesource，代码行数:3，代码来源:UnsafeNativeMethods.cs

示例18: OdbcDescriptorHandle

 internal OdbcDescriptorHandle(OdbcStatementHandle statementHandle, ODBC32.SQL_ATTR attribute) : base(statementHandle, attribute) {
 }

开发者ID:nlh774，项目名称:DotNetReferenceSource，代码行数:2，代码来源:OdbcHandle.cs

示例19: SQLSpecialColumnsW

 static internal extern /*SQLRETURN*/ODBC32.RetCode SQLSpecialColumnsW (
     /*SQLHSTMT*/OdbcStatementHandle StatementHandle,
     /*SQLUSMALLINT*/ODBC32.SQL_SPECIALCOLS IdentifierType,
     [In, MarshalAs(UnmanagedType.LPWStr)]
     /*SQLCHAR* */string CatalogName,
     /*SQLSMALLINT*/Int16 NameLen1,
     [In, MarshalAs(UnmanagedType.LPWStr)]
     /*SQLCHAR* */string SchemaName,
     /*SQLSMALLINT*/Int16 NameLen2,
     [In, MarshalAs(UnmanagedType.LPWStr)]
     /*SQLCHAR* */string TableName,
     /*SQLSMALLINT*/Int16 NameLen3,
     /*SQLUSMALLINT*/ODBC32.SQL_SCOPE Scope,
     /*SQLUSMALLINT*/ ODBC32.SQL_NULLABILITY Nullable);

开发者ID:uQr，项目名称:referencesource，代码行数:14，代码来源:UnsafeNativeMethods.cs

示例20: SQLCloseCursor

 static internal extern /*SQLRETURN*/ODBC32.RetCode SQLCloseCursor(
     /*SQLHSTMT*/OdbcStatementHandle StatementHandle);

开发者ID:uQr，项目名称:referencesource，代码行数:2，代码来源:UnsafeNativeMethods.cs

注：本文中的System.Data.Odbc.OdbcStatementHandle类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

C# OleDb.OleDbCommand类代码示例发布时间：2022-05-26

C# Odbc.OdbcParameter类代码示例发布时间：2022-05-26

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：18142|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9632|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8161|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8538|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8439|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9359|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8409|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7847|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8395|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7387|2022-11-06

客服电话

电子邮件

C# Odbc.OdbcStatementHandle类代码示例

示例1: OdbcHandle

示例2: SQLBindCol

示例3: DisposeKeyInfoStatementHandle

示例4: SQLBindParameter

示例5: DisposeStatementHandle

示例6: SQLNumResultCols

示例7: SQLMoreResults

示例8: Bind

示例9: FreeKeyInfoStatementHandle

示例10: SQLTablesW

示例11: SQLSetStmtAttrW

示例12: FreeStatementHandle

示例13: DisposeKeyInfoStatementHandle

示例14: DisposeStatementHandle

示例15: TrySetStatementAttribute

示例16: SQLPrepareW

示例17: SQLRowCount

示例18: OdbcDescriptorHandle

示例19: SQLSpecialColumnsW

示例20: SQLCloseCursor

请发表评论

全部评论

上一篇：

下一篇：

DelphiXE7用indy开发微信公众平台（3）-验

bradtraversy/iweather: Ionic 3 mobile we

CVE-2020-25588

joaomh/curso-de-matlab

断牙刷新位置时间（断牙属性及刷新位置介绍

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053