Customize Before Databinding

[Peter Osawa]

Hi,

I'm filling a DropDownList with a database data with Databind.

The list is a lot of languages, and I would like to add a string before
each field.

If I do ddlLanguages.DataTextField = "MyString" + "DB_FIELD"; I get an
error, normal...

How do I add what I want before or after de databse info ?

TIA

[Davide Vernole [MVP]]

Peter Osawa <po****@sun.es> typed:

Hi,
I'm filling a DropDownList with a database data with Databind.
The list is a lot of languages, and I would like to add a string
before each field.
If I do ddlLanguages.DataTextField = "MyString" + "DB_FIELD"; I get an
error, normal...
How do I add what I want before or after de databse info ?

You can do this in the SELECT, directly in your stored procedure o SQL
statement. Like this:

SELECT 'MyString' + DB_FIELD AS LanguageField FROM DB_TABLE

--
Davide Vernole
MVP ASP/ASP.NET
Microsoft Certified Solution Developer

[Peter Osawa]

That's the way I was doing until today, but I want to remove all strings
from code or SPs...

Davide Vernole [MVP] wrote:

Peter Osawa <po****@sun.es> typed:

Hi,
I'm filling a DropDownList with a database data with Databind.
The list is a lot of languages, and I would like to add a string
before each field.
If I do ddlLanguages.DataTextField = "MyString" + "DB_FIELD"; I get an
error, normal...
How do I add what I want before or after de databse info ?

You can do this in the SELECT, directly in your stored procedure o SQL
statement. Like this:

SELECT 'MyString' + DB_FIELD AS LanguageField FROM DB_TABLE

[tribal]

Peter,

why not have a custom collection class, fill it up with
data from the database and bind the dropdownlist with an
object of this class

You can manipulate the properties in the class once
filled up

-----Original Message-----
That's the way I was doing until today, but I want to remove all stringsfrom code or SPs...

Davide Vernole [MVP] wrote:

Peter Osawa <po****@sun.es> typed:

Hi,
I'm filling a DropDownList with a database data with Databind.The list is a lot of languages, and I would like to add a stringbefore each field.
If I do ddlLanguages.DataTextField = "MyString" + "DB_FIELD"; I get anerror, normal...
How do I add what I want before or after de databse

info ?

You can do this in the SELECT, directly in your stored procedure o SQL statement. Like this:

SELECT 'MyString' + DB_FIELD AS LanguageField FROM DB_TABLE

.

[Peter Osawa]

Thanks Peter, I will try that way