Error retrieving and binding to datagridview from mysql stored procedure using concat ()

Question

Error retrieving and binding to datagridview from mysql stored procedure using concat ()

Every time I retrieve data from a mysql stored procedure using the concat function, an error occurs after binding the datagridview to the datatable that contains the returned rows.

0

mysql .net datagridview

user26087 Dec 15. '08 at 17:41

source to share

2 answers

select CAST(concat(column1, column2)AS CHAR)

as concatenated from table 1

+1

CARLOS Apr 20 11 at 14:33

source to share

maxnk · Accepted Answer · 2008-12-15T18:14:45+0000

I assume you should make an alias for the selected value:

select concat(column1, column2) as concatenated from table1

Error retrieving and binding to datagridview from mysql stored procedure using concat ()

More articles: