C# (CSharp) SqlHelper2.ExecuteReader Examples

Example #1

 public static SqlDataReader Select(SqlTransaction trans, string sql, params SqlParameter[] parms)
 {
     return(SqlHelper2.ExecuteReader(trans, CommandType.Text, sql, parms));
 }

Example #2

 public static SqlDataReader Select(SqlTransaction trans, string procName, params SqlParameter[] parms)
 {
     return(SqlHelper2.ExecuteReader(trans, CommandType.StoredProcedure, procName, parms));
 }

Example #3

 public static SqlDataReader Select(SqlConnection conn, string sql, params SqlParameter[] parms)
 {
     return(SqlHelper2.ExecuteReader(conn, CommandType.Text, sql, parms));
 }

Example #4

 public static SqlDataReader Select(string procName, params SqlParameter[] parms)
 {
     return(SqlHelper2.ExecuteReader(connStr, CommandType.StoredProcedure, procName, parms));
 }