C# Developeramp;#039;s Guide to ASP.NET, XML, and ADO.NET [Electronic resources] نسخه متنی

اینجــــا یک کتابخانه دیجیتالی است

با بیش از 100000 منبع الکترونیکی رایگان به زبان فارسی ، عربی و انگلیسی

C# Developeramp;#039;s Guide to ASP.NET, XML, and ADO.NET [Electronic resources] - نسخه متنی

Jeffrey P. McManus; Chris Kinsman

| نمايش فراداده ، افزودن یک نقد و بررسی
افزودن به کتابخانه شخصی
ارسال به دوستان
جستجو در متن کتاب
بیشتر
تنظیمات قلم

فونت

اندازه قلم

+ - پیش فرض

حالت نمایش

روز نیمروز شب
جستجو در لغت نامه
بیشتر
لیست موضوعات
توضیحات
افزودن یادداشت جدید








ADO.NET Framework Reference


This section contains a brief reference to the ADO.NET objects mentioned in this chapter. It is not designed to be an exhaustive reference. For complete descriptions, including information on the objects not discussed in this chapter, refer to the .NET framework SDK documentation.

DataAdapter Class


Member of System.Data.Common. Abstract class. Inherits from System.ComponentModel.Component.

The DataAdapter class serves as the base class for data adapter implementations in the SQL Server, OLE DB (and potentially other) data providers in ADO.NET.

Note that this is not the class you instantiate when you want to access data in ADO.NET; to write data-access code using a data adapter in your applications, use the OleDbDataAdapter, SqlDataAdapter, or other provider-specific data adapter class.































































Properties
AcceptChangesDuringFill
DesignMode
MissingSchemaAction
Container
Events
Site
ContinueUpdateOnError
MissingMappingAction
TableMappings
Methods
CloneInternals
FillSchema
GetType
CreateObjRef
Finalize
InitializeLifetimeService
CreateTableMappings
GetFillParameters
MemberwiseClone
Dispose
GetHashCode
ShouldSerializeTableMappings
Equals
GetLifetimeService
ToString
Fill
GetService
Update
Events
Disposed

DataSet Class


Member of System.Data. Inherits from System.ComponentModel.MarshalByValueComponent.

Note that the DataSet class is not owned by any particular provider; any ADO.NET data provider is capable of creating a DataSet object, and DataSet objects should interoperate across providers.


































































































Properties
CaseSensitive
EnforceConstraints
Namespace
Container
Events
Prefix
DataSetName
ExtendedProperties
Relations
DefaultViewManager
HasErrors
Site
DesignMode
Locale
Tables
Methods
AcceptChanges
GetXml
ReadXmlSchema
Clear
GetXmlSchema
RejectChanges
Clone
HasChanges
Reset
Copy
InferXmlSchema
ResetTables
Dispose
MemberwiseClone
ShouldSerializeRelations
Equals
Merge
ShouldSerializeTables
Finalize
OnPropertyChanging
ToString
GetChanges
OnRemoveRelation
WriteXml
GetHashCode
OnRemoveTable
WriteXmlSchema
GetService
RaisePropertyChanging
GetType
ReadXml
Events
Disposed
MergeFailed

DataColumn Class


Member of System.Data. Inherits System.ComponentModel.MarshalByValueComponent.

The DataColumn object represents the structure, or schema, of data in a DataTable object. You use the DataColumn object to determine information about the structure of the field (not the data it contains).

This object is contained by the DataSet object and is therefore not provider specific.














































































Properties
AllowDBNull
DataType
Ordinal
AutoIncrememt
DefaultValue
Prefix
AutoIncrementSeed
DesignMode
ReadOnly
AutoIncrementStep
Events
Site
Caption
Expression
Table
ColumnMapping
ExtendedProperties
Unique
ColumnName
MaxLength
Container
Namespace
Methods
Dispose
GetHashCode
OnPropertyChanging
Dispose
GetService
RaisePropertyChanging
Equals
GetType
ToString
Finalize
MemberwiseClone
Events
Disposed

DataRelation Class


Member of System.Data.

The DataRelation object is used to denote the relationship between two DataTable objects.


















































Properties
AllowDBNull
DataType
Ordinal
ChildColumns
ExtendedProperties
ParentTable
ChildKeyConstraint
Nested
RelationName
ChildTable
ParentColumns
DataSet
ParentKeyConstraint
Methods
CheckStateForProperty
GetHashCode
ToString
Equals
GetType
Finalize
MemberwiseClone

DataTable Class


Member of System.Data.

The DataTable object represents a unit of data arranged as collections of rows and columns. It is contained by the DataSet object and is not provider specific.



























































































































Properties
CaseSensitive
DesignMode
Namespace
ChildRelations
DisplayExpression
ParentRelations
Columns
Events
Prefix
Constraints
ExtendedProperties
PrimaryKey
Container
HasErrors
Rows
DataSet
Locale
Site
DefaultView
MinimumCapacity
TableName
Methods
AcceptChanges
Finalize
OnColumnChanged
BeginInit
GetChanges
OnColumnChanging
BeginLoadData
GetErrors
OnPropertyChanging
Clear
GetHashCode
OnRemoveColumn
Clone
OnRowChanged
Compute
GetService
OnRowChanging
Copy
GetType
OnRowDeleted
Dispose
ImportRow
OnRowDeleting
Dispose
LoadDataRow
RejectChanges
EndInit
MemberwiseClone
Reset
EndLoadData
NewRow
Select
Equals
NewRowFromBuilder
ToString
Events
ColumnChanged
RowChanged
RowDeleting
ColumnChanging
RowChanging
Disposed
RowDeleted

OleDbCommand Class


Member of System.Data.OleDb. Inherits from System.Component.Component.

The OleDbCommand object is used to execute commands (including queries and such operations as data manipulation commands) against a data source.









































































Properties
CommandText
Container
Parameters
CommandTimeout
DesignMode
Site
CommandType
DesignTimeVisible
Transaction
Connection
Events
UpdatedRowSource
Methods
Cancel
ExecuteScalar
InitializeLifetimeService
CreateobjRef
Finalize
MemberwiseClone
CreateParameter
GetHashCode
Prepare
Dispose
GetLifetimeService
ResetCommandTimeout
Equals
GetService
ToString
ExecuteNonQuery
GetType
ExecuteReader
Events
Disposed

SqlDataAdapter Class


Member of System.Data.SqlClient. Inherits from System.Data.DataAdapter.

The SqlDataAdapter object is used primarily to create DataSet objects in the SQL Servermanaged provider. In thick client context, the data adapter can also be used to provide cursorless navigation, filtering, creation, deletion, and updating of data. The OLE DB equivalent is System.Data.OleDb.OleDbDataAdapter.


































































































Properties
AcceptChangesDuringFill
Events
Site
Container
InsertCommand
TableMappings
ContinueUpdateOnError
MissingMappingAction
UpdateCommand
DeleteCommand
MissingSchemaAction
DesignMode
SelectCommand
Methods
CloneInternals
InitializeLifetimeService
CreateObjRef
MemberwiseClone
CreateRowUpdatedEvent
FillSchema
OnFillError
CreateRowUpdatingEvent
Finalize
OnRowUpdated
CreateTableMappings
GetFillParameters
OnRowUpdating
Dispose
GetHashCode
ShouldSerializeTableMappings
GetLifetimeService
ToString
Equals
GetService
Fill
GetType
Update
Events
AllowDBNull
DataType
Ordinal
Disposed
RowUpdated
FillError
RowUpdating

SqlDataReader Class


Member of System.Data.SqlClient. Inherits System.MarshalByRefObject.

The SqlDataReader object enables connection-based, fast access to data in the SQL Servermanaged provider. The OLE DB equivalent to this object is System.Data.OleDb.OleDbDataReader.









































































































Properties
Depth
IsClosed
RecordsAffected
FieldCount
Item
Methods
Close
GetInt16
GetSqlInt64
CreateObjRef
GetInt32
GetSqlMoney
Equals
GetInt64
GetSqlSingle
Finalize
GetLifetimeService
GetSqlString
GetBoolean
GetName
GetSqlValue
GetByte
GetOrdinal
GetSqlValues
GetBytes
GetSchemaTable
GetString
GetChar
GetSqlBinary
GetType
GetChars
GetValue
GetDataTypeName
GetSqlBoolean
GetValues
GetDateTime
GetSqlByte
IntializeLifetimeService
GetDecimal
GetSqlDateTime
IsDBNull
GetDouble
GetSqlDecimal
MemberwiseClone
GetFieldType
GetSqlDouble
NextResult
GetFloat
GetSqlGuid
Read
GetGuid
GetSqlInt16
ToString
GetHashCode
GetSqlInt32

SqlConnection Class


Member of System.Data.SqlClient.

The SqlConnection object is used to create and maintain a connection to a data source in the SQL Servermanaged provider. Its OLE DB provider equivalent is System.Data.OleDb.OleDbConnection.




































































Properties
ConnectionString
DataSource
ServerVersion
ConnectionTimeout
DesignMode
Site
Container
Events
State
Database
PacketSize
WorkstationId
Methods
BeginTransaction
Equals
InitializeLifetimeService
ChangeDatabase
Finalize
MemberwiseClone
Close
GetHashCode
Open
CreateCommand
GetLifetimeService
ToString
CreateObjRef
GetService
Dispose
GetType
Events
Disposed
InfoMessage
StateChange

SqlError Class


Member of System.Data.SqlClient.

The SqlError object is found in the Errors collection contained by the SqlException object. It is designed to provide SQL Serverspecific error information. Its OLE DB provider equivalent is the OleDbError class.

Note that this object (and the SqlException object that contains it) is available only when you use the SQL Servermanaged provider.



































Properties
Class
Number
Source
LineNumber
Procedure
State
Message
Server
Methods
Equals
GetHashCode
MemberwiseClone
Finalize
GetType
ToString

SqlException Class


Member of System.Data.SqlClient. Inherits from System.Exception.

The SqlException object is the object thrown when an error occurs in the ADO.NET SQL Servermanaged provider. This object contains a collection of SqlError objects that you can use to get detailed information on exactly what caused the data-access error.

The equivalent to this class in the OLE DB provider is the OleDbException class.

This object is typically caught in an exception handler rather than constructed.


















































Properties
Class
LineNumber
Source
Errors
Message
StackTrace
HelpLink
Number
State
Hresult
Procedure
TargetSite
InnerException
Server
Methods
Equals
GetHashCode
MemberwiseClone
Finalize
GetObjectData
ToString
GetBaseException
GetType


/ 106