Author: sheraz_aries | Posted on: 10/4/2010 9:45:06 AM | Views : 863

I am using .net membership properties that uses aspnet_Profile tbl to store property name in column PropertyNames and their values in PropertyValuesString with semicolon delimiter so that
UserId PropertyNames PropertyValuesString 9F2B0B68-2E0B-4640-B9A9-8BDBC52385C7 imageORavatar:S:0:1:Title:S:1:2:FirstName:S:3:5:Avatar:S:8:10:AboutMe:S:18:4:LastName:S:22:5:Company:S:27:4:AcceptMailUs:S:31:5:Newsletter:S:36:4:AcceptMailOthers:S:40:5:Address:S:45:3: 2mruser5Winter.jpgewwruser5testFalseTrueFalsenil No i want to write an Update query that update the propertyAvatar against Userid but dont know how to write it, Any help would be really appreciated.



...

Go to the complete details ...