Monthly Archives: May 2012

C# Convert string to GUID / SqlDbType.UniqueIdentifier

SqlConnection sConnection = new SqlConnection(sMesConnectionString); string sql = “INSERT INTO ACA_KC_Atps ” + “( KC_Product_ID, Atp_Version_Name, Creation_Date) ” + “VALUES ” + “(@KC_Product_ID, @Atp_Version_Name,@Creation_Date) “; SqlCommand sCommand = new SqlCommand(sql, sConnection); sCommand.Parameters.Add(“@KC_Product_ID”, SqlDbType.UniqueIdentifier).Value = new Guid(KC_Product_ID); sCommand.Parameters.Add(“@Atp_Version_Name”, SqlDbType.NVarChar).Value = Atp_Version_Name; … Continue reading

Posted in Parenting | Tagged , | Leave a comment

Quick Tip: Extract data from XML fragment

/// /// Using the user previously validated via VerifyCredentials(), /// determine whether the user is in group Administrator level 1″. /// Users can be in only one group; no looping is necessary. /// /// public bool IsUserMesAdminLevelOne() { bool result … Continue reading

Posted in Parenting | Tagged | Leave a comment

Word 2007 tip: Add dynamic target autonumbered paragraph numbers

Word 2007 tip for the busy person: Add dynamic target autonumbered paragraph numbers 1. Select the target paragraph text. Create a bookmark:¬†Insert tab / Links group / ¬†Bookmark button. Name it according to the process; not the paragraph number — … Continue reading

Posted in Word 2007 | Leave a comment

Meaning of the word “UN”

“Daddy, what does the word ‘un’ mean?” “Do you mean when you put it in front of a word, like ‘unhappy’?” “No, Daddy. Like ‘And the angel of the lord said “Un” to the shepherds in the field.’”

Posted in Parenting, Quote of the Day | 1 Comment