title: ENCRYPTION DECRYPTION IN SQL with C#.NET
body: <p>I have created a Login page for my ASP.NET website project.</p>
  
  <p>Now, all I need to do is:</p>
  
  <ol>
  <li>Get the password string (that can be done easily.)</li>
  <li>Encrypt the password via C# coding (need help with that)</li>
  <li>Send the encrypted one to the SQL Server database.. (that can be done easily)</li>
  <li>Decrypt the encrypted password in SQL, with the same encryption scheme used in C# code (need help with that)</li>
  <li>and the last step, compare the password string (that also can be done easily)</li>
  </ol>
  
  <p>I have used encryption only in C# Code.</p>
  
  <p>I have also used encryption in SQL but separately, same as for C#.</p>
  
  <p>The problem where I'm stuck is: I couldn't find a solution to encrypt the password in C#, and then use the same scheme to decrypt the password but in SQL.</p>
  
  <p>Thanks, if anyone of you could help. :)</p>