Sunday, January 05, 2014


Posted on 3:37 PM by Erdem

No comments

Tuesday, December 31, 2013

http://msdn.microsoft.com/en-us/library/windowsphone/develop/gg442300(v=vs.105).aspx


Posted on 3:19 PM by Erdem

No comments

Friday, December 20, 2013

Posted on 7:57 PM by Erdem

No comments

Wednesday, December 04, 2013

Sub EraseEmptyRows()

Dim rw, i

For i = 1 To 5
' Here the loop is up to 5 meaning the maximum number of rows with no data would be 5
' Increase this number when necessary

For Each rw In Worksheets(1).Range("A1:A50").Rows
' Sweeps all cells in the range. Change the range when necessary
     If (IsEmpty(rw.Cells(1, 1))) Then rw.Delete
' Erases if the cell is empty
Next rw
' End for rw loop
Next
' End for i loop
End Sub

Posted on 7:53 PM by Erdem

No comments

Public Sub Add_Data_to_rows()
' Procedure to add data to rows
' Use this to understand how .Rows work
Dim rw
' Initiate a variable to use as rows object
For Each rw In Worksheets(3).Range("A1:C100").Rows
' Select each row starting from 1 on page 3
     rw.Cells(1, 1).Value = "ABC"
' Set the value to "ABC"
Next rw
' End for loop for rw


End Sub

Posted on 1:18 PM by Erdem

No comments


' Function to erase empty rows in excel
' !!Currently it checks second work sheet!!
' Checks the first cell and erases the entire row if the cell is empty
'Simply copy this macro to your excel file

Sub EraseEmptyRows()

Dim MyCheck, rw, this, i
For i = 1 To 50
' Scan through rows 1 to 50
For Each rw In Worksheets(2).Cells(i, 1).CurrentRegion.Rows
' Select each row starting from 1 on page 2
     this = rw.Cells(1, 1).Value
' Copy the value of A cell
     MyCheck = IsEmpty(this)
' Check if the cell is empty
     If MyCheck Then rw.Delete
' If it is, erase entire row
Next rw
' End for loop for rw
Next i
' End for loop for i

End Sub

Posted on 8:52 AM by Erdem

No comments

Thursday, November 14, 2013

http://www.codeskulptor.org/#user15_YIbLOCR8e2_12.py

Posted on 8:55 AM by Erdem

No comments

Thursday, October 31, 2013

When you create an app for windows phone, Visual Studio adds frame rate counters to visualize rate properties. To disable those, we need to open App.xaml.cs and need to set a variable to false as seen below:

// Set it to for not to display the current frame rate counters.
Application.Current.Host.Settings.EnableFrameRateCounter = false;

All required information about these counters can be found at the address:
http://msdn.microsoft.com/en-us/library/windowsphone/develop/gg588380(v=vs.105).aspx

Posted on 6:45 PM by Erdem

No comments

http://stackoverflow.com/questions/11914562/wp7-change-application-name


You change the Title of the app in the file called WMAppmanifest.xml. Inside the App xmlns-tag theres a field for Title.

Posted on 6:44 PM by Erdem

No comments

Sunday, August 04, 2013


In the following example, when the user hovers the mouse over the button, the form expands in y direction. When the user clicks on the button, the text on the button changes. 

        int size1 = 400;
        int adder = 50;

        public Form1()
        {
            InitializeComponent();
            this.button1.Text = " Change Item ";
            this.button1.Dock = DockStyle.Bottom;
            this.button1.Click +=button1_Click;
            this.button1.MouseHover += button1_Click_F2;

            this.Controls.Add(this.button1);


            this.dataGridView1.Dock = DockStyle.Top;
            this.Controls.Add(dataGridView1);
            this.Size = new Size(400, 200);

        }

        private void button1_Click(object sender, EventArgs e)
        {
            this.button1.Text = " Button1 Click is called ";
        }

        private void button1_Click_F2(object sender, EventArgs e)
        {
            
            this.Size = new Size(400, size1);
            size1 = size1 + adder;
        }

Posted on 9:18 AM by Erdem

No comments