Encryption Decryption in SQL Server 2008

Hi,

How to encrypt a text in c# and the same how to decrypt in sql server 2008.To encrypt in c# i followed below link

http://www.aspsnippets.com/Articles/AES-Encryption-Decryption-Cryptography-Tutorial-with-example-in-ASPNet-using-C-and-VBNet.aspx

But i coudn't decrypt with encrypted string what it produces in c#.

Can anyone suggest How to encrypt a text in c# and the same how to decrypt in sql server 2008 with any algorithm.

Thanks