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
Customer Support