Data binding in ASP.NET with multiple values per text or value field

Question

The db table has the columns 'Initials' and 'LastName'. I want to display a ListBox with the text field like "Smith, J". Is there any built-in way to achieve this?

What is your data source? Look at stackoverflow.com/questions/3098198/… and stackoverflow.com/questions/1143639/… — abatishchev
– abatishchev, Commented Mar 11, 2011 at 12:26

abatishchev · Accepted Answer · 2011-03-11 12:24:06Z

1

Why don't you concatenate the fields into one single field at the point of returning the data set from SQL? (Or which ever RDMBS you are using).

Much easier to have that kind of processing done on the database service than fandangling with .NET.

Keeps the code easier to maintain as well.

edited Mar 11, 2011 at 12:24

abatishchev

101k88 gold badges304 silver badges443 bronze badges

answered Mar 11, 2011 at 12:21

Clinton

111 bronze badge

Sign up to request clarification or add additional context in comments.

2 Comments

abatishchev Over a year ago

Don't agree. Formatting should be done on presentation level, not data layer

Clinton Over a year ago

If you think going through the rigmorole of the following code example you posted before in the above link, rather than organising the data into a singular column on the database end and binding the column to that using a single statement, then I'm not quite sure what you are doing giving out advice.

Ben · Accepted Answer · 2011-03-11 14:40:37Z

1

Use a custom databinding expression.

Consider:

<%# DataBinder.Eval(Container, "DataItem.lastName") + ", " + DataBinder.Eval(Container, "DataItem.lastName") %>

answered Mar 11, 2011 at 14:40

Ben

35.9k6 gold badges81 silver badges117 bronze badges

Comments

Thyamine · Accepted Answer · 2011-03-11 12:46:14Z

0

You can do that however you like. You could concatenate the columns in the database, creating a new column called 'LastNameFirstInitial' in addition to returning the raw data. Or you can loop through the result set and add a new ListItem for each record, setting the text and value to whatever combination of the columns you like.

Since you have the data across multiple columns there's no 'build-in way' because you're going to have to combine the columns in either ASP.Net or at the database level.

answered Mar 11, 2011 at 12:46

Thyamine

1,2587 silver badges10 bronze badges

Comments

Mmachado · Accepted Answer · 2017-11-04 23:34:12Z

I don't think you should get the solution, instead I will provide you an explanation:

<uc1:CustomTextBox
        ID="_txtSomeID"
        Text='<%# BindItem.SomeEntity.SomeField +","+BindItem.SomeEntity.SomeField%>'
    runat="server" />

Where "SomeEntity" is the table you are fetching and "SomeField" are the columns for the respective table (as some entity)

The way you bind things is completely up to you, but I advice you to use the latest frameworks. Advanced data-binding (OnNeedDataSource) is old and it is not recommended since 4.5 .NET Framework.

Edit: Also note that BindItem is a two-way bind, oppositely you can use just Item.SomeEntity.SomeColumn to do the bind one-way, for visualization purposes. Additionaly, if you are using an ORM you should specify the data source on your grid or master table.

Regards

Collectives™ on Stack Overflow

Data binding in ASP.NET with multiple values per text or value field

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related