[sqlite] Reading Blob to file in C#

YOU ARE a LIFE SAVER man! it worked! Thank you so very much! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Reading Blob to file in C#

Hello, I've asked this question on Ssystem.Data.SQlite Forum, and after 2 days not even 1 Reply ! How can I read a blob column in C#? I have tried 4 different ways, so far no success. Does anyone have any sample code? or at least any documentation on this ???

[sqlite] sqlite Exception System.InvalidCastException: Specified cast is not valid.

This is the Code in C#: SQLiteDataReader rdr; SQLiteCommand contentCommand; String cmd = String.Format("SELECT filename,content,filesize FROM documents WHERE did={0}",did); contentCommand = sqlconn.CreateCommand();

[sqlite] Reading Blob/Writing to File in C# 2008

I still have that problem. can anyone help me in right direction? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Reading Blob/Writing to File in C# 2008

When I used your code I get: No current row If I use: rdr.Read(); before your code, I get the same exception as before. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Reading Blob/Writing to File in C# 2008

Hello, I'm Using "System.Data.SQLite" in VS 2008 C#. I'm using DataReader to read the data. Everything works find except the BLOB. I want to get that Blob and Write it to a File. Blob data is mostly Picture and Music. Here a bit of Code: did-> is the document id. String cmd =