StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
9269684
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
8
CommunityOwnedDate
CreationDate
2012-02-13T23:34:41.440
FavoriteCount
0
LastActivityDate
2012-02-15T07:15:55.103
LastEditDate
2012-02-15T07:15:55.103
LastEditorUserId
531098
OwnerUserId
531098
ParentId
9268952
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
I'm afraid that there is no "magic" function that will do this for both your server and the client. It is not hard to write a simple encryption / decryption scheme that will work across both though, since the algorithms are standard. Building your own will also help you to understand how the encryption and decryption works in your software. For .NET, you can use the System.Security.Cryptography namespace and for Win32 you should use the <a href="http://msdn.microsoft.com/en-us/library/windows/desktop/aa380255%28v=vs.85%29.aspx" rel="nofollow">CryptoAPI</a>. As for the encryption scheme, going by your use case, you can use a simple symmetric encryption scheme. Encryption: <ol> <li>Hash the user password together with a constant salt to create a 32-bit buffer. You can use SHA256 for this. The CryptoAPI SHA256 is only supported XP SP3 and up though. Otherwise you can find many open source implementations online.</li> <li>Take the first 16-bytes as the key and last 16 as the IV.</li> <li>Use the <a href="http://msdn.microsoft.com/en-us/library/windows/desktop/aa386979%28v=vs.85%29.aspx" rel="nofollow">AES CryptoProvider</a> in the CryptoAPI to do the encryption using the key and the IV.</li> </ol> Decryption: <ol> <li>and 2. will be same as for encryption. .NET has built in classes for <a href="http://msdn.microsoft.com/en-us/library/system.security.cryptography.sha256.aspx" rel="nofollow">SHA256</a> that you can use for this. Doing these steps should give you the same key as you have during encryption.</li> <li>Use the <a href="http://msdn.microsoft.com/en-us/library/system.security.cryptography.aescryptoserviceprovider.aspx" rel="nofollow">AesCryptoServiceProvider</a> class to decrypt the data, using the key and the IV. See example here: <a href="https://gist.github.com/1833986" rel="nofollow">https://gist.github.com/1833986</a> (this one doesn't use any salt).</li> </ol>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POWhat's a simple way to encrypt and decrypt strings with a user-supplied password that works in both native Win32 and .NET?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCan Gencer
UserOwnerUserId
1. USCan Gencer
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POWhat's a simple way to encrypt and decrypt strings with a user-supplied password that works in both native Win32 and .NET?
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.