Solved problem with SQL Server Management Studio (SSMS) in Windows 7 X64

I was trying connect to database via SQL Server Management Studio in windows 7, and got following message.

Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{6D5140C1-7436-11CE-8034-00AA006009FA}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). (Microsoft.VisualStudio.OLE.Interop)

I have tried all the solutions I found in the internet:
http://social.msdn.microsoft.com/Forums/en/sqltools/thread/d5d3e5fc-d8ce-4f42-b7ea-9bbbb7756a20

But none of them works for me.

However, I finally got the problem solved by removing my anti-virus software AVG 9.5.
Hope this will help other people.

Update:
The same problem back again after I disable UAC, and restart computer.
I have to enable UAC again to fix it.

Update 2:
There is an easy way to fix is just to run SSMS as administrator

Silverlight 4 beta released

Silverlight 4 Beta has just released On November 18, 2009.

 

Check it out at: http://silverlight.net/getstarted/silverlight-4-beta/

 

New features which I was look forward to:

-          Mouse wheel support for scrollable controls (no additional behaviour is required)

-          Right click support

-          Clipboard support

-          Full editable design surface for VS2010

 

 

It could be good fun to move to SL4 soon.

Silverlight: how to solve data validation not working on DatePicker control

 

 

Ramesh Subramanian post an excellent solution to have data validation element showing for DatePicker control.

 

http://www.rameshsubramanian.org/2009/09/silverlight-datepicker-validation.html

 

Check it out.

Silverlight Behaviors, Triggers and Actions by morten

http://www.sharpgis.net/post/2009/08/11/Silverlight-Behaviors-Triggers-and-Actions.aspx

 

How to determine an webresponse stream type

               WebRequest request = WebRequest.Create(url);

                HttpWebResponse response = (HttpWebResponse)request.GetResponse();

 

                if (response.ContentType.StartsWith("text/html", true, CultureInfo.CurrentCulture))

                {

                    //Html page

                }

Up comming: Silverlight: how to scroll to target element in ScrollViewer or nested ScrollViewer

   public static class ScrollViewerExtension 
   { 
     /// <summary> 
     /// Scroll to the current element, if there is has an parent scrollviewer 
     /// </summary> 
     /// <param name="target"></param> 
     public static void ScrollToElement(this UIElement target) 
     { 
       ScrollToElement(target, null); 
     } 
     /// <summary> 
     /// Find next level scrollviewer, and scroll to the target element 
     /// </summary> 
     /// <param name="target"></param> 
     /// <param name="childScroller"></param> 
     private static void ScrollToElement(this UIElement target, ScrollViewer childScroller) 
     { 
       try 
       { 
         ScrollViewer scrollViewer; 
         if (childScroller == null) 
         { 
           scrollViewer = ParentOfType<ScrollViewer>(target); 
         } 
         else 
         { 
           scrollViewer = ParentOfType<ScrollViewer>(childScroller); 
         } 
         if (scrollViewer != null) 
         { 
           if (scrollViewer.ComputedVerticalScrollBarVisibility == Visibility.Visible) 
           { 
             UIElement scrollContent = scrollViewer.Content as UIElement; 
             GeneralTransform gtToContent = target.TransformToVisual(scrollContent); 
             Point offsetToContent = gtToContent.Transform(new Point(0, 0)); 
             GeneralTransform gtToScroller = target.TransformToVisual(scrollViewer); 
             Point offsetToScroller = gtToScroller.Transform(new Point(0, 0)); 
             if (offsetToScroller.Y < 5  offsetToScroller.Y > scrollViewer.ViewportHeight) 
             { 
               scrollViewer.UpdateLayout(); 
               scrollViewer.ScrollToVerticalOffset(offsetToContent.Y - scrollViewer.ViewportHeight / 4); 
             } 
           } 
           ScrollViewer parentScroller = ParentOfType<ScrollViewer>(scrollViewer); 
           if (parentScroller != null) 
           { 
             ScrollToElement(target, scrollViewer); 
           } 
         } 
       } 
       catch 
       { 
         //TODO: Log exception message here 
       } 
     } 
     private static T ParentOfType<T>(UIElement currentElement) where T:DependencyObject 
     { 
       return currentElement.GetVisualAncestors().Where(p => p is T).FirstOrDefault() as T; 
     } 
   } 

Silverlight - breaking web project into the 2 separate concerns

This is an awesome read.  We should do this sometime and break the web site into two parts:

 

1.       Service

2.       Web host / navigation

 

http://blogs.msdn.com/brada/archive/2009/07/28/business-apps-example-for-silverlight-3-rtm-and-net-ria-services-july-update-part-11-the-new-class-library-project.aspx