4 messages in com.mysql.lists.dotnetASP.Net, MySQL, and DataGrid Issue
FromSent OnAttachments
Jesse29 Jun 2006 10:58 
Jorge Bastos29 Jun 2006 11:22 
Jesse29 Jun 2006 12:02 
Jorge Bastos29 Jun 2006 15:16 
Subject:ASP.Net, MySQL, and DataGrid Issue
From:Jesse (jl@msdlg.com)
Date:06/29/2006 10:58:22 AM
List:com.mysql.lists.dotnet

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?