lol, ok thanks guys. Yeah I am still learning the ropes, i'll check out some stuff for stored procedures...any recommended references?
On Sat, Nov 22, 2008 at 12:51 PM, Paul <[EMAIL PROTECTED]> wrote: > You're welcome. Have a scuedo[sic] nice day and if you seek SQL advice, try > a SQL group. > > > On Sat, Nov 22, 2008 at 1: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<http://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 <http://vb.net/>, C# .NET, >> > > ADO.NET<http://ado.net/>, >> ASP.NET <http://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 - > > > > > -- > _______________________________ > > Take care, > Paul > > It is not we non-interventionists who are isolationists. The real > isolationists are those who impose sanctions and embargos on countries and > peoples across the globe and who choose to use force overseas to promote > democracy. A counterproductive approach that actually leads the U.S. to be > more resented and more isolated in the world. > > Dr. Ron Paul > > www.RonPaul2008.com >
