String problem

[michaelkrauklis]

I'm having a problem; I'm getting an Invalid Cast exception thrown when I try to add strings. Here's the code:

string user="SELECT Password FROM InternalUserPwd where UserName = '"+usr+"'";
if(checktype)
{
	user+=" and UserType = " + type.ToString();
	user+=" and RoleID = " + ((int)type).ToString();

Now the second statement, where I have

<user+=&quot; and RoleID = &quot; + ((int)type).ToString();>

works, but the first += does not. At this particular point even if I simplify the code to just a concatonation of a string it doesn't work unless I have the

<((int)type).ToString();>

statement (eg. the code

<user+=&quot;some string&quot;;>

fails). This just doesn't make sense to me. The += isn't the problem either because the code

<user=user+&quot;some string&quot;;>

fails as well. It might help that type is an enumerated type, hence the casting to int, but if I just do a straight

<Console.WriteLine(type.ToString());>

it prints out the correct value in string format. Whaaa? MYenigmaSELF:-9
myenigmaself@myenigmaself.gaiden.com

http://myenigmaself.gaiden.com

"If debugging is the process of removing bugs, then programming must be the process of putting them in." --Dykstra

 

[chiph]

What happens when you do this?

Console.WriteLine(((int)type).ToString());

Chip H.