encrypt field in dataset......

[gmatteson]

Hello,

I am using a dataset to read an xml file, there is a password attribute in the xml field which i want to encrypt..


oDataset.ReadXml(Application.StartupPath & "\connections.xml")
cboDescription.DisplayMember = "settings_Text"
cboDescription.DataSource = oDataset.Tables("settings")
txtHost.DataBindings.Add("text", oDataset.Tables("settings"), "host")
txtUsr.DataBindings.Add("text", oDataset.Tables("settings"), "username")
txtPwd.DataBindings.Add("text", oDataset.Tables("settings"), "password")


i use the above code to bind my controls to the dataset, which reads and loads the data into the controls...

i already have my encryption function, is it possible to do something like

Decrypt(txtpwd.databindings.add("text,odataset.tables("settings"), "password"), "MYENCRYPTIONKEY")?

so that it decrypts the password and they can login?

i am using the Dataset.createxml("myfile.xml") to save the dataset to an xml file...how can i specify that all the password rows are to be encrypted? would i have to loop through them before i create the xml file ?

dim odatarow as datarow

for each odatarow in datarow(1).rows

encrypt(odatarow("password"),"mykey")
next

in theory i know how to do this but in reality, not really... any help would be appreciate thank you.