Experience – Page 53 – cuteprogramming

Adding CSS3 to Visual Studio 2010 CSS Validation

December 30, 2011April 27, 2013 by Chun Lin, posted in CSS, Experience

I always edit CSS in Dreamweaver or Notepad (My friends always scream when they see me using Notepad to write CSS or HTML). Recently, I’m writing a web app to be deployed on Azure. So, I have the chance to edit CSS in Visual Studio 2010.

Visual Studio also provides us CSS validation. However, soon I found that VS kept warning me for having unknown CSS property names. I guessed that was due to the fact that it’s using an older CSS version for validation. Yappari, the “CSS Version for Validation” dropdown list showed that it’s currently using CSS 2.1. Thus, VS didn’t know the new property names introduced in CSS 3.

Warning (CSS 2.1): Unknown CSS Property Names

To solve that, I followed the steps suggested by Garry in StackOverflow. What I need to do is basically just downloading and then installing the “CSS 3 Intellisense Schema” (Free!) from VS extensions gallery: http://visualstudiogallery.msdn.microsoft.com/7211bcac-091b-4a32-be2d-e797be0db210.

Download CSS 3 Intellisense Schema for Free

In the discussion forum, there is a user, Nibblersrevenge, saying that if the CSS 3 validation entry was enabled even after the installation, we should copy the file “css30.xml” from the folder “C:\Program Files\Microsoft Visual Studio 10.0\Common7\Packages\1033\schemas\CSS” to the folder “C:\Program Files\Microsoft Visual Studio 10.0\Common7\Packages\1031\schemas\CSS”. Luckily, I didn’t encounter this problem.

After the installation is done, I can see the newly added CSS 3.0 option being added to the CSS validation dropdown. The warnings previously generated by VS are all gone after I change the CSS validation to CSS 3.0. Yay.

EDIT (27 April 2013): As iamprabhanshu pointed out in the comments section, if the CSS 3.0 option is still not available in the dropdown list after the installation, please close the Visual Studio and re-open it.

No Permission to Create Database in SQL Server 2008 R2

December 28, 2011March 8, 2012 by Chun Lin, posted in ASP.NET, Experience

This morning, I was playing with Microsoft SQL Server since I was asked by my senior to learn using it before going to work in next week.

I thought I had the free Express version. However, when I searched through the programs list, I found out that I actually had Microsoft SQL Server 2008 R2 in my computer. Yay~ I guess I got it for free from school. Thanks MSDNAA for helping SoC students that much!

I was very happy until I run the program. When I was about to create a database, I just found that I had no permission to do so. Oh my tian… I even forgot the password that I set that time (Wait… Did I even set a password?). I looked at the users list (/Security/Logins), I only saw BUILTIN\Users and sa. Ano… Where was the BULTIN\Administrators? I later found out that due to security issues, new SQL Server 2008 no longer had BUILTIN\Administrators in the SQL Server sysadmin fixed server role (Reference: Database Engine Configuration – Account Provisioning). Also I couldn’t access using SA account because I forgot the password that I set a long, long time ago.

Besides, I also could not create new user. That was quite disappointing.

Later, I read a thread on StackOverflow about resetting the SA password: http://stackoverflow.com/questions/4188193/how-do-you-reset-the-sa-password. Their problems were very similar to mine. Although it was about resetting the SA password, I guess if I could reset the password, I should have no problem accessing the databases as well.

Hence, I decided to try out their suggestions: Starting SQL Server in single-user mode. To do so, after closing the SQL Server Management Studio window, I launched SQL Server Configuration Manager. From there, I looked for the SQL Server instance. I then right-clicked on it go to Properties.

Step 1: Right-click Server Instance, Select Properties

In the Advanced tab, I entered parameter “-m;” before existing parameters in “Startup Parameters”.

Finally, I clicked on OK and then restarted the server instance.

After that, I run SQL Server Management Studio again. Then I saw the following error message when I tried to connect with Windows Authentication.

Error: Only One Admin Can Connect At One Time

Soon, I found that it won’t show this error message if I run SQL Server Management Studio as administrator as shown below.

Yup, now I can successfully create databases, add new users and reset passwords. =)

Now, it is time to remove the “-m” parameter.

In fact, there are online tutorials about starting SQL Server instance in single-user mode, for example http://blog.sqlauthority.com/2009/02/10/sql-server-start-sql-server-instance-in-single-user-mode/

Oh yeah, if there is a need to login SQL Server Management Studio with SA account, I can enable it in the Login Properties of the SA account (Reference: http://anujyadavcse.blogspot.com/2010/08/login-failed-for-user-sa-reason-account.html).

Playing with HTML 5: The Video Tag

September 11, 2011March 8, 2012 by Chun Lin, posted in Experience, HTML5

I was playing with HTML5 again. Today, I was trying to use the new tag <video> to embed the intro video of the game Planetarian. I tried a few times using JS to detect the end of the video but only realized the correct way of doing it is as follows.

var video = document.getElementsByTagName(‘video’)[0];
video.addEventListener(“ended”, function() { //Do stuff here after end of video }, false);

According to online resources, this code should work in Chrome, Firefox as well as IE9! =D

Unfortunately, I just uninstalled IE9, so I haven’t tested it on IE9. =P

Intro Video of My Online Planetarian — Intro Video in My Online Planetarian

Drag-and-drop Reordering in WPF ListView

December 19, 2010March 8, 2012 by Chun Lin, posted in Experience, WPF

Problem
When I was working in OneSync project, our team was once asked if there was a way to implement drag-and-drop reordering in the ListView control. We answered no because we could not find any way to implement that functionality. In the end, we used two buttons: Up and Down for reordering the rows in listView.

Up-and-Down Reordering Buttons in OneSync

Solution
Last week, I was again asked by my friend to implement similar stuff in WPF. I tried to google and I found the solution, finally: http://www.codeproject.com/KB/WPF/ListViewDragDropManager.aspx.

Drag-and-Drop Reordering Is Possible in WPF ListView

There are three major classes I use in the new project:

ListViewDragDrop.cs: Manages the drag-and-drop reordering in ListView.
DragAdorner.cs: Draws a translucent listViewItem on top of the ListView and makes it follow the cursor during the drag-and-drop operation.
MouseUtilities.cs: There is a method which returns the position of the cursor.

I find the MouseUtilities class to be quite interesting. The author of the method is Dan Crevier from Microsoft. According to the documentation, the purpose of having the class is because “the WPF mechanisms for retrieving the cursor coordinates are unreliable”.

It uses unmanaged code to solve the problem. After coding in C# for several years, I am getting used to reading the managed code, but not unmanaged code in C#. However, for those who are good at C and C++, they can try reading the code in MouseUtilities.cs.

Drag-and-Drop or Up-and-Down Buttons?
In fact, I like the Up and Down buttons very much because they allow the last item in the list to become the first item with just one click on the Down button. If we use the drag-and-drop feature, then we have to drag the last item all the way up to the top of the list. It will be quite troublesome when the list is very long.