Public Instance Methods
| Equals (inherited from Object) | Select the method name to go to the Microsoft documentation. |
| GetHashCode (inherited from Object) | Select the method name to go to the Microsoft documentation. |
| GetType (inherited from Object) | Select the method name to go to the Microsoft documentation. |
| ToString (inherited from Object) | Select the method name to go to the Microsoft documentation. |
Protected Instance Constructors
Protected Instance Fields
| deleteParams |
Gets/Sets the spl parameters in an array. The parameters are used to delete fields in the database
|
| insertParams |
Gets/Sets the spl parameters in an array. The parameters are used to insert fields in the database
|
| updateParams |
Gets/Sets the spl parameters in an array. The parameters are used to update fields in the database
|
Protected Instance Properties
| Adapter (inherited from SqlDataAccess) |
Gets/Sets the System.Data.SqlClient.SqlDataAdapter |
| CmdType (inherited from SqlDataAccess) |
Gets/Sets the System.Data.CommandType for the Connection |
| ColumnIndex (inherited from SqlDataAccess) |
Gets/Sets the column index in the dataset to which you want to read the value
|
| ColumnName (inherited from SqlDataAccess) |
Gets/Sets the column name in the dataset to which you want to read the value
|
| Command (inherited from SqlDataAccess) |
Gets/Sets the sql command
|
| Connection (inherited from SqlDataAccess) |
Holds the sql connection.
|
| ConnectionString (inherited from SqlDataAccess) |
Holds the the connection string
|
| DataSetToUse (inherited from SqlDataAccess) |
Gets/Sets the the dataset to fill/update according to SelectString.
|
| DeleteString |
Gets/Sets the the update string. Used when you want to specify the sql statement or stored procedure.
|
| InsertString |
Gets/Sets the the insert string. Used when you want to specify the sql statement or stored procedure.
|
| SelectString (inherited from SqlDataAccess) |
Gets/Sets the the selection string
|
| SourceTable (inherited from SqlDataAccess) |
Gets/Sets the the source table string
|
| UpdateString |
Gets/Sets the the update string. Used when you want to specify the sql statement or stored procedure.
|
Protected Instance Methods
| Clear (inherited from SqlDataAccess) |
Clear all variables and objects
|
| Finalize (inherited from Object) | Select the method name to go to the Microsoft documentation. |
| MemberwiseClone (inherited from Object) | Select the method name to go to the Microsoft documentation. |
| Update | Overloaded.
Updates the database wiht the changes made to the dataset. Remember to have had set the selectstring.
One limitation is that you only can insert/update/delete the first table in the dataset due to
the limitation of the object sql command builder.
|
See Also
Adapter Class | Magnusson.Data.SqlClient Namespace