that was "pseudo stored procedure"
On Nov 22, 11:51 pm, sallushan <[EMAIL PROTECTED]> wrote: > The procedure coding I have provided is NOT vb.net. It is actually a > "scuedo stored procedure". > > It seems to me that you are NOT familiar with Stored Procedures. > Stored Procedures (SPs) are written in SQL Server Database. We call it > from our Application. There is lots of stuff out there regarding > stored procedures you can search out. Simply we combine one or more > SQL Statments in a Stored Procedure. > > Your rest of the stuff is related to Web which I think a Web Expert > can carry out. I am a Desktop guy :) > > On Nov 22, 7:53 pm, "Jon Liu" <[EMAIL PROTECTED]> wrote: > > > > > 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- Hide quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text -
