Method | Description | |
---|---|---|
ExecuteDataTable ( string storedProcedureName ) : |
Executes a SQL stored procedure, returning the results as a SqlDataReader.
|
|
ExecuteNonQuery ( string storedProcedureName ) : void |
Executes a SQL stored procedure without returning any value.
|
|
ExecuteReader ( string storedProcedureName ) : System.Data.SqlClient.SqlDataReader |
Executes a SQL stored procedure, returning the results as a SqlDataReader.
|
|
ExecuteScalar ( string storedProcedureName ) : object |
Executes a SQL stored procedure, returning a single value.
|
Method | Description | |
---|---|---|
SqlDataProvider ( ) : System |
Prevents a default instance of the SqlDataProvider class from being created.
|
public ExecuteDataTable ( string storedProcedureName ) : |
||
storedProcedureName | string | Name of the stored procedure. Does not include any prefix, for example "GetAppointment" is translated to "dnn_EngageBooking_spGetAppointment." |
return |
public ExecuteNonQuery ( string storedProcedureName ) : void | ||
storedProcedureName | string | Name of the stored procedure. Does not include any prefix, for example "InsertAppointment" is translated to "dnn_EngageBooking_spInsertAppointment." |
return | void |
public ExecuteReader ( string storedProcedureName ) : System.Data.SqlClient.SqlDataReader | ||
storedProcedureName | string | Name of the stored procedure. Does not include any prefix, for example "GetAppointment" is translated to "dnn_EngageBooking_spGetAppointment." |
return | System.Data.SqlClient.SqlDataReader |
public ExecuteScalar ( string storedProcedureName ) : object | ||
storedProcedureName | string | Name of the stored procedure. Does not include any prefix, for example "InsertAppointment" is translated to "dnn_EngageBooking_spInsertAppointment." |
return | object |