public static SqlDataReader GetDataReader(SelectHelper selectHelper, string connectionStr = "") { SqlDataReader dataReader; using (SqlCommand sqlCmd = CreateSqlCmd(selectHelper.Sql, selectHelper.SqlParameters,connectionStr)) { dataReader = sqlCmd.ExecuteReader(); } return dataReader; }
public static int GetRecordCount(SelectHelper selectHelper, string connectionStr = "") { using (SqlCommand sqlCmd = CreateSqlCmd(selectHelper.Sql, selectHelper.SqlParameters,connectionStr)) { object obj = sqlCmd.ExecuteScalar(); return obj.ToInt(); } }
public static DataTable GetDataTable(SelectHelper selectHelper, string connectionStr = "") { DataTable dt = new DataTable(); using (SqlCommand sqlCmd = CreateSqlCmd(selectHelper.Sql, selectHelper.SqlParameters,connectionStr)) { using (SqlDataAdapter dataAdapter = new SqlDataAdapter(sqlCmd)) { dataAdapter.Fill(dt); } return dt; } }