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 >
