Posted on: 5/23/2011 9:30:38 AM | Views : 1127

Hello techies,Before telling my problem, i need to explain the scenario im running into. I'm having an asp.net site, where in my users can upload attachments. As the size & quantity of attachments we are expecting are high, we haven't preferred to go with saving Attachments in SQL server (some one suggested in the google..). So, now we are saving all our attachments in file system it self and storing the name of the file in SQL table. Now the problem is, to avoid duplicate attachments (uploaded by multiple users), we are generating an unique number (combination of AlphaNumerics) and attaching it before the Filename (Ex: if foo.doc is uploaded by user, it will get saved as some thing like A931GT_foo.doc). I hope this is what every one will follow. To show the attachment to users, though we are showing actual file name as a link (from DB), but the use ...

Go to the complete details ...