How should i use NoLock in Linq query using VB.net 2008

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

Hi, I was trying the extract the records from a table which is currently used by some other user for updation/insertion. My question is , Is there any way to read the committed data for a row which is presently locked because updation on this row is going on and transaction is not completed. Thanks

Should the file get opened in compatibility mode? Which ever file is opening , the compatibility mode text get appending with the file name, until the instance is killed.

can u provide some sample code to process it?

do u have any idea for the below link http://www.codeproject.com/Messages/3071168/files-names-under-a-process-vb-net-2008.aspx[^]

i HAVE 35-40 LINES OF CODE, before i closes the workbook. and meanwhile user tries to open an excel file, which results in opening the file (Sheet.xls). Any idea?

Hi, In my code, after execution of the following code.

dim d as new Excel.Application

create an excel instance. and opening an excel file by using the following code.

d.Workbooks.Open(ExsTemplate & "sheet.xls")

Now i try to open an excel file by double clicking it, which is lying in my hard drive. this open sheet.xls file also , in the taskbar. Can you tell me why sheet.xls should open? Thanks

Hi, I opened ten excel files, and all files are coming under one process in the task manager. Is there any option to find all the excel file names which are lying in this excel process? Thanks

Hi, In am doing the simultaneouly two imports. Which export the data from excel to sql server. There are some common tables, which are being approached by both these imports. and results in deadlock Transaction (Process ID 53) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction. In the sql profiler, i have seen that a couple of queries are taking time, which are using common tables in imports. I have optimized it also. Can you provide me any suggestion? Thanks

Christian, Suppose i open ten files, and all these files shall come under one process. I know the process id. can u tell me how should i find out all the file names pertaining to this process? Thank You

Hi,

xlsApp1 = CreateObject("Excel.Application")

after the excution of the above code creates an instance of excel in task manager.

Dim temp As Excel.Workbook
temp = xlsApp1.Workbooks.Open(ExsTemplate & "sheet.xls")

this line is opening an excel template file. after the excution of above line i try to open any excel file by double clicking it which is lying in my hard drive. and results in opening this file - ExsTemplate & "sheet.xls" and one more thing this opened file , does not create a new instance in task manager. These are the two problems. both thses files are under one process. because when i kill this process from task manager, it closes both files. please help.

I have an excel template, from this template i copy the worksheet and save it to workbook. I initially created an excel.application instance

xlsApp1 = CreateObject("Excel.Application")

then , i open this template file

temp = xlsApp1.Workbooks.Open(ExsTemplate & "sheet.xls")

i am presently in debug mode and breakpoint is on the above line. and right after this i open an excel sheet by double clicking it which is lying in my hard drive. This opens the template file also. This is the problem. Can u tell me how should i avoid this problem.

I know the managed code and unmanaged code. But can u tell me any link that tell about the managed object and unmanaged objects.

Thank You

Henry Minute wrote:

Both of the members will be released and disposed when their references go out of scope

Then why should i dispose the objects in finally?

Hi, Should i take care of both the variables which are consuming the memory on heap/stack, while releasing the memory in finally? Or just heap variables are enough to be released? dim d as integer=0 Dim f As DataGridView=nothing try d = 10 f=new datagridview catch(byval ex as exception) finally d=nothing f=nothig end try

Hi , In vb.net, Merge function, merges the rows. Is there any way to merge columns? Thanks and Regards Pankaj Garg

Hi, My Front end is VB.net 2008 I was trying to fix the problem of overwriting the previous setup problem. So while surfing the net, i got the following link useful. http://social.msdn.microsoft.com/Forums/en-US/winformssetup/thread/aea77734-3517-4301-8525-a40748a7905c/[^] But I have a query, there I found the following code.

If My.Settings.UpdateRequired Then
My.Settings.Upgrade()
My.Settings.UpdateRequired = False
My.Settings.Save()
End If

Can you tell me, In which file I should write this code?

Hi all, How can we see the LINQ query in add watch?