Trim Dropdown box with an ObjectDataSource and FileDataSet

Posted on 2006-04-24
Medium Priority
Last Modified: 2008-03-10
I am using an objectdatasource and a filedataset page to populate a dropdown menu form a database. It works greate but the value has a bunch of trailing whitespaces. How do I trim it so the value does not have the white spaces?
Question by:jui2ce
LVL 29

Accepted Solution

David H.H.Lee earned 2000 total points
ID: 16527212
You can always trim the value in sql server level. That's the most cleanest way to solve the problem.
select ltrim(rtrim(name)),userid from tbluser ' mssql

Author Comment

ID: 16530232
Worked like a charm. THANKS

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the pain points with developing AJAX, JavaScript, JQuery, and other client-side behaviors is that JavaScript doesn’t allow for cross domain request for pulling content. For example, JavaScript code on www.johnchapman.name could not pull conte…
ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
In this video I will demonstrate how to set up Nine, which I now consider the best alternative email app to Touchdown.
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
Suggested Courses
Course of the Month3 days, 20 hours left to enroll

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question