Yes, I've been playing around some. I'm not sure if it's a bug in .NET 2.0. After the transaction is approved, I want to exit the Form with "this.Close()" but it locks the app. If I switch to BeginInvoke it works ok. Also, I can use Invoke, if I open the form with ShowDialog instead of Show. Useful link: avoid invoke Ron

Thanks Ahsan, Yes, I could update the DataTable directly, but then I'd have use something like dataTable.Rows.Find() to correlate with the selected row in DataGridView. Do you know of a better way to find the DataTable row based on the selected DataGridView Row? Even if I do go the route of updating the DataTable directly, I'm always interested in learning more. I'm basically wanting to know the best way to sync the DataTable with the DataGridView if the DataGridView is edited. Ron

Ron, I guess you posted this here because the file happens to be XML. I can assure you that there is nothing specific to XML technology that would account for this. Moving on. myNameIsRon wrote: revert back to the original install file/data. - Open XML file in Notepad, the data shown is the original install data. You provided no information that would enlighten us about this "install", so once again, that doesn't tell us anything useful. You also provided no information about how this "original" file has been modified so listing all the ways you open it and see the original data without providing any clue about how it is supposedly modified, wait for it, doesn't tell me anything useful. Based on what you posted I can not eliminate the users as the problem in every one of your scenarios. myNameIsRon wrote: - Open XML file in Notepad, the data shown is the original install data. User opened the wrong file. myNameIsRon wrote: E-mail XML file, the data is reverted to original install data. User emailed the wrong file. myNameIsRon wrote: Open same XML file in Internet Explorer, the file shows up-to-date data. Same as what? That statement doesn't even have enough information to understand. If you meant the same XML file they emailed in the previous step, then the first point is still valid, they sent the wrong file. led mike

+ return NULL if any one of the field contains NULL value. Otherwise both more or less returns same results. :) Regards SG

Thanks John! I thought there might be an issue if no rows were returned, but it works great, thanks! Ron

I don't think there is much of a difference between 2003/2007. "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

OK, I see now... I'm a fairly new programmer (with no formal training), so I'm not familiar with object comparison. The other methods (min, max) use IComparable, but they don't bother using it for the ColumnEqual method. I've changed: return (a==b); //value type standard comparison to: if (((IComparable)a).CompareTo(b) == 0) return true; else return false; works great now, on the different data types and my OleDbCommand string results. Ron

Yeah, that's why I do my research in the documentation instead of Intellisense. There's lots of hidden stuff in the docs that you'll never see anywhere else. Dave Kreskowiak Microsoft MVP - Visual Basic

Thanks Glen! Ron

Errh, should have seen it immediately. The problem is the foreach loop that prevents you from changing the iterated collection. Change it to a for loop and it should work. "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de

If you are using SQL Server then the syntax is: isnull(sum(YourColumn), 0)

Hi sAqib, Yes, the label is set to public. Could the problem be that label properties are placed in the constructor by default? It only seems to work if "static" is used and the label properties are set in the FormLoad event. What you think? Ron

Thanks Sameer! Ron