tag:blogger.com,1999:blog-1664217632350055880.post2465533286377116597..comments2011-08-28T06:12:34.163-06:00Michael Murrayhttps://profiles.google.com/109073345657761090655noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-1664217632350055880.post-67915720530403066392011-08-28T06:12:34.163-06:002011-08-28T06:12:34.163-06:00perfect, thank you very much...mamalihttp://www.blogger.com/profile/01512730645176833830noreply@blogger.comtag:blogger.com,1999:blog-1664217632350055880.post-57815073306271699262010-05-23T02:11:11.596-06:002010-05-23T02:11:11.596-06:00I&#39;ve been using the profile system with good results, but in the last couple of weeks, I must have made some change because now I&#39;m getting the error: &quot;Column name &#39;UserID&#39; appears more than once in the result column list.&quot; I can see the SQL command that&#39;s generated in SqlTableProfileProvider.vb, and it indeed contains two columns with name UserID. The problem is, I&#39;m unable to find the source of the second UserID column. What can I do to trace and resolve the problem?Bryannoreply@blogger.comtag:blogger.com,1999:blog-1664217632350055880.post-27914609479693151342009-09-18T17:00:26.929-06:002009-09-18T17:00:26.929-06:00@Shalan &amp; Mike:<br /><br />I&#39;d just store the photo on a file server, and then just store a UNC path to the photo on the custom profile table.<br /><br />That way, all you&#39;d have to do is: read the path, load the photo &amp; display it.<br /><br />Hope this helps!Esteban Arayahttp://www.blogger.com/profile/07645289431023957896noreply@blogger.comtag:blogger.com,1999:blog-1664217632350055880.post-80654046585558318082009-05-07T08:35:00.000-06:002009-05-07T08:35:00.000-06:00Ya know, I&#39;m not really sure. But I am wondering if I&#39;ve got something that might lead to an answer. I&#39;m looking at the examples in my blog post and notice the Guid field. In order for that data type to work, it had to be specified as System.Guid, I&#39;m assuming because it&#39;s not a primitive type. Perhaps something similar has to be done, like System.Array or System.Array&lt;Byte&gt;...not really sure. The other thing I can think of is maybe using the primitive version of &quot;byte&quot; instead of &quot;Byte&quot;.<br /><br />Just a few random guesses. Let us know if you find the resolution and post back here. Thanks!Mike Murrayhttp://www.blogger.com/profile/01990150469958605173noreply@blogger.comtag:blogger.com,1999:blog-1664217632350055880.post-27223927202093747682009-05-05T15:04:00.000-06:002009-05-05T15:04:00.000-06:00Hi Mike. Excellent article! I've been using TableProvider for some time now, but recently I had a first case where the user wanted to incorporated photos as part of their profile.<br /><br />I have tried to accomplish but to no avail. Its setup as a varbinary field in the database, and a Byte[] datatype in the web.config, but I keep getting an error saying that it could not load type "Byte[]". Have you tried this? Do you have any suggestions?<br /><br />Thanx!shalannoreply@blogger.comtag:blogger.com,1999:blog-1664217632350055880.post-35737576514402206152009-04-06T09:53:00.000-06:002009-04-06T09:53:00.000-06:00Very good question.<BR/><BR/>In my particular use case, the need to delete a user account from the system would be so rare that I am content to leave it a manual process. And since I'll be the one managing it for a while, I'm content with this solution for the time being.<BR/><BR/>I will give this question some thought, however, and I will post back if come up with an idea or two...that is if someone else doesn't beat me to it here in the comments.<BR/><BR/>Please do let us know if you come up with something yourself. Thanks, and good luck.Mike Murrayhttp://www.blogger.com/profile/01990150469958605173noreply@blogger.comtag:blogger.com,1999:blog-1664217632350055880.post-59310911178245309272009-04-02T14:48:00.000-06:002009-04-02T14:48:00.000-06:00Has anybody came up with a way to automatically delete custom profile table along with the rest of the membership information?Anonymousnoreply@blogger.com