Sunday 21 April 2013

Feature I would like to see in: iOS 6, setting default browser

An option to open my links by default within other web browsers than Safari!

Cloning a row within data bound DataGridView


Me.HCDataSet.Tables("Hotels").ImportRow(HCDataSet.Tables("Hotels").Rows(Me.DGV_Hotels.CurrentRow.Index))
Me.HotelsBindingSource.MoveLast()
Dim o As DataRowView = (CType(Me.HotelsBindingSource.Current, DataRowView)) o.Row.SetAdded()


To commit the change:
Me.HotelsTableAdapter.Update(Me.HotelsBindingSource.DataSource)





Thanks Dinos for sharing!

Monday 15 April 2013

Set default file-name to uploaded file name


    <script language="javascript" type="text/javascript">
        // Don't forget to set the textbox clientid=Static
        function Upload_FileChanged(filepath, TextBoxID) {
            var TextBox_AttachmentName = document.getElementById(TextBoxID);
            if (TextBox_AttachmentName != null) {
                if (TextBox_AttachmentName.value == "") {
                    if (filepath != null) {
                        var filename = filepath.replace(/^.*[\\\/]/, '')
                        TextBox_AttachmentName.value = filename;
                    }
                }
            }
        }
    </script>

Print Date and Time Using TSQL

PRINT LEFT(REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR, GETDATE(), 121), '-','_'),':','_'),' ','_'), 16)

16 characters on the LEFT only to omit extra time details.

Sunday 7 April 2013

Common English mistake using: Alumni

Singular male:     Alumnus
Plural male:        Alumni

Singular female:  Alumna
Plural female:     Alumnae


What about using the informal abbreviation for all?! ;)  Alum

Feature I would like to see in: iPad

Multiple profiles, especially for the e-mails, and if possible for other accounts like Facebook, Twitter,...etc.

So that when I use the device I can activate my profile while my spouse switches to her profile when she needs to use it. (A personalized experience per user)

Thursday 4 April 2013

Look-up tables design

1- No to a single look-up table:
   a - Scalability.
   b - Data Maintainability (Error prone)

2- Integrity on deletion:
   a - Deletion stored procedure with the logic to restrict deletion for consumed records.
   (The reason that foreign keys are not enough since typically they reside within a single DB; however, references are usually consumed from other DBs.) [My recommendation]
   b- Don't delete: Just mark as deleted or add a status per record to be defined by the business.
    

Monday 1 April 2013

Photo Quiz: Which country is this?!



I'm not sure whether there are also any clue to ask:
Which city is this? 

Create iPhone Tone

1- Select a music file from iTunes.

2- (Optional) Context Menu "Get Info", then set both Start Time and Stop Time.
Tip: Maximum Tone length is 40 seconds.

3) Context Menu "Create AAc Version"

4) Within iTunes Media Folder "...\iTunes Media\Music\Your Song Name", change the file extension from ".m4a" to ".m4r"

5) Drag and Drop the file into the iTunes library and sync. (You now have a new Tone in the Tones library section)