메소드 | 설명 | |
---|---|---|
ExecuteDataset ( string connectionString, string sql ) : |
||
ExecuteNonQuery ( IDbCommand command ) : int | ||
GetCommand ( string connectionString, string spName ) : IDbCommand | ||
GetConnection ( string connectionString ) : IDbConnection | ||
GetSQLDataType ( string sqlTypeString ) : SqlDbType | ||
SetParameterValue ( IDbCommand command, string paramName, object inValue ) : void | ||
TestConnectionString ( string connectString ) : bool |
메소드 | 설명 | |
---|---|---|
DatabaseHelper ( ) : System | ||
ExecuteDataset ( string connectionString, string storedProcedureName, |
||
ExecuteNonQuery ( string connectionString, string storedProcedureName, |
||
ExecuteReader ( IDbCommand selectCommand ) : System.Data.SqlClient.SqlDataReader | ||
ExecuteReader ( IDbConnection connection, CommandType cmdType, string stmt ) : System.Data.SqlClient.SqlDataReader | ||
ExecuteReader ( string connectString, CommandType cmdType, string stmt ) : System.Data.SqlClient.SqlDataReader | ||
Fill ( IDbDataAdapter da, |
||
GetCommand ( ) : IDbCommand | ||
GetDataAdapter ( ) : IDbDataAdapter | ||
GetSQLDataType ( SqlNativeTypes nativeType ) : SqlDbType | ||
SetConnections ( IDbDataAdapter da, IDbConnection conn ) : void | ||
SetTransaction ( IDbDataAdapter da, IDbTransaction trans ) : void | ||
Update ( IDbDataAdapter da, |
||
Update ( IDbDataAdapter da, |
public static ExecuteDataset ( string connectionString, string sql ) : |
||
connectionString | string | |
sql | string | |
리턴 |
public static ExecuteNonQuery ( IDbCommand command ) : int | ||
command | IDbCommand | |
리턴 | int |
public static GetCommand ( string connectionString, string spName ) : IDbCommand | ||
connectionString | string | |
spName | string | |
리턴 | IDbCommand |
public static GetConnection ( string connectionString ) : IDbConnection | ||
connectionString | string | |
리턴 | IDbConnection |
public static GetSQLDataType ( string sqlTypeString ) : SqlDbType | ||
sqlTypeString | string | |
리턴 | SqlDbType |
public static SetParameterValue ( IDbCommand command, string paramName, object inValue ) : void | ||
command | IDbCommand | |
paramName | string | |
inValue | object | |
리턴 | void |
public static TestConnectionString ( string connectString ) : bool | ||
connectString | string | |
리턴 | bool |