Hi, Suppose i update the row Begin tran Update table set column = 'some val' where id = 9 it's original value is val now suppose transaction completes after some time, and mean while a user selects this table and the user should read val not some val Any Idea? I dn't want to ready dirty data and also don'y want the query to get blocked

Set IgnoreRemoteRequets to True to force excel to open a new instance of excel.exe for each workbook, this may cause undesired behavior and may cause links to not work. Save your sheet when you set ignoreremoterequests to true. This will prevent all worksheets opened programtically when a user opens a workbook from his desktop. Check out the CodeProject forum Guidelines[^]

Set IgnoreRemoteRequets to True to force excel to open a new instance of excel.exe for each workbook, this may cause undesired behavior and may cause links to not work. Save your sheet when you set ignoreremoterequests to true. This will prevent all worksheets opened programtically when a user opens a workbook from his desktop. Check out the CodeProject forum Guidelines[^]

This would tell me that you can't do the imports simultaneously since they both add/modify to the same table(s). You don't have a choice but to do them sequentially. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

xlsApp1.workbooks give you all the info about the open files by your program and others(manualy)

You problem isn't clear. Are you asking for a way to stop someone from opening a file? Because I don't think you can do that. Or are you getting an error because the file has been opened by the user? In which case, what is the error?

Try this[^] for some info about unmanaged objects (resources). For information about both, try googling managed v unmanaged objects or managed and unmanaged objects. There are so many hits that it is difficult to pick one for you. Have a look for yourself. Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

No, there is no built-in method to do so. You'll have to iterate through the rows and do it yourself. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

Before any off your settings are called so best bet is the application startup event.

Your question is vague. I assume you mean, "How can I look at the results of a LINQ query in the "watch" window in Visual Studio?" For that, add the LINQ query field to the watch window, then call .ToArray() on it. You should be able now to expand the field. Visual Studio may also give you the option to "evaluate results", which will iterate over the IEnumerable results and display them in the debugger. Religiously blogging on the intarwebs since the early 21st century: Kineti L'Tziyon Judah Himango

Even we had deadlock proplem in one of our SQl Job. We did following. Used Begin Try End Try block & Begin catch End catch block. Use a flag in the permanent table which indicated processed or not. When trying to rerun run only those which is not processed. This way second time when you run it processes only which are not processed.

Check if it's larger than 0 :) DECLARE @f INT SET @f = 788 IF @f > 0 BEGIN PRINT 'It is positively positive!' END ELSE BEGIN PRINT 'That''s A negative there, Toto' END I are troll :)

Hi, I did, As suggested by you. But, I am getting the same crash for the following query Dim query as integer= (From P In objbase.GetTable(Of table)() Where P.ID1 = Id1 And P.CID1 = CId1 Select P.Fee).SingleOrDefault

Dave, How are you? :) ok, No Problem. Sorry for not coming back in time. Now, I am explaining the whole process again. I have a form. In this form, I have a menu control, this menu control has four buttons. On clicking the first three buttons, open the window with Show() event. and the fourth button open the screen with ShowDialog() Now, One by one I am clicking the button , so finally i have now four windows of this application.(Three with Show() and one with ShowDialog()) Right? Now I am minimizing all the windows with the help of Window + D Button. After this, If I use the keyboard(Alt+ Tab) keys. This is opening the showDialog window on top because , As suggested by you , I changed the TopMost = True for this showDialog window. Now I come back to my problem. Again, All the windows are minimized. In the taskbar and Startmenu properties , I have selected the Group Similar Taskbar buttons This resulted in the heap of my application windows, one on the other. I hope you have understood this point. By doing this , same kind of windows lie one on the other. Now i click on one of my application window , and If I click the window other then the Show Dialog opened Window, this is not bringing the show dialog window to topMost. This is the problem. Please let me know if you still face any problem in understanding the question. Thanks and Regards Pankaj modified on Wednesday, March 11, 2009 1:58 AM

Well, the fastest option would be to have the database do it using SQL. But, if that's even possible lies in the lack of details you provided on the problem in your original post. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

Sorry, I Meant 2008 If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!