http://codehutch.com Online Code Repository Thu, 01 Dec 2011 10:27:17 +0000 http://backend.userland.com/rss092 en Reversing a string in C# is quite easy. The main concept is to treat the string as an array of characters, which is already built-in in C#, and transfer each character to new container in reverse order. Here are the samples of simple and straightforward functions on how to reverse ... http://codehutch.com/2011/12/c-reverse-a-string/ XOR (Exclusive OR, EOR, EXOR) is a logical operation which results to a true value if exactly one of the two operands has a value of true. Sample XOR Table INPUT OUTPUT A B A ^ B 0 0 0 0 1 1 1 0 1 1 1 0 Using this knowledge we can encrypt characters using their binary values. Take for example the string "ENCRYPT". First, we take ... http://codehutch.com/2011/11/xor-encryption/ T-SQL can be a powerful tool for developers if exploited. It allows you to programatically manipulate your data on the "database-level". This post will show a simple T-SQL script on how to create a recursive user-defined function [UDF] that can be used application-wide via a simple query. To demonstrate, we ... http://codehutch.com/2011/10/recursive-user-defined-function-in-t-sql/ Here is a sample source code on how to read and load xml file via LINQ, extract the data [using a query] and export it to a CSV file. The XML file (employee.xml) <xml> <Employee id="1"> <Name>John Doe</Name> <Position>President</Position> <Salary>$500,000</Salary> </Employee> <Employee id="2"> <Name>Jane Doe</Name> <Position>Vice President</Position> <Salary>$250,000</Salary> </Employee> <Employee id="3"> <Name>Jen Doe</Name> <Position>Manager</Position> <Salary>$50,000</Salary> </Employee> </xml> The code 'Libraries Imports System Imports System.IO Imports System.Text Imports System.Xml.Linq Imports Microsoft.VisualBasic.FileIO '===================================== 'Read/Load xml file Dim employees As XElement ... http://codehutch.com/2011/10/export-xml-into-a-comma-delimited-csv-file/ There are cases where using Cursor would do you more harm than good. It uses considerably large amount of resources in your server and not to mention that it can cause leaks if not used correctly (Eg. Open without corresponding Close). That's why most T-SQL developer often suggest to avoid ... http://codehutch.com/2011/10/using-while-loop-instead-of-cursor/ This source code shows how to lock a certain routine so it cannot be accessed/used by another process. To demonstrate this, we will use Threads. using System; using System.Threading; class ThreadLock { private int Tests = 0; public void TestRun() { Thread t1 = new Thread(new ThreadStart(Exec)); t1.Name = "thread 1"; Thread t2 = new Thread(new ThreadStart(Exec)); t2.Name = ... http://codehutch.com/2011/10/how-to-lock-a-routine/ This is a sample function on how to move a file from one folder/directory to another while considering some factors such as: Is the file available? Or is it being used by another process? Does the file exists? Does a file with the same filename exists in the destination folder? Move File ... http://codehutch.com/2011/10/moving-a-file-from-one-folderdirectory-to-another/ When working with MSSQL, there are cases where your simple stored procedure (SP) just won't work when deployed to your live server even though it works perfectly on your local PC. I have encountered this problem a couple of days ago where my SP won't work on Windows Azure SQL. ... http://codehutch.com/2011/09/mssql-split-as-an-alternate-to-openxml/ I'm currently using Telerik Treeview and I'm fascinated on how great its features are.  I have an example on NodeClick event. Highlight parent/s when a node is clicked The Treeview <telerik:RadTreeView ID="MyTreeview" MultipleSelect="true" OnNodeClick="MyTreeviewClick" /> Note: MultipleSelect must be set to True The Click routine Protected Sub MyTreeviewClick(sender As Object, e As RadTreeNodeEventArgs) SelectParent(e.Node) End Sub Highlight parent function Protected ... http://codehutch.com/2011/05/telerik-treview-nodeclick-event/ When working on customized Gridview (especially when you're planning to use it multiple times within your solution), you can always create your own class by extending the default Gridview.  So instead of putting all properties inside <asp:GridView> tag like this: <asp:GridView ID="MyOwnGridViewID" runat="server" CssClass="MyOwnGridViewClass" AllowPaging="true" PageSize="25"> <!-- As well as other properties ... http://codehutch.com/2011/03/extending-gridview-class/