Replace Byte[] Data Column With a String Data Column

Question

5.00/5 (1 vote)

See more:

Thanks for looking :)

I have the following situation I'm trying to remedy:

I have a DataGridView, which shows data from an arbitrary select statement. The select statement's data is returned in a DataTable, which is assigned as the DataSource for the DataGridView.

The problem occurs when a DataColumn returns Byte[] type data. I figured out how to just delete this column, which I don't consider to be a good solution.

I'd rather show a message in the DataColumn like "<Binary Data>" to the user instead of inexplicably deleting a column of data.

Is there a way of replacing the Byte[] type DataColumn with a String type DataColumn?
Is there a setting I don't know about in a DataGridView which would do this (like the DefaultNull setting, but for a Byte[] type column)?

Posted 21-Oct-10 7:37am

JessStuart

Updated 21-Oct-10 7:44am

v2

Add a Solution

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)

Abhinav S · Answer 1 · 2010-10-21T07:55:00

Solution 1

Some solutions discusses here[^] - maybe one of those can help you.

Posted 21-Oct-10 7:55am

Abhinav S

Comments

JessStuart 21-Oct-10 14:29pm

Thanks for the reply Abhinav. These answers are a little frustrating, since because they talk about solutions, but don't really supply one (i.e "For an arbitrary BLOB, the closest I can think of is to just show something like the hex... but with DataTable even that is a challenge." - this is what I need to do, but the answer doesn't show me how to do it, which I need).

Abhinav S 22-Oct-10 0:23am

Unfortunately I have not been able to find anything anywhere. If I do, I'll surely post it here.