C# (CSharp) OdbcStatementHandle Examples

Example #1

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

Example #2

 internal static extern /*SQLRETURN*/ ODBC32.RetCode SQLGetData(
     /*SQLHSTMT*/ OdbcStatementHandle StatementHandle,
     /*SQLUSMALLINT*/ ushort ColumnNumber,
     /*SQLSMALLINT*/ ODBC32.SQL_C TargetType,
     /*SQLPOINTER*/ CNativeBuffer TargetValue,
     /*SQLLEN*/ IntPtr BufferLength, // sql.h differs from MSDN
                                     /*SQLLEN* */ out IntPtr StrLen_or_Ind);

Example #3

 internal static extern /*SQLRETURN*/ ODBC32.RetCode SQLProceduresW(
     /*SQLHSTMT*/ OdbcStatementHandle StatementHandle,
     [In, MarshalAs(UnmanagedType.LPWStr)] /*SQLCHAR* */ string CatalogName,
     /*SQLSMALLINT*/ short NameLen1,
     [In, MarshalAs(UnmanagedType.LPWStr)] /*SQLCHAR* */ string SchemaName,
     /*SQLSMALLINT*/ short NameLen2,
     [In, MarshalAs(UnmanagedType.LPWStr)] /*SQLCHAR* */ string ProcName,
     /*SQLSMALLINT*/ short NameLen3);

Example #4

File: Interop.Odbc.cs Project: SingleAccretion/runtime

 internal static partial ODBC32.SQLRETURN SQLProceduresW(
     /*SQLHSTMT*/ OdbcStatementHandle StatementHandle,
     /*SQLCHAR* */ string CatalogName,
     /*SQLSMALLINT*/ short NameLen1,
     /*SQLCHAR* */ string SchemaName,
     /*SQLSMALLINT*/ short NameLen2,
     /*SQLCHAR* */ string ProcName,
     /*SQLSMALLINT*/ short NameLen3);

Example #5

File: Interop.Odbc.cs Project: SingleAccretion/runtime

 internal static partial ODBC32.SQLRETURN SQLPrimaryKeysW(
     /*SQLHSTMT*/ OdbcStatementHandle StatementHandle,
     /*SQLCHAR* */ string?CatalogName,
     /*SQLSMALLINT*/ short NameLen1,
     /*SQLCHAR* */ string?SchemaName,
     /*SQLSMALLINT*/ short NameLen2,
     /*SQLCHAR* */ string TableName,
     /*SQLSMALLINT*/ short NameLen3);

Example #6

 internal static extern /*SQLRETURN*/ ODBC32.RetCode SQLProceduresW(
     /*SQLHSTMT*/ OdbcStatementHandle StatementHandle,
     /*SQLCHAR* */ string CatalogName,
     /*SQLSMALLINT*/ Int16 NameLen1,
     /*SQLCHAR* */ string SchemaName,
     /*SQLSMALLINT*/ Int16 NameLen2,
     /*SQLCHAR* */ string ProcName,
     /*SQLSMALLINT*/ Int16 NameLen3);

Example #7

 internal static extern /*SQLRETURN*/ ODBC32.RetCode SQLPrimaryKeysW(
     /*SQLHSTMT*/ OdbcStatementHandle StatementHandle,
     /*SQLCHAR* */ string CatalogName,
     /*SQLSMALLINT*/ short NameLen1,
     /*SQLCHAR* */ string SchemaName,
     /*SQLSMALLINT*/ short NameLen2,
     /*SQLCHAR* */ string TableName,
     /*SQLSMALLINT*/ short NameLen3);

Example #8

 internal static extern /*SQLRETURN*/ ODBC32.RetCode SQLColAttributeW(
     /*SQLHSTMT*/ OdbcStatementHandle StatementHandle,
     /*SQLUSMALLINT*/ short ColumnNumber,
     /*SQLUSMALLINT*/ short FieldIdentifier,
     /*SQLPOINTER*/ CNativeBuffer CharacterAttribute,
     /*SQLSMALLINT*/ short BufferLength,
     /*SQLSMALLINT* */ out short StringLength,
     /*SQLPOINTER*/ out IntPtr NumericAttribute);

Example #9

File: Interop.Odbc.cs Project: SingleAccretion/runtime

 internal static partial ODBC32.SQLRETURN SQLStatisticsW(
     /*SQLHSTMT*/ OdbcStatementHandle StatementHandle,
     /*SQLCHAR* */ string?CatalogName,
     /*SQLSMALLINT*/ short NameLen1,
     /*SQLCHAR* */ string?SchemaName,
     /*SQLSMALLINT*/ short NameLen2,
     /*SQLCHAR* */ IntPtr TableName, // IntPtr instead of string because callee may mutate contents
     /*SQLSMALLINT*/ short NameLen3,
     /*SQLUSMALLINT*/ short Unique,
     /*SQLUSMALLINT*/ short Reserved);

Example #10

 internal static extern /*SQLRETURN*/ ODBC32.RetCode SQLColumnsW(
     /*SQLHSTMT*/ OdbcStatementHandle StatementHandle,
     /*SQLCHAR* */ string CatalogName,
     /*SQLSMALLINT*/ Int16 NameLen1,
     /*SQLCHAR* */ string SchemaName,
     /*SQLSMALLINT*/ Int16 NameLen2,
     /*SQLCHAR* */ string TableName,
     /*SQLSMALLINT*/ Int16 NameLen3,
     /*SQLCHAR* */ string ColumnName,
     /*SQLSMALLINT*/ Int16 NameLen4);

Example #11

 internal static extern /*SQLRETURN*/ ODBC32.RetCode SQLStatisticsW(
     /*SQLHSTMT*/ OdbcStatementHandle StatementHandle,
     /*SQLCHAR* */ string CatalogName,
     /*SQLSMALLINT*/ Int16 NameLen1,
     /*SQLCHAR* */ string SchemaName,
     /*SQLSMALLINT*/ Int16 NameLen2,
     /*SQLCHAR* */ string TableName,
     /*SQLSMALLINT*/ Int16 NameLen3,
     /*SQLUSMALLINT*/ Int16 Unique,
     /*SQLUSMALLINT*/ Int16 Reserved);

Example #12

File: Interop.Odbc.cs Project: SingleAccretion/runtime

 internal static partial ODBC32.SQLRETURN SQLTablesW(
     /*SQLHSTMT*/ OdbcStatementHandle StatementHandle,
     /*SQLCHAR* */ string CatalogName,
     /*SQLSMALLINT*/ short NameLen1,
     /*SQLCHAR* */ string SchemaName,
     /*SQLSMALLINT*/ short NameLen2,
     /*SQLCHAR* */ string TableName,
     /*SQLSMALLINT*/ short NameLen3,
     /*SQLCHAR* */ string TableType,
     /*SQLSMALLINT*/ short NameLen4);

Example #13

File: Interop.Odbc.cs Project: layomia/dotnet_runtime

 internal static extern /*SQLRETURN*/ ODBC32.RetCode SQLProcedureColumnsW(
     /*SQLHSTMT*/ OdbcStatementHandle StatementHandle,
     /*SQLCHAR* */ string?CatalogName,
     /*SQLSMALLINT*/ short NameLen1,
     /*SQLCHAR* */ string?SchemaName,
     /*SQLSMALLINT*/ short NameLen2,
     /*SQLCHAR* */ string?ProcName,
     /*SQLSMALLINT*/ short NameLen3,
     /*SQLCHAR* */ string?ColumnName,
     /*SQLSMALLINT*/ short NameLen4);

Example #14

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

Example #15

File: Interop.Odbc.cs Project: SingleAccretion/runtime

        internal static partial /*SQLRETURN*/ ODBC32.SQLRETURN SQLBindCol(
            /*SQLHSTMT*/ OdbcStatementHandle StatementHandle,
            /*SQLUSMALLINT*/ ushort ColumnNumber,
            /*SQLSMALLINT*/ ODBC32.SQL_C TargetType,
            /*SQLPOINTER*/
#if NET7_0_OR_GREATER
            [MarshalUsing(typeof(HandleRefMarshaller))]
#endif
            HandleRef TargetValue,
            /*SQLLEN*/ IntPtr BufferLength,
            /*SQLLEN* */ IntPtr StrLen_or_Ind);

Example #16

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

Example #17

File: Interop.Odbc.cs Project: SingleAccretion/runtime

 internal static partial ODBC32.SQLRETURN SQLSpecialColumnsW(
     /*SQLHSTMT*/ OdbcStatementHandle StatementHandle,
     /*SQLUSMALLINT*/ ODBC32.SQL_SPECIALCOLS IdentifierType,
     /*SQLCHAR* */ string?CatalogName,
     /*SQLSMALLINT*/ short NameLen1,
     /*SQLCHAR* */ string?SchemaName,
     /*SQLSMALLINT*/ short NameLen2,
     /*SQLCHAR* */ string TableName,
     /*SQLSMALLINT*/ short NameLen3,
     /*SQLUSMALLINT*/ ODBC32.SQL_SCOPE Scope,
     /*SQLUSMALLINT*/ ODBC32.SQL_NULLABILITY Nullable);

Example #18

File: UnsafeNativeMethods.cs Project: jnm2/corefx

 internal static extern /*SQLRETURN*/ ODBC32.RetCode SQLPrimaryKeysW(
     /*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);

Example #19

 internal static extern /*SQLRETURN*/ ODBC32.RetCode SQLStatisticsW(
     /*SQLHSTMT*/ OdbcStatementHandle StatementHandle,
     [In, MarshalAs(UnmanagedType.LPWStr)]
     /*SQLCHAR* */ string CatalogName,
     /*SQLSMALLINT*/ short NameLen1,
     [In, MarshalAs(UnmanagedType.LPWStr)]
     /*SQLCHAR* */ string SchemaName,
     /*SQLSMALLINT*/ short NameLen2,
     [In, MarshalAs(UnmanagedType.LPWStr)]
     /*SQLCHAR* */ string TableName,
     /*SQLSMALLINT*/ short NameLen3,
     /*SQLUSMALLINT*/ short Unique,
     /*SQLUSMALLINT*/ short Reserved);

Example #20

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

Example #21

File: Interop.Odbc.cs Project: SingleAccretion/runtime

        internal static partial /*SQLRETURN*/ ODBC32.SQLRETURN SQLBindParameter(
            /*SQLHSTMT*/ OdbcStatementHandle StatementHandle,
            /*SQLUSMALLINT*/ ushort ParameterNumber,
            /*SQLSMALLINT*/ short ParamDirection,
            /*SQLSMALLINT*/ ODBC32.SQL_C SQLCType,
            /*SQLSMALLINT*/ short SQLType,
            /*SQLULEN*/ IntPtr cbColDef,
            /*SQLSMALLINT*/ IntPtr ibScale,
            /*SQLPOINTER*/
#if NET7_0_OR_GREATER
            [MarshalUsing(typeof(HandleRefMarshaller))]
#endif
            HandleRef rgbValue,
            /*SQLLEN*/ IntPtr BufferLength,
            /*SQLLEN* */
#if NET7_0_OR_GREATER
            [MarshalUsing(typeof(HandleRefMarshaller))]
#endif
            HandleRef StrLen_or_Ind);

Example #22

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

Example #23

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

Example #24

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

Example #25

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

Example #26

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

Example #27

 internal static extern /*SQLRETURN*/ ODBC32.RetCode SQLGetTypeInfo(
     /*SQLHSTMT*/ OdbcStatementHandle StatementHandle,
     /*SQLSMALLINT*/ short fSqlType);

Example #28

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

Example #29

 internal static extern /*SQLRETURN*/ ODBC32.RetCode SQLGetStmtAttrW(
     /*SQLHSTMT*/ OdbcStatementHandle StatementHandle,
     /*SQLINTEGER*/ ODBC32.SQL_ATTR Attribute,
     /*SQLPOINTER*/ out IntPtr Value,
     /*SQLINTEGER*/ int BufferLength,
     /*SQLINTEGER*/ out int StringLength);

Example #30

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