Casting Error

[Jay1b]

I'm trying to call a stored procedure, but i dont think it actually gets that far (thats why its not in the database section). With the following code i get returned the following error :

 

"Invalid cast from 'System.String' to 'System.Guid'. "

 

           Dim cmUpdateUser As New SqlCommand("dbo.up_MaintainUsers", conn)

           cmUpdateUser.CommandType = CommandType.StoredProcedure
           conn.Open()

           With cmUpdateUser.Parameters
               .Add("UserID", SqlDbType.UniqueIdentifier).Value = strUserID
               .Add("Username", SqlDbType.NVarChar, 15).Value = strUserName
               .Add("FirstName", SqlDbType.NVarChar, 15).Value = strFirstName
               .Add("Surname", SqlDbType.NVarChar, 15).Value = strSurname
               .Add("Email", SqlDbType.NVarChar, 15).Value = strSurname + "@intier.com"
               .Add("RoleName", SqlDbType.NVarChar, 15).Value = strRole
               .Add("Department", SqlDbType.NVarChar, 15).Value = strDepartment
               .Add("AuthorisationLimit", SqlDbType.SmallInt).Value = intAuthLimit
           End With

           'Execute the command checking the returned result
           Dim ReturnResult As Integer = cmUpdateUser.ExecuteNonQuery()

 

Whilst debugging this is the line that raises the problem.

 

Dim ReturnResult As Integer = cmUpdateUser.ExecuteNonQuery()

 

However i'm guessing it has something to do with this line, as its the only one that fits the error message.

 

               .Add("UserID", SqlDbType.UniqueIdentifier).Value = strUserID

 

Could someone please tell me whether you can put a string into a uniqueidentifier like this? If not how would i do it? Or does the error look like it originated from elsewhere?

 

Thanks

[PlausiblyDamp]

Try

.Add("UserID", SqlDbType.UniqueIdentifier).Value = new Guid(strUserID )

[Jay1b]

Thanks your a genius :)