Click or drag to resize

StiSqlSource Class

Describes the Data Source realizing access to Sql.
Inheritance Hierarchy

Namespace:  Stimulsoft.Report.Dictionary
Assembly:  Stimulsoft.Report (in Stimulsoft.Report.dll) Version: 2019.3.1.0
Syntax
[TypeConverterAttribute(typeof(StiSqlSourceConverter))]
public class StiSqlSource : StiDataTableSource

The StiSqlSource type exposes the following members.

Constructors
  NameDescription
Public methodStiSqlSource
Creates a new object of the type StiSqlSource.
Public methodStiSqlSource(String, String)
Creates a new object of the type StiSqlSource.
Public methodStiSqlSource(String, String, String)
Creates a new object of the type StiSqlSource.
Public methodStiSqlSource(String, String, String, String)
Creates a new object of the type StiSqlSource.
Public methodStiSqlSource(String, String, String, String, Boolean)
Initializes a new instance of the StiSqlSource class
Public methodStiSqlSource(String, String, String, String, Boolean, Boolean)
Initializes a new instance of the StiSqlSource class
Public methodStiSqlSource(String, String, String, String, Boolean, Boolean, Int32)
Initializes a new instance of the StiSqlSource class
Public methodStiSqlSource(String, String, String, String, Boolean, Boolean, Int32, String)
Initializes a new instance of the StiSqlSource class
Top
Properties
  NameDescription
Public propertyAlias
Gets or sets of the Data Source alias.
(Inherited from StiDataSource.)
Public propertyAllowExpressions
Gets or sets value which indicates that sql query of the datasource can contain script expressions or no.
Protected propertyColumnIndexes (Inherited from StiDataSource.)
Public propertyColumns
Gets or sets the column collection.
(Inherited from StiDataSource.)
Public propertyCommandTimeout
Gets or sets a number of seconds to wait while attempting to execute a command, before canceling the attempt and generate an error. Default is 30.
Public propertyComponentId (Overrides StiDataTableSourceComponentId.)
Public propertyConnectionOrder
Gets or sets value which indicates in which order that datasource will be connect to the data.
(Inherited from StiDataSource.)
Public propertyConnectOnStart
Gets or sets value which indicates that datasource not connect to the data automatically.
(Overrides StiDataSourceConnectOnStart.)
Public propertyCount
Gets count of elements.
(Inherited from StiDataSource.)
Public propertyDataAdapter
Protected propertyDataAdapterType (Inherited from StiDataSource.)
Public propertyDataTable
Gets DataTable.
(Inherited from StiDataSource.)
Protected propertyDetailRows (Inherited from StiDataSource.)
Public propertyDictionary
Gets or sets the dictionary in which this Data Source is located.
(Inherited from StiDataSource.)
Public propertyInherited (Inherited from StiDataSource.)
Public propertyIsBof
Gets value indicates that this position specifies to the beginning of data.
(Inherited from StiDataSource.)
Public propertyIsCloud
Gets or sets value which indicates that this data source is created dynamically by the Stimulsoft Reports.Server.
(Inherited from StiDataSource.)
Public propertyIsConnected
Gets value indicates which Data Source is connected with data.
(Inherited from StiDataSource.)
Public propertyIsEmpty
Gets value indicates that no data.
(Inherited from StiDataSource.)
Public propertyIsEof
Gets value indicates that this position specifies to the data end.
(Inherited from StiDataSource.)
Public propertyItem
Indexer to work with the current row of data. Returns the value by the column name and the current position in the Data Source. Indexer calls the method GetData. ColumnName - name of column.
(Inherited from StiDataSource.)
Public propertyKey
Gets or sets the key of the dictionary object.
(Inherited from StiDataSource.)
Public propertyName
Gets or sets of the Data Source name.
(Inherited from StiDataSource.)
Public propertyNameInSource
Gets or sets the name of Data Source in source of data.
(Inherited from StiDataStoreSource.)
Public propertyParameters
Gets or sets the parameter collection of the SQL query.
(Overrides StiDataSourceParameters.)
Public propertyPosition
Gets the current position.
(Inherited from StiDataSource.)
Public propertyPropName (Inherited from StiDataSource.)
Public propertyRealCount (Inherited from StiDataSource.)
Public propertyReconnectOnEachRow
Gets or sets value which indicates that datasource reconnect on each master row in master-detail reports.
Public propertyRows
Gets or sets rows collection.
(Inherited from StiDataSource.)
Protected propertyRowToLevel (Inherited from StiDataSource.)
Public propertySqlCommand
Gets or sets a SQL statement to execute at the Data Source.
Protected propertyStates
Gets the component states manager.
(Inherited from StiDataSource.)
Public propertyType
Gets or sets value which indicates type of sql datasource.
Top
Methods
  NameDescription
Public methodAddParameter
Public methodCheckColumnsIndexs
Internal use only.
(Inherited from StiDataSource.)
Public methodClearAllStates
Clear all earlier saved object states.
(Inherited from StiDataSource.)
Public methodClone
Creates a new object that is a copy of the current instance.
(Inherited from StiDataSource.)
Public methodConnect (Inherited from StiDataSource.)
Public methodConnect(Boolean) (Inherited from StiDataSource.)
Public methodConnect(StiDataCollection) (Inherited from StiDataSource.)
Public methodConnect(StiDataCollection, Boolean)
Connect Data Source to data. It is necessary to call the parent of the method(base.Connect).
(Inherited from StiDataSource.)
Public methodConvertDbTypeToType
Internal use only.
Protected methodConvertDbTypeToTypeInternal
Public methodCreateConnector
Returns new data connector for this datasource.
Public methodCreateNew (Overrides StiDataTableSourceCreateNew.)
Public methodDisconnect (Overrides StiDataSourceDisconnect.)
Public methodEquals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Public methodFetchChildRelations
Returns an enumeration of the child data relations for this data source.
(Inherited from StiDataSource.)
Public methodFetchColumns
Returns an enumeration of the data columns from this dictionary.
(Inherited from StiDataSource.)
Public methodFetchColumnValues
Returns an array of values for the specified column in the specified position.
(Inherited from StiDataSource.)
Public methodFetchParentRelations
Returns an enumeration of the parent data relations for this data source.
(Inherited from StiDataSource.)
Public methodFillColumns (Inherited from StiDataSource.)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodFirst
Sets a position at the beginning.
(Inherited from StiDataSource.)
Public methodGetCategoryName (Inherited from StiDataTableSource.)
Public methodGetChildDataSource
Returns the child Data Source by the relation name.
(Inherited from StiDataSource.)
Public methodGetChildRelations
Returns a collection of Child relations.
(Inherited from StiDataSource.)
Public methodGetColumnIndex
Returns the index of a column in the data source.
(Inherited from StiDataSource.)
Public methodGetConnection
Returns a connection to data for this data source.
(Inherited from StiDataSource.)
Public methodGetData(String)
Returns the value by the column name and the current position in the Data Source.
(Inherited from StiDataSource.)
Public methodGetData(String, Int32)
Returns the value by the column name and index of row in the Data Source.
(Inherited from StiDataSource.)
Public methodGetDataAdapter (Inherited from StiDataSource.)
Protected methodGetDataAdapterType (Overrides StiDataTableSourceGetDataAdapterType.)
Public methodGetDataTable (Inherited from StiDataSource.)
Public methodGetDataTable(Boolean)
Returns a DataTable with data from this datasource.
(Inherited from StiDataSource.)
Public methodGetDataTable(DataTable) (Inherited from StiDataSource.)
Public methodGetDictionary
Returns reference to the dictionary which contains this datasource.
(Inherited from StiDataSource.)
Public methodGetEvents (Inherited from StiDataSource.)
Public methodGetFinalSqlCommand
Public methodGetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public methodGetLevel
Returns level of data in hierarchical band.
(Inherited from StiDataSource.)
Public methodGetName (Inherited from StiDataSource.)
Public methodGetNameInSource (Inherited from StiDataSource.)
Public methodGetParameterTypesEnum
Public methodGetParentData
Returns the parent row with data for the indicated relation.
(Inherited from StiDataSource.)
Public methodGetParentDataSource
Returns the parent Data Source by the relation name.
(Inherited from StiDataSource.)
Public methodGetParentRelations
Returns the colection of Parent relations.
(Inherited from StiDataSource.)
Public methodGetProperties (Overrides StiDataStoreSourceGetProperties(IStiPropertyGrid, StiLevel).)
Public methodGetSqlFilterQuery
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected methodInvokeConnecting (Inherited from StiDataSource.)
Protected methodInvokeDisconnecting (Inherited from StiDataSource.)
Public methodLast
Sets a position on the last element.
(Inherited from StiDataSource.)
Public methodLoadFromJsonObject (Overrides StiDataStoreSourceLoadFromJsonObject(JObject).)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodNext
Sets a position on the next element.
(Inherited from StiDataSource.)
Public methodPrior
Sets a position on the previous element.
(Inherited from StiDataSource.)
Public methodResetData (Inherited from StiDataSource.)
Public methodResetDetailsRows (Inherited from StiDataSource.)
Public methodRestoreState
Restores the earlier saved object state.
(Inherited from StiDataSource.)
Public methodRetrieveData
Public methodSaveState
Saves the current state of an object.
(Inherited from StiDataSource.)
Public methodSaveToJsonObject (Overrides StiDataTableSourceSaveToJsonObject(StiJsonSaveMode).)
Public methodSetData (Inherited from StiDataSource.)
Public methodSetDetails
Set the details data for Data Source.
(Inherited from StiDataSource.)
Public methodSetFilter
Apply filter to data.
(Inherited from StiDataSource.)
Public methodSetSort
Sorts data. If data source is not able to sort data then this command is ignored.
(Inherited from StiDataSource.)
Public methodSynchronizeColumns
Synchronize list of columns with columns in datastore.
(Inherited from StiDataSource.)
Public methodToString
Returns the text view of the Data Source.
(Inherited from StiDataSource.)
Public methodToString(Boolean) (Inherited from StiDataSource.)
Public methodUpdateParameters
Top
Events
  NameDescription
Public eventConnecting (Inherited from StiDataSource.)
Public eventDisconnecting (Inherited from StiDataSource.)
Top
Fields
  NameDescription
Protected fieldisBofValue (Inherited from StiDataSource.)
Protected fieldisEofValue (Inherited from StiDataSource.)
Protected fieldpositionValue (Inherited from StiDataSource.)
Top
Extension Methods
See Also
Inheritance Hierarchy
SystemObject
  Stimulsoft.Report.DictionaryStiDataSource
    Stimulsoft.Report.DictionaryStiDataStoreSource
      Stimulsoft.Report.DictionaryStiDataTableSource
        Stimulsoft.Report.DictionaryStiSqlSource
          Stimulsoft.Report.DictionaryStiDB2Source
          Stimulsoft.Report.DictionaryStiDotConnectUniversalSource
          Stimulsoft.Report.DictionaryStiFirebirdSource
          Stimulsoft.Report.DictionaryStiInformixSource
          Stimulsoft.Report.DictionaryStiMSAccessSource
          Stimulsoft.Report.DictionaryStiMySqlSource
          Stimulsoft.Report.DictionaryStiNoSqlSource
          Stimulsoft.Report.DictionaryStiODataSource
          Stimulsoft.Report.DictionaryStiOdbcSource
          Stimulsoft.Report.DictionaryStiOleDbSource
          Stimulsoft.Report.DictionaryStiOracleSource
          Stimulsoft.Report.DictionaryStiPostgreSQLSource
          Stimulsoft.Report.DictionaryStiSqlCeSource
          Stimulsoft.Report.DictionaryStiSQLiteSource
          Stimulsoft.Report.DictionaryStiSybaseSource
          Stimulsoft.Report.DictionaryStiTeradataSource
          Stimulsoft.Report.DictionaryStiUndefinedDataSource
          Stimulsoft.Report.DictionaryStiVistaDBSource