How to Set the Clock in Car Audio

After disconnecting the battery for a maintenance job, I had some clueless days while trying to reset the clock in a car audio system. Even though there should be a way to set the clock in audio systems it is bit difficult to find it without the manual of the system.

My in my scenario I found it after sometime, so thought to share it since it might help someone with the same problem.

Car audio system in which I had the issue was JVC KD-S5055.

To start the resetting you need to press and hold the “Select” button for about 5 seconds. Then a message similar to “Hour-h” will be shown in the display. Once this appears use the + and – buttons located on the left to set the hour value of the time.

Then to set the minute value you need to press the mode change buttons located on the right side. Once you press the mode change button while on the hour changing mode you will see a message similar to “Minute-m”. Then again you can use the + and – buttons to set the minutes portion of the time.

After successfully setting both hour portion and minute portion you can press the Select button again to save the changes made to he clock.

Additionally if you need the system to show the time when the device is switched on you can press the Display button located below the Select button. This will show the current time instead of the Radio/CD/Track information.

Hope this helps.

Sending the Same Letter to Different People with their Details

Today a friend of mine needed some help from me on sending the same letter to different people while addressing the letters differently. This can be easily achieved by using Word Mail Merge feature.

Since I am having Word 2010 installed in my machine this post will list the steps required in Word 2010.

1. To start the process type in your letter and click on Mailings on the Word 2010 ribbon.

2. Click on Start Mail Merge and select Letters.

3. Then you need to select the people you need to send the letter to. To do that you have three options Type List, Use Existing List or Select from Outlook contacts. In this post I will use the first option.

4. When you click Type new List… you will get a window in which you can create a list of users with their details as shown in the following screenshot. For simplicity I will only create 2 users.

When you are done creating the list of users click ok so you will be prompted with a save window. Save it for later use since you may need the list for future use.

5. Then in your letter go to the appropriate places you need to place the differencing information, for example I need to put the address of the receiver after the text The Manager. To do so place the cursor on the required location and press on Address Block icon on the ribbon.

From the Insert Address Block window you can customize the way the address is printed on the letter. For example if you do not want to print the company name of the recipient then you can remove the checkmark on the Insert company name field. Preview pane will show you a preview of the actual data you have in your contact list. For the simplicity I will use the default options.

When you press ok you will see something similar to the following appearing in your letter, which will be the placeholder for the address block.

Following similar method but using the Insert Merge Field icon I did add the title and the last name of the recipient into the body section of the letter as you see below.

6. Preview your work by clicking Preview Results icon, by clicking the navigation buttons on the preview results pane you can navigate through your contacts to see the actual letters that will be created. For example below screenshot shows the letter for Mr. Withana with the changes for him.

7. When you are satisfied you can finish the merge with three options, in my case I will use the first option again.

As the final output of the merge I got one new document with the 2 letters addressed to the recipients i had in my contact list as shown in the following screenshot.

Configuring SQL Server Instance for Azure Development Storage

If you have not configured Azure Development Storage to use your SQL Server, then while running your application targeted for Azure you will see an error similar to the following.

“Windows Azure Tools: Failed to initialize Development Storage service. Unable to start Development Storage. Failed to start Development Storage: the SQL Server instance ‘localhost\SQLExpress’ could not be found. Please configure the SQL Server instance for Development Storage using the ‘DSInit’ utility in the Windows Azure SDK.”

To overcome this you need to run the DSInit command using Windows Azure SDK Command Prompt.

Step 1 – Start the Windows Azure SDK Command Prompt.

Step 2 – Type DSInit /sqlinstance:. on the prompt and press enter.

The dot (.) at the end denotes the local SQL Server instance running on your machine. DSInit command details are as follows.

Syntax: DSInit [/sqlinstance:<SQL server instance>] [/forceCreate] [/user:<Windows account name>]

Description: Initialize the development store for usage by Reserving http ports for the blob, table and queue services for the current user, and Creating the database needed by the blob and queue services

Options: sqlinstance : the name of the SQL Server instance on the local machine that should be used for Development Storage. The default is SQLExpress. Use "." for unnamed instance. forceCreate : recreate the database even if it already exists. user : user for whom ports are to be reserved. By default it is the current user.

.

After doing the configurations it will display a success screen similar to the following.

Then when you run your Azure ready application the Azure Development Storage and Azure Development Fabric will get started and notify you on your system tray as shown below.

After a while your application will also start without complaining if it is Azure ready.

Saving Table Changes in SQL Server 2008 R2

Have you noticed that with the default settings of SQL Server 2008 R2 you cannot use the design view to edit and save table changes which requires table to be recreated. But if you used earlier SQL Server installations you should remember that this functionality was possible. When you try to save such a table you will see an error similar to the following in SQL Server 2008 R2.

But the good news is that we can enable this functionality by going to SQL Server options.

Click Tools –> Options and expand Designers node and select ‘Table and Database Designers’.

Then uncheck the option ‘Prevent saving changes that require table re-creation’ and press OK.

Now if you try to save the table changes SQL will do the alteration without any complains.

Sorting SharePoint Folder Contents

Recently I needed to sort the contents of a SharePoint folder, in which I used IComparer to get my task done. Following is the code I used. Hope it is helpful.

As you see below I am using the TimeCreated property of SPFile object to do the comparison, other than this you can use any other property of the SPFile object. For a list of available properties refer MSDN.

1. // Comparer Class.
2. public class SPFilesComparer : IComparer
3. {
4.     #region IComparer Members
5.     public int Compare(object object1, object object2)
6.     {
7.         return new CaseInsensitiveComparer().Compare(((SPFile)object1).TimeCreated, ((SPFile)object2).TimeCreated);
8.     }
9.     #endregion
10. }

1. ArrayList fileList = new ArrayList(attachFiles);
2. IComparer compFiles = new SPFilesComparer();
3. // Do the sorting based on the SPFilesComparer.
4. fileList.Sort(compFiles);
6. foreach (SPFile attachFile in fileList)
7. {
8.     // Use the sorted list.
9. }

Piano + Guitar = Harpejji

Are you interested in musical instruments? If so have you seen an instrument which combines the Piano and the Guitar? It is manufactured by a company named Marcodi and is named as Harpejji. The sounds from it is truly fascinating, experience the sounds for you self by visiting their site. For people who would like to buy it the pricing and ordering details are also there in the site.

Click this link to see the event of presenting Harpejji first time to the great musician A. R. Rahman.

MaxLength property not Working in TextBox

If you are involved in coding using .Net sooner or later you will notice that when the TextMode of a TextBox is changed to MultiLine the MaxLength property will stop working. What this means is in the textbox users will be able to type as many character as they want.

When searching the web for a fix for this I found several ideas to solve this. Following is the code which I modified for my requirement. Hope this helps.

ASPX

1. <html xmlns="http://www.w3.org/1999/xhtml">
2. <head runat="server">
3. <script type="text/javascript">
4.     function RestrictLength(textBox) {
5.         /* Get the Max Length attribute's value. */
6.         var allowedLength = textBox.getAttribute('MaximumLength');
7.         /* Check for the number of characters typed in by the user. */
8.         if (textBox.value.length > allowedLength) {
9.             /* If it is more than the allowed limit remove the additional text. */
10.             textBox.value = textBox.value.substring(0, allowedLength);
11.             /*  Show a message to user with the tooltip used for the textbox. */
12.             alert("Maximum characters allowed for '" + textBox.title +"' is " + allowedLength + ".");
13.         }
14.     }
15. </script>
16.     <title></title>
17. </head>
18. <body>
19.     <form id="form1" runat="server" style="vertical-align:top;">
20.     <!-- I am binding my java script to the onkeyup event of the textbox. So each time a key
21.     is pressed it will fire my javascript. -->
22.     Address <asp:TextBox ID="TextBox1" runat="server" MaxLength="10"
23.         onkeyup="RestrictLength(this);" Height="58px" TextMode="MultiLine"></asp:TextBox>
24.     </form>
25.     </body>
26. </html>
27. 
    

 

ASPX.CS

1. protected void Page_Load(object sender, EventArgs e)
2. {
3.     // Adding the attribute to the TextBox1.
4.     // Note that this is different to the MaxLength property.
5.     // Also this is not case sensitive.
6.     TextBox1.Attributes.Add("maximumlength", "10");
7.     // Adding a tooltip which is used in the message.
8.     TextBox1.ToolTip = "User Address";
9. }
10. 
    

The output will me something similar to the following.

Repairing a Corrupted Database

When we are regularly using databases, sometimes those will get corrupted. This happened to one of my applications, it was a Windows Mobile application with SQL Server CE database. Since it is running in a mobile it is bit difficult for us to fix the database using the desktop machine. I used the following .Net Compact framework code to fix the corrupted database while the database is in the mobile.

1. private void btnRepair_Click(object sender, EventArgs e)
2. {
3.     Cursor.Current = Cursors.WaitCursor;
4.     Cursor.Show();
6.     // txtDBPath will contain the path to the database.
7.     engine = new SqlCeEngine(@"Data Source=" + txtDBPath.Text + ";Password=DBPassword");
8.     try
9.     {
10.         if (!engine.Verify())
11.         {
12.             Cursor.Current = Cursors.Default;
13.             Cursor.Hide();
15.             DialogResult result = MessageBox.Show("Database is corrupted. Do you want to repair?", "My App", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
16.             if (result == DialogResult.Yes)
17.             {
18.                 Cursor.Current = Cursors.WaitCursor;
19.                 Cursor.Show();
21.                 // You can also use RepairOption.DeleteCorruptedRows.
22.                 engine.Repair(null, RepairOption.RecoverCorruptedRows);
24.                 Cursor.Current = Cursors.Default;
25.                 Cursor.Hide();
27.                 MessageBox.Show("Database repaired successfully.", "My App");
28.             }
29.         }
30.         else
31.         {
32.             Cursor.Current = Cursors.Default;
33.             Cursor.Hide();
34.             MessageBox.Show("Database is not corrupted.", "My App");
35.         }
36.     }
37.     catch (Exception ex)
38.     {
39.         Cursor.Current = Cursors.Default;
40.         Cursor.Hide();
41.         MessageBox.Show(ex.Message, "Error!");
42.     }
43. }

Next time you get a corrupted SQL CE database try it out.

Cannot connect to YouTube using iPhone

Do you guys also get the ”Cannot connect to YouTube” error on your iPhone when using the provided YouTube application?

If yes follow the steps below to get it fixed.

1. Open Cydia from your spring board.

2. Press on the Manage tab in the bottom.

3. Press on Sources, then on Edit and press again on Add to add a new source.

4. Type the URL http://apt.iphonemodding.com and press on Add Source button.

5. Now find the iPhoneModding item and press on the triangle ‘>’.

6. Scroll down and find the “Push Fix” item and press on it.

7. Press Install to get Push Fix installed on your iPhone.

8. After pressing confirm on the confirmation screen the application will get installed on your iPhone.

 

9. After a complete restart you will be able to use YouTube application within your iPhone.

Comparing SharePoint 2010 vs 2007

It is some time since the SharePoint 2010 is released and now is a good time for you to migrate to the new improved version of it. When searching the net I found some good sites which compares the 2 versions.

Read through the following sites if you are interested.

http://www.rharbridge.com/?page_id=103

http://www.khamis.net/blog/Lists/Posts/Post.aspx?ID=4

Installing and Uninstalling Internet Explorer 8

Since Internet Explorer (IE) 8 is a built-in feature of Windows Server 2008 R2 there is no way to install or uninstall it using the user interfaces. Instead you need to run the following commands in a command prompt window which has administrative privileges.

If you are only having IE in your machine as an internet browser be sure to install another internet browser before uninstalling IE, otherwise you will not be able to browse internet.

1. Click the start button and type Cmd in the search box.
2. Right click on the Cmd icon and click on Run as Administrator.
3. Choose the appropriate command from below for your need and copy it.

To Install -

dism /online /Enable-Feature /FeatureName:Internet-Explorer-Optional-amd64

To Uninstall -

dism /online /Disable-Feature /FeatureName:Internet-Explorer-Optional-amd64

or

FORFILES /P %WINDIR%\servicing\Packages /M Microsoft-Windows-InternetExplorer-8*.mum /c "cmd /c echo Uninstalling package @fname && start /w pkgmgr /up:@fname /norestart"

4. Paste the command into the command prompt windows you just opened by right clicking and clicking on Paste.
5. Press enter to run the command, when the command is successful you need to restart your machine to complete the action.

Rounding a value Down

If you did work with .Net Math classes you may have noted that you can quite easily round value upwards. But what about rounding values down?

For example if you tried to round the value 1.23501 into 2 decimal places using the Round method provided by the Math class as below, the result you will get is 1.24. Meaning .Net had rounded the value up.

1. double dbl = Math.Round(1.23501, 2);
2. 
   

If the value is rounded down it should be 1.23, but in .Net I couldn’t find an easy way to get this done. So I did create a small code to get it done. It is very simple only a method with one statement as shown below.

1. double RoundDown(double Number, int Digits)
2. {
3.     try
4.     {
5.         return Math.Truncate(Number) +
6.             (Math.Floor(Math.Round((Number % 1), Digits) * Math.Pow(10, (Math.Round((Number % 1), Digits).ToString().Length - 3)))) *
7.             (1 / Math.Pow(10, Math.Round((Number % 1), Digits).ToString().Length - 3));
8.     }
9.     catch (Exception)
10.     {
11.         MessageBox.Show("Error ! Please check values.");
12.         return 0.0;
13.     }
14. }
15. 
    

Ohh, I think this is complicated right? Please find a bit of self explanatory code below.

1. double RoundDownExplained(double Number, int Digits)
2. {
3.     try
4.     {
5.         // Get the whole number from the double value.
6.         // For example we'll take Number = 788.34567 and Digits = 3.
7.         // WholeNumberPart = 788.
8.         double WholeNumberPart = Math.Truncate(Number);
9.         // Getting the decimal part from the doouble value.
10.         // DecimalNumberPart = 0.3457.
11.         double DecimalNumberPart = Math.Round((Number % 1), Digits);
12.         // Finding the number of decimal places so we can multiply by 10 to make it suitable for Floor().
13.         // MultiplicationValue = 3.
14.         int MultiplicationValue = Math.Round((Number % 1), Digits).ToString().Length - 3;
15.         // Create the double value to round down.
16.         // RoundedDownValue = 345.
17.         double RoundedDownValue = Math.Floor(DecimalNumberPart * Math.Pow(10, MultiplicationValue));
18.         // Finding the value to devide the result to make it decimal again.      
19.         // DivisionValue = 0.001.            
20.         double DivisionValue = 1 / Math.Pow(10, MultiplicationValue);
21.         // Creating the decimal part with rounded down value.
22.         // RoundedDownValue_Float = 0.345.
23.         double RoundedDownValue_Float = RoundedDownValue * DivisionValue;
24.         // Creating the full rounded down value.
25.         // return = 788.345.
26.         return WholeNumberPart + RoundedDownValue_Float;
27.     }
28.     catch (Exception)
29.     {
30.         MessageBox.Show("Error ! Please check values.");
31.         return 0.0;
32.     }
33. }
34. 
    

The complete code of the application I created is below with a screenshot of the application running. Hope this helps to you.

1. using System;
2. using System.Text;
3. using System.Windows.Forms;
5. namespace WindowsFormsApplication1
6. {
7.     public partial class Form1 : Form
8.     {
9.         public Form1()
10.         {
11.             InitializeComponent();
12.         }
14.         double RoundDown(double Number, int Digits)
15.         {
16.             try
17.             {
18.                 return Math.Truncate(Number) +
19.                     (Math.Floor(Math.Round((Number % 1), Digits) * Math.Pow(10, (Math.Round((Number % 1), Digits).ToString().Length - 3)))) *
20.                     (1 / Math.Pow(10, Math.Round((Number % 1), Digits).ToString().Length - 3));
21.             }
22.             catch (Exception)
23.             {
24.                 MessageBox.Show("Error ! Please check values.");
25.                 return 0.0;
26.             }
27.         }
28.         double RoundDownExplained(double Number, int Digits)
29.         {
30.             try
31.             {
32.                 // Get the whole number from the double value.
33.                 // For example we'll take Number = 788.34567 and Digits = 3.
34.                 // WholeNumberPart = 788.
35.                 double WholeNumberPart = Math.Truncate(Number);
36.                 // Getting the decimal part from the doouble value.
37.                 // DecimalNumberPart = 0.3457.
38.                 double DecimalNumberPart = Math.Round((Number % 1), Digits);
39.                 // Finding the number of decimal places so we can multiply by 10 to make it suitable for Floor().
40.                 // MultiplicationValue = 3.
41.                 int MultiplicationValue = Math.Round((Number % 1), Digits).ToString().Length - 3;
42.                 // Create the double value to round down.
43.                 // RoundedDownValue = 345.
44.                 double RoundedDownValue = Math.Floor(DecimalNumberPart * Math.Pow(10, MultiplicationValue));
45.                 // Finding the value to devide the result to make it decimal again.      
46.                 // DivisionValue = 0.001.            
47.                 double DivisionValue = 1 / Math.Pow(10, MultiplicationValue);
48.                 // Creating the decimal part with rounded down value.
49.                 // RoundedDownValue_Float = 0.345.
50.                 double RoundedDownValue_Float = RoundedDownValue * DivisionValue;
51.                 // Creating the full rounded down value.
52.                 // return = 788.345.
53.                 return WholeNumberPart + RoundedDownValue_Float;
54.             }
55.             catch (Exception)
56.             {
57.                 MessageBox.Show("Error ! Please check values.");
58.                 return 0.0;
59.             }
60.         }
62.         private void button1_Click(object sender, EventArgs e)
63.         {
64.             try
65.             {
66.                 label1.Text = RoundDown(double.Parse(textBox1.Text), int.Parse(textBox2.Text) + 1).ToString();
67.             }
68.             catch (Exception)
69.             {
70.                 MessageBox.Show("Error ! Please check values.");
71.             }
72.         }
73.         private void button2_Click(object sender, EventArgs e)
74.         {
75.             try
76.             {
77.                 label2.Text = RoundDownExplained(double.Parse(textBox1.Text), int.Parse(textBox2.Text) + 1).ToString();
78.             }
79.             catch (Exception)
80.             {
81.                 MessageBox.Show("Error ! Please check values.");
82.             }
83.         }
84.     }
85. }
86.