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 ...