在sql中连接之前尝试修剪单个字段值，例如：

try trimming the individual field values before concatenating them in sql, example:

SELECT RTRIM(LTRIM(fieldname)) FROM table1

但是，我建议将它们留在gridview中自己的列中。

However, I would suggest leaving them in their own columns in the gridview.