Thanks for the quick reply. It looks like you're using VB.NET. I'm using C#...off topic, but is there anyway to create a stored procedure in C# using the actual Stored Procedure features under Database Explorer, of does it have to be done in the .cs file? The reason I ask is because I already have my connection to the table established using the SqlDataSource control as well as connection string defined in the config file, and it would be much easier to just define the query and conditions in the Database Explorer version as opposed to typing it all out in C#.....
If so/if not, does anyone know any good reference tools for creating stored procedures with SQL and C#? Thanks. Jon On Sat, Nov 22, 2008 at 6:43 AM, Stephen Russell <[EMAIL PROTECTED]>wrote: > > You could just put the month/date as an appendage instead of a counter. Or > just the Second of the time stamp. > > In all reality how many times would a filename be uploaded? > > You might consider breaking down the container for holding the files into > sub folders. This way the same camera file name won't be consistent in a > sub folder. > > I never run into this issue because I organize the holding folder(s). I > use > GUIDs for the primary key of the table. I then break the guid along breaks > of every dash -. So > d5348cfb-e077-45d2-9254-231076ead3b8 would look like this: > \d5348cfb\e077\ I will now have maybe 2 files in this folder, usually only > 1. > > I made the GUID at receipt of file, I then declare if folder exists or not. > Make if needed and then use that path for the path section of my file > table. > This way the USERS property never changes names according to them. I have > a > time date stamp in the table as well so the user would be shown the most > recent version of their file if that was important to them. > > > ......................... > Stephen Russell - > Senior Visual Studio Developer, DBA > > Memphis, TN > 901.246-0159 > > > > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of BigJ > Sent: Friday, November 21, 2008 10:19 PM > To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web > Services,.NET Remoting > Subject: [DotNetDevelopment] Image Upload > > > I'm using the FileUpload control to upload images to my image folder, > storing the pathway to the image in table. My primary key is the > imagePath column My question is, how do you detect if an image > already exists in the table, and if so how to alter the name like > image/mypic.jpg and image/mpic(2).jpg , so on and so forth. > > I came up with the initial idea of adding an imageCnt column > (equivalent of a counter) using the SqlDataSource control to get the > latest version of the image like so: > > SelectCommand="SELECT MAX(ImageCnt) FROM userImages WHERE > ImagePath LIKE @ImagePath" > > I was going to then the result of that to decide what number to append > to the image. However the problem is how do I grab that ImageCnt > value before the insert action is attempted? Any insight is > appreciated...thanks. > > Thanks > > Jon > > No virus found in this incoming message. > Checked by AVG - http://www.avg.com > Version: 8.0.175 / Virus Database: 270.9.9/1802 - Release Date: 11/21/2008 > 9:37 AM > > >
