Encryption and Decryption using Asp.net and MySql

[tomcruise12345]

Hello freinds,

actually i am developing a encryption and decryption application in asp.net 2005 and mysql Database.I am implementing Rijndael algorithm.

my code perfectly works with SqlServer 2000.

but in mysql ,it is showing some problem.

actually while retriving record through datareader,i have to convert the password contained in datareader into byte[] type.but in mysql it is not converting,while it works fine with sql server.
password field datatype is varbinary.

please reply me????????


MySql.Data.MySqlClient.MySqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SingleRow);
byte[] encryptedData = (byte[])reader["CreditCardData"];

[BurgerKing]

What is the error?

[karlkatzke]

Eek. This is going to be a .Net/Connector issue. I'd reccomend figuring out exactly what error the connector is throwing, and then go post it over at the MySQL/Connector forums on mysql.com ... I really, really would not reccomend using MySQL with .Net because of the crappy, neglected state of the drivers.