Hi,

I'm the guy having problems adding parameters to my SP.

I tried out:
command.Parameters.Add(new SqlParameter("@role", SqlDbType.Int).Value= 0);
and get error:
The SqlParameterCollection only accepts non-null SqlParameter type objects, not String objects. 

Tried to google it and couldn't find anything.  This one doesn't make sense.

SqlDbType is an enumeration, and ".Int" is one of them.  I would try breaking this up - creat the parameter, type and direction , then assign the .Value=0 later.

Only other thing I can think of is you may be calling the wrong execute method of your Command object - ExecuteNonQuery instead of ExecuteScalar, for instance. Stuff like this has been known to generate unusual exception messages.

this is an approach that takes care of it:

SqlParameter parm1 = new SqlParameter("@Beginning_Date",SqlDbType.DateTime );
						
parm1.Value = myDateTimeVariable;

command.Parameters.add(parm1);