skip navigation
  • Product Bundles

    DevCraft

    All Telerik .NET tools and Kendo UI JavaScript components in one package. Now enhanced with:

    • MCP Servers
    • Embedded Reporting
    • Document Processing Libraries
    • SSO Account Sign-in

    Web

    Kendo UI UI for Angular UI for Vue UI for jQuery KendoReact UI for Blazor UI for ASP.NET Core UI for ASP.NET MVC UI for ASP.NET AJAX

    Mobile

    UI for .NET MAUI

    Document Management

    Telerik Document Processing

    Desktop

    UI for .NET MAUI UI for WinUI UI for WinForms UI for WPF

    Reporting

    Telerik Reporting Telerik Report Server

    Testing & Mocking

    Test Studio Telerik JustMock

    CMS

    Sitefinity

    AI Productivity Tools

    MCP Servers

    UI/UX Tools

    ThemeBuilder Design System Kit Templates and Building Blocks

    Debugging

    Fiddler Fiddler Everywhere Fiddler Classic Fiddler Everywhere Reporter FiddlerCore

    Free Tools

    KendoReact Free VB.NET to C# Converter Testing Framework
    View all products
  • Overview
  • Demos
    • What's New
    • Roadmap
    • Release History
  • Support and Learning

    • Support and Learning Hub
    • First Steps
    • Docs
    • Demos
    • Virtual Classroom
    • Use Reports in Applications
    • System Requirements
    • Forums
    • Videos
    • Blogs
    • Submit a Ticket
    • FAQs
  • Pricing
  • Shopping cart
    • Account Overview
    • Your Licenses
    • Downloads
    • Support Center
    • Forum Profile
    • Payment Methods
    • Edit Profile
    • Log out
  • Login
  • Contact Us
  • Try now
Search all

Interface PreparedStatement

Inherited Members
Statement.setMaxRows(Int32)
Statement.getMaxRows()
Statement.setQueryTimeout(Int32)
Statement.getQueryTimeout()
Statement.getResultSet()
Statement.setFetchSize(Int32)
Statement.getFetchSize()
Statement.getConnection()
Statement.executeQuery(String)
Statement.executeUpdate(String)
Statement.close()
Statement.cancel()
Statement.execute(String)
Statement.getMoreResults()
Statement.IsValid()
Statement.GetParameterValues()
Statement.PrepareBatching()
Statement.CreateAdapter()
Statement.Execute(DbDataAdapter, DataRow[], Batch)
Statement.SetFailed()
Statement.CommandText
Statement.LastInsertId
Statement.ServerType
Namespace: Telerik.OpenAccess.RT.sql
Assembly: Telerik.OpenAccess.Runtime.dll

Syntax

public interface PreparedStatement : Statement

Methods

clearParameters()

Declaration
void clearParameters()

DontPrepare()

Declaration
void DontPrepare()

execute(Nullable<Int32>)

Declaration
bool execute(int? commandTimeout)
Parameters
System.Nullable<System.Int32> commandTimeout

Returns
System.Boolean

executeQuery(Nullable<Int32>)

Declaration
ResultSet executeQuery(int? commandTimeout)
Parameters
System.Nullable<System.Int32> commandTimeout

Returns
ResultSet

executeUpdate(Nullable<Int32>)

Declaration
int executeUpdate(int? commandTimeout)
Parameters
System.Nullable<System.Int32> commandTimeout

Returns
System.Int32

GetCommand()

Declaration
DbCommand GetCommand()
Returns
System.Data.Common.DbCommand

GetParameter(Int32)

Declaration
DbParameter GetParameter(int i)
Parameters
System.Int32 i

Returns
System.Data.Common.DbParameter

PreparePooling()

Declaration
void PreparePooling()

ReadOutputParameter(AdoTypeConverter, ref DataHolder, DbDataReader)

Declaration
object ReadOutputParameter(AdoTypeConverter cvt, ref DataHolder data, DbDataReader reader)
Parameters
AdoTypeConverter cvt

DataHolder data

System.Data.Common.DbDataReader reader

Returns
System.Object

setBigDecimal(Int32, Nullable<Decimal>, Int32, Int32, Object)

Declaration
void setBigDecimal(int parameterIndex, decimal? x, int length, int scale, object dec)
Parameters
System.Int32 parameterIndex

System.Nullable<System.Decimal> x

System.Int32 length

System.Int32 scale

System.Object dec

setBoolean(Int32, Boolean)

Declaration
void setBoolean(int parameterIndex, bool x)
Parameters
System.Int32 parameterIndex

System.Boolean x

setByte(Int32, SByte)

Declaration
void setByte(int parameterIndex, sbyte x)
Parameters
System.Int32 parameterIndex

System.SByte x

setBytes(Int32, Byte[], Int32)

Declaration
void setBytes(int parameterIndex, byte[] x, int length)
Parameters
System.Int32 parameterIndex

System.Byte[] x

System.Int32 length

setChar(Int32, Char, Boolean)

Declaration
void setChar(int parameterIndex, char x, bool isUnicode)
Parameters
System.Int32 parameterIndex

System.Char x

System.Boolean isUnicode

setCharacterStream(Int32, StreamReader, Int32)

Declaration
void setCharacterStream(int parameterIndex, StreamReader reader, int length)
Parameters
System.Int32 parameterIndex

System.IO.StreamReader reader

System.Int32 length

setDateTime(Int32, DateTime, Int32)

Declaration
void setDateTime(int parameterIndex, DateTime x, int sqlType)
Parameters
System.Int32 parameterIndex

System.DateTime x

System.Int32 sqlType

setDouble(Int32, Double)

Declaration
void setDouble(int parameterIndex, double x)
Parameters
System.Int32 parameterIndex

System.Double x

setFloat(Int32, Single)

Declaration
void setFloat(int parameterIndex, float x)
Parameters
System.Int32 parameterIndex

System.Single x

setInt(Int32, Int32)

Declaration
void setInt(int parameterIndex, int x)
Parameters
System.Int32 parameterIndex

System.Int32 x

setLong(Int32, Int64)

Declaration
void setLong(int parameterIndex, long x)
Parameters
System.Int32 parameterIndex

System.Int64 x

setNull(Int32, Int32, String)

Declaration
void setNull(int paramIndex, int sqlType, string typeName)
Parameters
System.Int32 paramIndex

System.Int32 sqlType

System.String typeName

setObject(Int32, Object)

Declaration
void setObject(int parameterIndex, object x)
Parameters
System.Int32 parameterIndex

System.Object x

setShort(Int32, Int16)

Declaration
void setShort(int parameterIndex, short x)
Parameters
System.Int32 parameterIndex

System.Int16 x

setString(Int32, String, Boolean, Int32)

Declaration
void setString(int parameterIndex, string x, bool isUnicode, int length)
Parameters
System.Int32 parameterIndex

System.String x

System.Boolean isUnicode

System.Int32 length

setUInt64(Int32, UInt64)

Declaration
void setUInt64(int parameterIndex, ulong x)
Parameters
System.Int32 parameterIndex

System.UInt64 x

setURL(Int32, Uri)

Declaration
void setURL(int parameterIndex, Uri value_Renamed)
Parameters
System.Int32 parameterIndex

System.Uri value_Renamed

Getting Started
  • Install Now
  • Online Demos
Support Resources
  • Documentation
  • Knowledge Base
  • Videos
  • Reporting Samples Repository
  • Reporting Release History
Community
  • Forums
  • Blogs
  • Reporting Feedback Portal

Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.