write one more select statement like 'select Id from tblUsers where CODe = strCode'...that will return you ID...and then you can use ExecuteScalar to catch the ID in C# - http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executescalar.aspx 

Thanks,