Hi
We are working on ASP.NET back end database SqlServer 2000.

We are encrypting the data in binary format and storing into database without any proble.But while doing the decrypt we need to retrive binary data from database and need to pass our decrypt function.here we are facing proble.when we try to fetch data from databse its always saying nodata error.but when we open table its showing rows.Here actually we need to pass byte datatype to decrypt function.

Basically i want these two steps

1.Retriving binary(encrypted) data from table
2.decryption of retrived data and displaying in datagrid or table.

table name test
columns
fld1 binary 50
fld2 binary 50


for encrypt and decrypt below function are using

private byte[] EncryptText( ICryptoTransform Encryptor, string Data )
        {
            using( MemoryStream dataStream = new MemoryStream() )
            {
                // encrypt data with received symmetric key
                using( CryptoStream streamEncrypt = new CryptoStream( dataStream, Encryptor, CryptoStreamMode.Write ) )
                {
                    using( StreamWriter encryptStreamWriter = new StreamWriter( streamEncrypt ) )
                    {
                        encryptStreamWriter.Write( Data );
                        encryptStreamWriter.Close();
                    }
                    streamEncrypt.Close();
                }
                byte[] encryptedData = dataStream.ToArray();
                dataStream.Close();
                return encryptedData;
            }
        }

        private string DecryptText( ICryptoTransform Decryptor, byte[] Data )
        {
            using( MemoryStream receivedStream = new MemoryStream( Data ) )
            {
                string text;
                // decrypt data with symmetric key
                using( CryptoStream streamDecrypt = new CryptoStream( receivedStream, Decryptor, CryptoStreamMode.Read ) )
                {
                    StreamReader decryptStreamReader = new StreamReader( streamDecrypt );
                    text = decryptStreamReader.ReadToEnd();
                    // do not call close method for StreamReader or CryptoStream if CryptoStream opened in Read mode
                    // "Stream doesn't support writing" error will be generated
                    // decryptStreamReader.Close();
                    // streamDecrypt.Close();
                }
                receivedStream.Close();
                return text;
            }
        }