Dear friends,
i have problem in encrypting and storing the password field in my sql server 2005 database.
i want to concat my user name and password field and then encrypt and store using md5 in c# using visual stdio 2005
can anyone please help me out......

Here maybe is something you looking for.I use MD5 class from System.Security.Cryptography namespace.
There has a method for encrypting a byte array to an MD5 encrypted byte array.Here is an example:

byte[] result, buffer;
            MD5 md5 = new MD5 CryptoServiceProvider();
            UTF8Encoding encorder = new UTF8Encoding();
            string source_str = "abcdf";                                    
            buffer = encorder.GetBytes(source_str);
            result = md5.ComputeHash(buffer);

Then,you can convert the buffer to any expected types of data.
Hope this useful:).