Arjuna

Tuesday, November 02, 2010

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.

// Comparer Class.
 public class SPFilesComparer : IComparer
 {
     #region IComparer Members
     public int Compare(object object1, object object2)
     {
         return new CaseInsensitiveComparer().Compare(((SPFile)object1).TimeCreated, ((SPFile)object2).TimeCreated);
     }
     #endregion
 }
 

ArrayList fileList = new ArrayList(attachFiles);
 IComparer compFiles = new SPFilesComparer();
 // Do the sorting based on the SPFilesComparer.
 fileList.Sort(compFiles);
 
 foreach (SPFile attachFile in fileList)
 {
     // Use the sorted list.
 }
 

Friday, October 22, 2010

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.

Saturday, October 02, 2010

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

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

ASPX.CS

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

The output will me something similar to the following.

Saturday, September 18, 2010

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.

 private void btnRepair_Click(object sender, EventArgs e)
 {
     Cursor.Current = Cursors.WaitCursor;
     Cursor.Show();
 
     // txtDBPath will contain the path to the database.
     engine = new SqlCeEngine(@"Data Source=" + txtDBPath.Text + ";Password=DBPassword");
     try
     {
         if (!engine.Verify())
         {
             Cursor.Current = Cursors.Default;
             Cursor.Hide();
 
             DialogResult result = MessageBox.Show("Database is corrupted. Do you want to repair?", "My App", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
             if (result == DialogResult.Yes)
             {
                 Cursor.Current = Cursors.WaitCursor;
                 Cursor.Show();
 
                 // You can also use RepairOption.DeleteCorruptedRows.
                 engine.Repair(null, RepairOption.RecoverCorruptedRows);
 
                 Cursor.Current = Cursors.Default;
                 Cursor.Hide();
 
                 MessageBox.Show("Database repaired successfully.", "My App");
             }
         }
         else
         {
             Cursor.Current = Cursors.Default;
             Cursor.Hide();
             MessageBox.Show("Database is not corrupted.", "My App");
         }
     }
     catch (Exception ex)
     {
         Cursor.Current = Cursors.Default;
         Cursor.Hide();
         MessageBox.Show(ex.Message, "Error!");
     }
 }

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

Friday, August 13, 2010

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.

Monday, August 09, 2010

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

Sunday, August 08, 2010

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.

Click the start button and type Cmd in the search box.
Right click on the Cmd icon and click on Run as Administrator.
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"

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

Tuesday, August 03, 2010

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.

       
double dbl = Math.Round(1.23501, 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.

       
       
        
double RoundDown(double Number, int Digits)
{
    try
    {
        return Math.Truncate(Number) +
            (Math.Floor(Math.Round((Number % 1), Digits) * Math.Pow(10, (Math.Round((Number % 1), Digits).ToString().Length - 3)))) *
            (1 / Math.Pow(10, Math.Round((Number % 1), Digits).ToString().Length - 3));
    }
    catch (Exception)
    {
        MessageBox.Show("Error ! Please check values.");
        return 0.0;
    }
}
           
        
       

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

       
       
        
double RoundDownExplained(double Number, int Digits)
{
    try
    {
        // Get the whole number from the double value.
        // For example we'll take Number = 788.34567 and Digits = 3.
        // WholeNumberPart = 788.
        double WholeNumberPart = Math.Truncate(Number);
        // Getting the decimal part from the doouble value.
        // DecimalNumberPart = 0.3457.
        double DecimalNumberPart = Math.Round((Number % 1), Digits);
        // Finding the number of decimal places so we can multiply by 10 to make it suitable for Floor().
        // MultiplicationValue = 3.
        int MultiplicationValue = Math.Round((Number % 1), Digits).ToString().Length - 3;
        // Create the double value to round down.
        // RoundedDownValue = 345.
        double RoundedDownValue = Math.Floor(DecimalNumberPart * Math.Pow(10, MultiplicationValue));
        // Finding the value to devide the result to make it decimal again.       
        // DivisionValue = 0.001.             
        double DivisionValue = 1 / Math.Pow(10, MultiplicationValue);
        // Creating the decimal part with rounded down value.
        // RoundedDownValue_Float = 0.345.
        double RoundedDownValue_Float = RoundedDownValue * DivisionValue;
        // Creating the full rounded down value.
        // return = 788.345.
        return WholeNumberPart + RoundedDownValue_Float;
    }
    catch (Exception)
    {
        MessageBox.Show("Error ! Please check values.");
        return 0.0;
    }
}
           
        
       

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

       
       
        
using System;
using System.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        double RoundDown(double Number, int Digits)
        {
            try
            {
                return Math.Truncate(Number) +
                    (Math.Floor(Math.Round((Number % 1), Digits) * Math.Pow(10, (Math.Round((Number % 1), Digits).ToString().Length - 3)))) *
                    (1 / Math.Pow(10, Math.Round((Number % 1), Digits).ToString().Length - 3));
            }
            catch (Exception)
            {
                MessageBox.Show("Error ! Please check values.");
                return 0.0;
            }
        }
        double RoundDownExplained(double Number, int Digits)
        {
            try
            {
                // Get the whole number from the double value.
                // For example we'll take Number = 788.34567 and Digits = 3.
                // WholeNumberPart = 788.
                double WholeNumberPart = Math.Truncate(Number);
                // Getting the decimal part from the doouble value.
                // DecimalNumberPart = 0.3457.
                double DecimalNumberPart = Math.Round((Number % 1), Digits);
                // Finding the number of decimal places so we can multiply by 10 to make it suitable for Floor().
                // MultiplicationValue = 3.
                int MultiplicationValue = Math.Round((Number % 1), Digits).ToString().Length - 3;
                // Create the double value to round down.
                // RoundedDownValue = 345.
                double RoundedDownValue = Math.Floor(DecimalNumberPart * Math.Pow(10, MultiplicationValue));
                // Finding the value to devide the result to make it decimal again.       
                // DivisionValue = 0.001.             
                double DivisionValue = 1 / Math.Pow(10, MultiplicationValue);
                // Creating the decimal part with rounded down value.
                // RoundedDownValue_Float = 0.345.
                double RoundedDownValue_Float = RoundedDownValue * DivisionValue;
                // Creating the full rounded down value.
                // return = 788.345.
                return WholeNumberPart + RoundedDownValue_Float;
            }
            catch (Exception)
            {
                MessageBox.Show("Error ! Please check values.");
                return 0.0;
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                label1.Text = RoundDown(double.Parse(textBox1.Text), int.Parse(textBox2.Text) + 1).ToString();
            }
            catch (Exception)
            {
                MessageBox.Show("Error ! Please check values.");
            }
        }
        private void button2_Click(object sender, EventArgs e)
        {
            try
            {
                label2.Text = RoundDownExplained(double.Parse(textBox1.Text), int.Parse(textBox2.Text) + 1).ToString();
            }
            catch (Exception)
            {
                MessageBox.Show("Error ! Please check values.");
            }
        }
    }
}
           
        
       

Saturday, July 31, 2010

Error Accessing Path

Today is a day full of errors, when I fixed one error another error came while trying to run my hosted application. This time it was “Access to the path 'C:\inetpub\wwwroot\……’ is denied.

Full error is as follows,

Access to the path 'C:\inetpub\wwwroot\Mining2 Setup\Images\temp\tempImage.png' is denied.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.UnauthorizedAccessException: Access to the path 'C:\inetpub\wwwroot\Mining2 Setup\Images\temp\tempImage.png' is denied.

The issue here was generated by a code written in my application which tries to access an image named tempImage.png in the said folder (Images\temp).

The reason for this is when you install IIS 7 the account used by the application pool (IIS_IUSRS) is not given access to the folder Images\temp. Since it is created by the application I just installed.

To sort out the issue give write permission to the folder Images\temp for the account IIS_IUSRS using the security tab in the folder properties page.

Friday, July 30, 2010

Error when Installing MSI

Recently when trying to install a setup I made for a project on a new server having Windows Server 2008 R2 I continuously encountered an error as of below.

“The installer was interrupted before “Application” could be installed. You need to restart the installer to try again.”

image_thumb[2]

The server had IIS 7, .Net Framework 3.5 and 4 installed. After putting in some time onto this I found out that this is because the II6 Management Compatibility services was not installed for the Web Server role.

To fix it simply open the Server Manager and open up Web Server role and click on Add Role Services.

Then select IIS 6 Management Compatibility node and all the child nodes below in under the Management Tools parent node and press next.

When the installation is complete the setup will work as desired.

image_thumb[4]

Friday, July 23, 2010

Changing the Control Style at Runtime using the ASPX

Recently I changed the style of some controls in my ASPX page at runtime based on the values set on another control in my page. For example the color of the table is changed based on the radio button that was selected and the color of the button is changed according to the text that was typed in the textbox. Hope this is helpful.

       
       
        
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Changing the Control Style</title>
     <style type="text/css">
        .Style1
        {
            background-color: Red;
        }
        .Style2
        {
            background-color: Blue;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
        <asp:RadioButton ID="RadioButton1" runat="server" Text="Red" GroupName="1" Checked="True" AutoPostBack="True" />
        <asp:RadioButton ID="RadioButton2" runat="server" Text="Blue" GroupName="1" AutoPostBack="True" />
        <!-- Styling the table based on the radio button selection. -->
        <table class="<% if(RadioButton1.Checked) { %> Style1 <% } else { %> Style2 <% } %>">
            <tr>
                <td> &nbsp; See the change... </td>
            </tr>
            <tr>
                <td> &nbsp; </td>
            </tr>
        </table>
        <asp:TextBox ID="TextBox1" runat="server" MaxLength="3"></asp:TextBox>
        <!-- Styling the button based on the textbox value. -->
        <input id="Button1" type="submit" value="button" 
               class="<% if(TextBox1.Text=="") { %> Style1 <% } else { %> Style2 <% } %>" />
    </form>
</body>
</html>
           
        
       

Output looks as below.

Tuesday, July 20, 2010

Cure for HIV/AIDS

Even though very little publicity was given a great medical finding was done by an American Doctor working in Berlin to find a cure for HIV/AIDS or Human Immunodeficiency Virus / Acquired Immune Deficiency Syndrome.

As per the articles a stem cell transplant from a donor who had a gene mutation known as “CCR-5 Delta- 32” cured a patient with HIV infection with no traces of HIV after two years of the transplant.

At the moment a transplant is much riskier thing to do since it involves of destroying and rebuilding the patients’ immune system. But this case of success will open up new ways to think and will help finding more safe and solid cures for HIV/AIDS in the near future.