Editing Data just before binding it to DropDownList Control

[jetar]

Below is some code where I execute a query on a column and it returns all the necessary values which I then bind to a drop down list as both the text values and actual values. But right before I bind these value I need to Trim() all of them to get rid of whitespace. Does anyone know how to alter the data that is about to be bound right before i bind it?

OleDbCmd.CommandText = "SELECT DISTINCT client_id FROM CoreProcessRange"

        cConnection.Open()

        lstClientid.DataSource = OleDbCmd.ExecuteReader()
        lstClientid.DataTextField = "client_id"
        lstClientid.DataValueField = "client_id"
        lstClientid.DataBind()

 

[jetar]

To elaborate a little more, basically what I need to do is run trim() on every value just before it is inserted into the drop down list, which would be simple and striaghtforward if I was using a loop to cycle through each value and could just trim them as they came along.

However since I am setting the DataTextField and DataValueFields and then binding them I am not sure how to alter all of the contents before the list is populated.

I have tried doing: .DataTextField.Trim(), but this is not working and I am not completely sure what action it actually performs. Thats all, thanks.