C# (CSharp) Data SqlHelper.ExecuteScalar Examples

Example #1

 public object GetUserRole(int userId)
 {
     return(SqlHelper.ExecuteScalar("select RoleId from SJUserRole where UserId=@UserId order by RoleId", new SqlParameter[] { new SqlParameter("@UserId", userId) }));
 }