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
user26087
source
to share
2 answers
I assume you should make an alias for the selected value:
select concat(column1, column2) as concatenated from table1
0
maxnk
source
to share
select CAST(concat(column1, column2)AS CHAR)
as concatenated from table 1
+1
CARLOS
source
to share