How do i remove the trailing white space on DataBind?

[mrgulic]

I have the following code that gets data from SQL2K5. I have tried setting the ANSI padding is FALSE and i have tried nchar and nvarchar, but they all keep the space. I read that MS recomends leaveing the whitespace and removing it at the application level, which is why I am here.

ddl_deviceType.DataSource = dbu.GetSqlDataReader(sqlDatasource, sqlCatalog, sqlSecurity, sqlSelect);
ddl_deviceType.DataValueField = "device_type_id";
ddl_deviceType.DataTextField = "device_type_name";
ddl_deviceType.DataBind();
ddl_deviceType.Items.Insert(0, new ListItem("- Select Device Type -"));

I have tried

ddl_deviceType.DataTextField = "device_type_name".Trim();

but it didnt make a difference.

Thanks for your insight.

 

[PatrickIRL]

You could try in your SELECT statement using
RTRIM(fieldname) which would remove any trailing spaces.

Patrick