SqlHelper Constructor(DbProvider,CommandType,String)
The specific DbProvider instance that this instance of SqlHelper should use when performing database operations
The CommandType this instance of SqlHelper should use when executing the cmdTxt statement.
The text command to execute. The default value is an empty string ("").
Creates a new instance of SqlHelper with the specified DbProvider instance, CommandType and command text (SQL statement)
Syntax
'Declaration
Public Function New( _
ByVal _dataProvider_ As DbProvider, _
ByVal _inCmdType_ As CommandType, _
ByVal _cmdTxt_ As String _
)
public SqlHelper(
DbProvider _dataProvider_,
CommandType _inCmdType_,
string _cmdTxt_
)
Parameters
dataProvider
The specific DbProvider instance that this instance of SqlHelper should use when performing database operations
inCmdType
The CommandType this instance of SqlHelper should use when executing the cmdTxt statement.
cmdTxt
The text command to execute. The default value is an empty string ("").
Remarks
When the inCmdType parameter is set to StoredProcedure, set the cmdTxt parameter to the name of the stored procedure. The user may be required to use escape character syntax if the stored procedure name contains any special characters. The command will call this stored procedure when you call one of the Execute methods.
Requirements
Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server family