Fw: ASP.Net, MySQL, and DataGrid Issue - Jorge Bastos - com.mysql.lists.dotnet

4 messages in com.mysql.lists.dotnetFw: ASP.Net, MySQL, and DataGrid Issue

From	Sent On	Attachments
Jesse	29 Jun 2006 10:58
Jorge Bastos	29 Jun 2006 11:22
Jesse	29 Jun 2006 12:02
Jorge Bastos	29 Jun 2006 15:16

Subject:	Fw: ASP.Net, MySQL, and DataGrid Issue
From:	Jorge Bastos (mysq...@decimal.pt)
Date:	06/29/2006 11:22:49 AM
List:	com.mysql.lists.dotnet

Happened to my also in winforms app I resolved it with: SELECT I.InvoiceNo, I.InvoiceDate, I.NatTotal, I.StateTotal, convert(I.NatTotal + I.StateTotal As TotDue to utf8), I.NatPaid + I.StatePaid As TotPaid, I.NatTotal + I.StateTotal - I.NatPaid - I.StatePaid As Due,A.FirstName, A.LastName, A.City, A.State, A.ID FROM AlumniInvoices I JOIN Alumni A ON I.AlumniID=A.ID

--- convert(I.NatTotal + I.StateTotal As TotDue to utf8)

---

use the charset you want

did it work? at least for me yes

In my ASP.NET application, I have the following MySQL 5 Query:

SELECT I.InvoiceNo, I.InvoiceDate, I.NatTotal, I.StateTotal, I.NatTotal + I.StateTotal As TotDue, I.NatPaid + I.StatePaid As TotPaid, I.NatTotal + I.StateTotal - I.NatPaid - I.StatePaid As Due,A.FirstName, A.LastName, A.City, A.State, A.ID FROM AlumniInvoices I JOIN Alumni A ON I.AlumniID=A.ID

I have this bound to a DataGrid object. In the columns that use the TotDue, TotPaid, and Due columns, it displays, "System.Byte[]". Why is this happening, and how to I fix it?