CODEWITHSUNDEEP
c#data-binding
Joe W
Joe W

Reputation: 1567

Is there a way to Append the DataTextField of a Listbox in aspx C#?

I have a data bound listbox that lists names of items, I am now wanting to display both the item number and the Item name in something that looks like: i-001 - Item 1. I have done something similar to this, but it was when I was not using data text fields, but iDataReaders instead.

so can I append the datatextfield attribute in anyway to accept more than one column? Either in the aspx page or in the code behind?

If there is any code that can be of help I can provide it to you, if there is any clearing up that can be done I will do my best to do so.

Thank you

Sample Code:

listItems.DataSource = DAL.Util.getItemProfiles(vendor,catalog);
listItems.DataBind();


public string ItemNumName
{
    get { return "CustItemNum" + " - " + "Name"; }
}

protected void listItems_DataBound(object sender, EventArgs e)
{
    listItems.DataTextField = ItemNumName;
}

this cause the following error message:

DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'CustItemNum - Name'.

If I remove the + " - " + "Name" from the property it functions correctly by showing just the CustItemNum field

Upvotes: 1

Views: 1021

Answers (3)

John
John

Reputation: 134

you could also edit your sql to concatenate the two columns and then use that as your datatextfield. Using provided variable names it would look something like:

Select CustItemNum, Name,  CustItemNum + ' - ' + Name AS NumberName

then you should be able to use NumberName as the DataTextField and it should display like "itemNumber - itemName"

Upvotes: 1

anouar.bagari
anouar.bagari

Reputation: 2104

You can add a new property to your model that combines the two fields and use it as datavalue

  public string SomeProperty
  {
      get{return  itemnumber + "-"+ itemName ; }
  }

Upvotes: 1

user1921
user1921

Reputation:

You can do this in the OnDataBound event of the ListBox. Examples here: http://asp-net-example.blogspot.com/2011/07/how-to-use-listbox-ondatabound-event-in.html

 protected void ListBox1_DataBound(object sender, EventArgs e)  
    {  
//... your logic here to set the text of the item
}

Upvotes: 1

Related Questions