Parmeshwar’s Homespace

SGGS Alumni meet in Pune was a brand success with atleast 100 people participating in the meet. Further details can be read at SGGSPALS soon !!

Anyway..be ready for the Silver Jubilee celebration @ SGGS !!

I have Word 2000, Word 2003 and Word 97 installed on my machine. At a time ,only one exe will be active as per the behaviour. i.e . When I click on the Word 2003 exe (Winword.exe) all icons changes to Word 2003. When I click on Word 2000,all icons changes to Word 2000 and so is with Word 97. Since the compare method of Word 2000 object model accepts only one parameter i.e filename , I am using the same with Word 2003 also. When I tried to compare documents edited with word 2000 using Word 2003 object model, it is not showing track changes on. When I use Word 2000 Compare method, it is working perfectly.

However, when I use Compare method with additional parameter as CompareTarget: =1 (in Word 2003), it is working fine.

Why the Compare method with single parameter as FileName is not working in word 2003 ?

One more problem: I have written code to clean the Word Application as well as Word Document object in the ‘finally’ expression,but Task manager is showing an instance of WINWORD.EXE running under the account of ASPNET user..Can anybody explain the behaviour !!!

Use the Page.Request.Params(”__EVENTTARGET”) to get the name of control who caused postback.
However, this does not return the name of control,if the postback is caused by button/ image button.
You can get the button control by looping through all the controls from Page.Request.Forms and comparing with Button Webcontrol.

Dim controlName as string
controlName = Page.Request.Params(”__EVENTTARGET”)
Dim control as Control
If controlName <> Nothing And controlName <> String.Empty
control =Page.FindControl(controlName)
End If


I got this error while executing SP on database. We are using connection pooling in the connection string. As the number of people are trying to connect to the same database while debugging the application - this error was coming. As soon as the debug of some person stops, same code is working fine. Here is a Microsoft KB : http://support.microsoft.com/default.aspx?scid=kb;en-us;827452 Here is a nice discussion on the issue: http://weblogs.asp.net/pleloup/archive/2003/07/23/10451.aspx

Visit Microsoft Patterns and PractisesSummit 2005-2006 for more details.

This Exception mainly comes when we are trying to copy a row from one DataTable to another Datatable.

Here is Problem:

Dim tempDS as Dataset For each temprow as DataRow in objDS1.Tables(0).select(”ID=’xyz’”)

tempDS.Tables(0).rows.add (temprow) Next row Instead ,do the following:

Dim tempDS as Dataset For each temprow as DataRow in objDS1.Tables(0).select(”ID=’xyz’”)

tempDS.Tables(0).ImportRow (temprow) Next row

When we are using SQL server 2000 on Windows server 2003 machine and application on Windows XP/Professional and changed machine location,the same application which was running previously,started giving the above error.After lots of search, we found that the problem resulted due to change of IP address/ Port or domain of client machine on which application is hosted. What was happening - MSDTC on client system was able to communicate with MSDTC on database server but vice versa was not possible as the DNS setting is yet not reflected in DB server. This will take some time to reflect,therefore Windows server 2003’s MSDTC check for the previous IP/domain and fails to respond resulting in above error. The solution is - Either restore the IP address to original OR wait for around 24 hrs ..it will solve the problem.

Here is KB:MSDTC fails to mutually authenticate when computers do not run in the same domain explaining the Mutual authentication failure when running application and Database server on different domains.

Also if you are running your application on Windows XP with SP2 applied, check for the proper configuration for MSDTC. Here is a documentation at Microsoft Technet: Changes to Functionality in Microsoft Windows XP Service Pack 2 Any comments welcome !!

Following is a nice link wherein you can find all shortcuts related to VS .NET 2003 http://www.codinghorror.com/blog/files/visual%20studio%20net%202003%20keyboard%20shortcuts.html

This is a very nice article which demonstrate how to generate these using program.