开发者

C# Replacing value in datatable

开发者 https://www.devze.com 2023-04-09 16:30 出处:网络
Scenario: App contains DataGridViews, I am populating the DataGridViews from a Database. All the data in the Database is encrypted so after I fill my DataTable开发者_如何学运维 I need to cycle

Scenario: App contains DataGridViews, I am populating the DataGridViews from a Database. All the data in the Database is encrypted so after I fill my DataTable开发者_如何学运维 I need to cycle through every entry in the DataTable through the decryption methods and place back in the same spot in the DataTable. How would I do such a task? Or is there a way I can decrypt the data as it is entering the dataTable?

SQLiteDataAdapter dataAdapter = new SQLiteDataAdapter(query, conn);
SQLiteCommandBuilder commandBuilder = new SQLiteCommandBuilder(dataAdapter);
DataTable dataTable = new DataTable();
dataTable.Locale = System.Globalization.CultureInfo.Invaria…
dataAdapter.Fill(dataTable);
//Decrypt cells
int i;
foreach (DataRow row in dataTable.Rows)
{
i = 0;
    foreach (var item in row.ItemArray)
    {
        //This doesn't work
        row.ItemArray[i] = Crypto.Decrypt(item.ToString());
        i++;
    }
}
return dataTable;


for (int i = 0; i < dataTable.Rows.Count; i++)
{
    for (int j = 0; j < dataTable.Columns.Count; j++)
    {
        dataTable.Rows[i][j] = Crypto.Decrypt(dataTable.Rows[i][j].ToString());
    }
}
0

精彩评论

暂无评论...
验证码 换一张
取 消