C#

Vuyiswa Maseko wrote:

My SP Returns "0", if there is no Role Found.

if(System.Convert.IsDBNull(cmdselect.Parameters["@Role"].Value))
{
     Results = 0;
}
else
{
     Results = (int) cmdselect.Parameters["@Role"].Value;
}

Christian Graus wrote:

We don't do homework. Because, if we did, you would not learn and then we'd have to teach you on the job some day, or just do your work to meet our deadlines.

Epoque wrote:

Is it possible?

enum MyEnum { None=0, Few=1, Some=2, Many=4, CrapLoad=8, All=128};

public static T IntToEnum < t > (int value, T defaultValue)
{
	T enumValue = (Enum.IsDefined(typeof(T), value)) ? (T)(object)value : defaultValue;
	return enumValue;
}

//Usage:

// Given the value of x, IntToEnum would return MyEnum.All because there 
// is no ordinal with the value of x.
int x = 3;
MyEnum myEnum = IntToEnum < MyEnum > (x, MyEnum.All);

// Given the value of x, IntToEnum would return MyEnum.Many because there 
// *is* an ordinal with the value of x.
x = 4;
myEnum = IntToEnum < MyEnum > (x, MyEnum.All);