System.Byte in datagrid column

Question

I am using the following query:

string query = @"SELECT r.id, user_name, user_phone, date_create, REPLACE( date_payment,  '0000-00-00 00:00:00',  'Не оплачено' ) as 
                date_payment, payment_method, amount, rs.name_ru
                FROM request AS r, request_status AS rs
                WHERE r.status = rs.id";

And i am binding datatemplate in the following way:

DataTemplate>
    <TextBlock VerticalAlignment="Center" Text="{Binding date_payment}" Width="135" />
</DataTemplate>

Its throwing correct output except the "date_payment" Its output value comes "System.Byte[]". please help!!!

Thank from MBen

class ByteArrayToString : IValueConverter
    {
        public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
        {
            if (value != null)
            {
                var listOfBytes = value as Byte[];
                string output = "";
                output = System.Text.Encoding.UTF8.GetString(listOfBytes);
                return output;
            }

            return "";
        }

        public object ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
        {
            return DependencyProperty.UnsetValue;
        }
    }

What is date_payment ? seems like Date and why does it need to be byte[] ? — V4Vendetta
– V4Vendetta, Commented Jul 16, 2012 at 9:01

MBen · Accepted Answer · 2012-07-16 09:22:20Z

2

date_payment is an Array, and you didn't provide any way for WPF for displaying it, so it calls ToString . You can provide a data converter for it.

Add a resource to your Window or page :

   <Window.Resources>
        <local:ByteArrayToString x:Key="ByteArrayConverter" />
    </Window.Resources>

Use it in your TextBlock as such :

<TextBlock VerticalAlignment="Center" Text="{Binding date_payement, Converter={StaticResource ByteArrayConverter}}" Width="135" />

Now you need to add a new class that does the conversion :

    class ByteArrayToString : IValueConverter
    {
        public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
        {
            if (value != null)
            {
                var listOfBytes = value as Byte[];
                string output ="";
                output = listOfBytes.Aggregate(output, (current, elemt) => current + elemt.ToString());
                return output;
            }

            return "";
        }

        public object ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
        {
            return DependencyProperty.UnsetValue;
        }
    }

edited Jul 16, 2012 at 9:22

answered Jul 16, 2012 at 9:06

MBen

3,99623 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

MBen Over a year ago

two seconds :). writing it up

MBen Over a year ago

local is just namepsace where I defined the ValueConverter : xmlns:local="clr-namespace:WpfApplication5". If you notice I named the class ByteArrayToString in the C# code I pasted

igni Over a year ago

i get in column integer, so "28347563728282"... pleae help :))))))))

MBen Over a year ago

you need to change the converter the display the Bytes as you want. The one I gave you just concatenates everything. Change this line output = listOfBytes.Aggregate(output, (current, elemt) => current + elemt.ToString()); to format it the way you want.

igni Over a year ago

i change output = System.Text.Encoding.UTF8.GetString(listOfBytes); and she works!!!!!! thank so very very very much!!!

Thanushka · Accepted Answer · 2012-07-16 09:04:54Z

0

This thing happened to me to. It seems this is due to a bug in the connector. Try to cast the date column to CHAR. It worked for me.

answered Jul 16, 2012 at 9:04

Thanushka

1,4556 gold badges32 silver badges56 bronze badges

Collectives™ on Stack Overflow

System.Byte in datagrid column

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related