[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 =

[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

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

Hmmm, I know I've done this before. I'll have to dig deeper and find an example. -- Joel LucsySeysan wrote: 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

[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

The rdr is: SQLiteDataReader rdr; ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

On Tue, Jun 16, 2009 at 6:44 PM, Seysan wrote: > String cmd = String.Format("SELECT filename,content FROM documents > WHERE did={0}",did); >           contentCommand = sqlconn.CreateCommand(); >           contentCommand.CommandText = cmd; >           rdr =

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

On Tue, Jun 16, 2009 at 6:44 PM, Seysan wrote: > String cmd = String.Format("SELECT filename,content FROM documents > WHERE did={0}",did); >           rdr = contentCommand.ExecuteReader(); What type is rdr? I believe it should be byte[] -- Joel Lucsy "The dinosaurs became

[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 =