Read blob data in C# from sqlite database

Question

0.00/5 (No votes)

See more:

Hi guys, I'm new here and I'm trying to read blob data from a SQLite database and I'm not getting it. These data are from a software database that stores measurements performed by a signal acquisition board. Can anyone help me?

I'm using Visual Studio C#.

Thanks.

Claudio

What I have tried:

I don't know where to start. I can open the database and read a byte[] Array, but the next steps I don't know how to do. I have seen many explanations of how to work with binary files and images, but this is not the case.

Posted 10-Aug-21 17:12pm

CLAUDIO TASSO

Updated 10-Aug-21 20:00pm

Add a Solution

Comments

Richard MacCutchan 11-Aug-21 4:08am

You need to study the documentation for the board in question to find out what format the data is stored in.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2021-08-10T20:00:00

We can't help you - SQLite and all other databases don't know or care what is in BLOB data, it's just a stream of bytes as far as they are concerned.

And what you do to retrieve it is exactly what you are doing: fetch it as an array of bytes.
After that, it's down to what exactly was received from your signal acquisition board (which we can't see and have no idea about) and how you aggregate it before you store it in the DB (which we also can see and have no idea about!)

Start by looking at two things: the code that stores the data in the BLOB, and the signal acquisition board manual to find out what the data format(s) is / are.

We can't do any of that for you!