private void ShowList()
{
using (var ds = new DataSet())
{
ds.ReadXml(Server.MapPath("~/Patient.xml"));
foreach (DataTable table in ds.Tables)
{
foreach (DataRow row in table.Rows)
{
var emailCrypted = EncryptionServices.Decrypt(row["Email"].ToString(), "Email");
var telpehoneCrypted = EncryptionServices.Decrypt(row["Telephone"].ToString(), "Telephone");
row["Email"] = emailCrypted;
row["Telephone"] = telpehoneCrypted;
}
}
if (ds.Tables.Count > 0)
{
gvPatients.DataSource = ds.Tables[0];
gvPatients.DataBind();
}
}
}