locked
decrypt data and showing it on the datagrid RRS feed

  • Question

  • hi..im new to datagrid and im wondering is there a way to decrpt data from Microsof Access and then show it in datagrid?

    normally this is how to show data in datagrid:

        sql = "SELECT * FROM tbPjhp"
        
        Set rs = New ADODB.Recordset
        rs.CursorLocation = adUseClient
        rs.Open sql, DB, adOpenDynamic, adLockOptimistic
        
        Set DataGrid1.DataSource = rs

    what should i do to decrypt those data before showing it in the datagrid?

    my database got name, address, and phoneNumber.

    Thanks.

    Sunday, December 2, 2012 6:49 PM