just joking. thanks for the help....but c sharp would be nice...=) On Sun, Nov 23, 2008 at 1:18 AM, Jon Liu <[EMAIL PROTECTED]> wrote:
> OH COME ON!!!!!!!! VB.NET???? WHERE'S THE C SHARP AT???? > > > On Sat, Nov 22, 2008 at 6:15 PM, Paul <[EMAIL PROTECTED]> wrote: > >> Here is a link. >> >> http://www.devx.com/vb2themax/Tip/18595 >> >> HTH >> >> On Sat, Nov 22, 2008 at 5:31 PM, Stephen Russell <[EMAIL PROTECTED]>wrote: >> >>> In C# >>> >>> Guid myGuid = new Guid.NewGuid(); >>> >>> >>> >>> This will give you a value in your myGuid instead of >>> 00000-0000-0000-000000 with Guid myOtherGuid = new Guid(); >>> >>> >>> >>> The Guid is your friend for your identifiers. I use to think that int >>> with an auto increment was fine but NOOOOOOOOOO! When your movide meta data >>> between dev, test, stage and prod that int will bite you! The GUID never >>> will. >>> >>> >>> >>> ………………………………………………………………… >>> >>> Stephen Russell – >>> >>> Senior Visual Studio Developer, DBA >>> >>> >>> >>> Memphis, TN >>> >>> 901.246-0159 >>> >>> >>> >>> >>> >>> *From:* [email protected] [mailto: >>> [EMAIL PROTECTED] *On Behalf Of *Jon Liu >>> *Sent:* Saturday, November 22, 2008 9:04 AM >>> *To:* [email protected] >>> *Subject:* [DotNetDevelopment] Re: Image Upload >>> >>> >>> >>> Stephen, >>> >>> Thanks for the reply, I realize that this functionality might not be >>> needed since in all reality the user probably won't upload hte same >>> image..but I just wanted to build it in as this is my second application >>> using .NET and I wanted to get a feel for everything. >>> >>> Also, this is a totally noob question and yes I have tried searching it, >>> but how do you create a GUID? Any suggestions for reference tools? >>> >>> Thanks >>> >>> Jon >>> >>> On Sat, Nov 22, 2008 at 6:53 AM, 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 >>> >>> >>> >>> >>> >>> 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 >>> >> >> >> >> -- >> _______________________________ >> >> 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 >> > >
