i believe this is a simple question but i can't figure out myself. In the aspnet profile there is propertynames column with value [va开发者_如何学Golue]::: (e.g. OfficeKey:S:0:1:)
Does anyone know what the ":S:0:1:" is? How can I read it?
thanks
It means it's a String, which starts at position 0 in the PropertyValuesString field, and is 1 character long.
Have a read of http://pretzelsteelersfan.blogspot.com/2007/03/get-aspnet-profile-properties-from-sql.html if you want to do your own manipulation of the fields in SQL.
精彩评论