in this video we'll show how you can

encrypt the data that you store

in a sql database when you create a list

control

with a detail view so you can see here

we have a list control

and there's our corresponding detail

view

and if we look over here we can see that

here here is the sql table

that this list is based on so right now

all of the data in this list is being

stored in

clear text so i'm going to go now and

turn on encryption

so if i go to the list itself now and

then i go to my fields tab

i can see that if i go to name i can say

that i'd like to encrypt this field

and if i go to the credit card number

field i can say i'd also like to encrypt

the field

and for each field i can specify what

the encryption key

can be so each field can have its own

encryption key

so let's go now and run this

component

and we'll make a change let's go and

edit

alpha and make this

alpha 2 and let's go and change the

credit card number to be

say um 333 and then go ahead and hit

save so there's our row is dirty

and then hit the synchronize button so

now we've written the data to the

database

and now let's go and look at what's

inside that sql table so if we go and do

a refresh here

we'll see that the name field has now

been encrypted

and the credit card number field has

also been encrypted

but when we look at the data in the list

we see the unencrypted

values so the data in the sql table

is encrypted but the list itself shows

the unencrypted value so i'm going to go

there to beta

and change that value and then go to the

credit card number

and then change that and then hit the

synchronize button so now

this second row in the table should also

be encrypted

and there we have it you can see that

the second row now

is is also encrypted so what we've shown

over here is how you can easily encrypt

individual fields

in a sql table for

[Music]

for situations where the list control

with the detail view is based on that

sql table

thanks very much for watching