The secret is in reading the excepion text :P toink toink wrote: The process cannot access the file because it is being used by another process. Which means someone already has a lock on that file. Possibly you. There are a few tools around which allow you to investigate the locks on a file. Theres a few at SysInternals[^] but personally I like Unlocker[^].

toink toink wrote: 08-29-07 06:42PM 0 Test1.txt 08-29-07 06:42PM 0 Test2.txt 08-29-07 06:42PM 0 Test2.txt You may need to parse the output of the FTP process. Vasudevan Deepak Kumar Personal Homepage Tech Gossips

Use Microsoft.Win32 namespace. You can find there a RegistryKey class: RegistryKey root = Registry.LocalMachine; Then create a recursive method which would scan the whole registry, using GetSubKeys, GetValueNames and GetValue methods. The recurse would hang on the iteration through GetSubKeys method. Greetings - Gajatko Portable.NET is part of DotGNU, a project to build a complete Free Software replacement for .NET - a system that truly belongs to the developers.

toink toink wrote: how about if we will display the installdate and installlocation using the latter code? or using the registry? What code are you referring to here? toink toink wrote: if inParam["sValueName"] = keyName is used to get the Displayname, how about the rest of the values? like installdate, softwarepath and the rest of the values? It sounds like you would probably do better to use this ManagementObjectSearcher products = new ManagementObjectSearcher("SELECT * FROM Win32_Product"); foreach (ManagementObject product in products.Get()) { Console.WriteLine("Software name: {0}", product.Name); Console.WriteLine("Install date: {0}", product.InstallDate); ... } Scott. —In just two days, tomorrow will be yesterday. [Forum Guidelines] [Articles] [Blog]

u have to replace & with sth. that is allowed in plain html i think u should replace & with & for more info. http://www.html-reference.com/Escape.htm

This cannot be done. Transaction logs are associated with a specific database and cannot be applied to a different database. Stability. What an interesting concept. -- Chris Maunder

You back up a transaction log either through the Enterprise Manager (or Management Studio for SQL Server 2005) or using the BACKUP LOG statement. The second question has no meaning for SQL Server - every database has at least one transaction log file, even in Simple recovery mode. The transaction log contains the information necessary to roll back to a particular point or, in the case of recovering from a failure, to roll forward to a particular point. SQL Server writes what it is going to do to the transaction log directly to the disk, then makes the modifications to the actual data pages in RAM. It can then write the changes to the data pages lazily, knowing that it can always recover the changes if there was a failure. To support roll back, SQL Server records what was there before and what the new data is. If a transaction rolls back (either explicitly through a ROLLBACK TRANSACTION statement, or implicitly when a statement fails), SQL Server simply reads the 'before' image and applies it to the data pages. If you're in Full recovery mode, the transaction log contains 'before' and 'after' images of every row that has been modified since you last backed up the log file. An INSERT has no 'before' image and a DELETE no 'after' image. TRUNCATE operations merely log that the truncation occurred, and I'm not sure that it's possible to undo them. If the database file becomes unusable, but the database is still attached to the server, I believe it is still possible to back up the transaction log; then, you can restore your last full database backup and restore all the transaction log backups in sequence to recover to the point of failure. Bulk recovery mode is the same as full mode, but for BULK INSERT operations, SELECT INTO, CREATE INDEX and operations on text- and image-type columns, the server only records in the transaction logs which pages were affected by the change. When you make a transaction log backup, these pages are copied into the backup file. This does not allow rollback to a point in time, because only the latest versions of the bulk pages were stored. The data file must be available in order to back up the transaction log. In Simple recovery mode, the log contains all the information that the Full model does, but it is automatically truncated on a checkpoint. Space occupied by transactions that had already committed becomes eligible for reuse. Long-running transactions can still cause the transaction log to grow in size. Making a full backup of the data

Hi, I'd do this: private bool CheckTextBoxes(params TextBox[] textboxes) { bool result = true; if (textboxes.Length > 0) { string standardText = textboxes[0].Text; for(int i = 1; i < textboxes.Length; i++) { if (textboxes[i].Text != standardText) { result = false; break; } } } return result; } Function usage: bool equality = CheckTextBoxes(textbox1, textbox2, textbox3, textbox4, textbox5, textbox6);

toink toink wrote: The problem with the statement, is that, it doesn't show any records when one of the parameters is blank or null. How would it be able to show records giving value only to either of the parameters? That is correct. A NULL in a set based operation always yields NULL. toink toink wrote: CONVERT(NVARCHAR, D.Spd_deldateans, 101) between @DATE1 AND @DATE2 Why are you converting Db.Spd_deldateans to an NVARCHAR? If D.Spd_deldateanes is already a DATETIME or SMALLDATETIME then WHERE (D.Spd_deldateans >= @DATE1 OR @DATE1 IS NULL) AND (D.Spd_deldateans <= @DATE2 OR @DATE2 IS NULL) What this does is say the equivalent of IF D.Spd_deldateans is greater than or equal to @DATE1 OR @DATE1 IS NULL which evaluates to TRUE if @DATE1 is null which means that the >= operation is effectively overriden Scottish Developers events: * .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog

Hello Maybe you should try using the SELECT command to see if it will give you an existing row or not. If the row exists => update it else => Add a new one Regards:rose:

Then why don't you ask your question in the comments section of the article itself? That would be the right place. Regards, mav -- Black holes are the places where god divided by 0...

i have 5 groupboxes in one form. each group box has 3 textboxes and two buttons the first textboxes of each groupbox are from a dataset coming from a master lists. for example a productcode. the other two textboxes are the details of the productcode coming from another table from the database which primary code is the productcode the two buttons functions as the following: first button(arrow down) it will display the data from that of the groupbox 2 to the controls of the groupbox 3 and the data from the groupbox 3 to groupbox 2 second button(arrow up) it will transfer the data from that of the groupbox 3 to the controls of the groupbox 2 and the data from the groupbox 2 to groupbox 3 its sort of changing the displayed data either up or down of the other groupboxes

Wow, what a long post...:omg: Anyway, StreamReader class can't read remote web pages by itself -supposingly-. You should check the System.Net namespace for classes that read html pages -eg. HttpWebRequest- By the way, this way you will print the Html of the page. Why don't you check the WebBrowser component? It has a Print() method.