Label in datalist in C#

Question

3.00/5 (2 votes)

See more:

Hi friends,

in my hr project i used datalist,
which is like this

Leave  | balance | used
  sl   |       6 |    3
  cl   |       6 |    0
  pl   |      15 |    0
  lwp  |       - |    0

now from this datalist i want to add new column (balance-used) from datalist.

result like this

XML

Leave  | balance | used   |remained
  sl   |       6 |    3   |3
  cl   |       6 |    0   |6
  pl   |      15 |    0   |15
  lwp  |       - |    0   |-

so how can i do this.

Posted 1-Sep-12 1:23am

aarohi verma

Updated 5-Sep-12 20:52pm

WebMaster

v4

Add a Solution

Comments

Devang Vaja 1-Sep-12 7:31am

are u filling datalist dynamically?

aarohi verma 1-Sep-12 7:42am

no. fetching from two different tables.

AmitGajjar 1-Sep-12 8:11am

what does balance-used mean ? balance and used both of the columns are present.

Devang Vaja 1-Sep-12 9:22am

i think she want a column name Balance-used means there will be 4 collumns..

if balance-used column is not in db than fill it dynamically and add this column dynamically by calculation with javscript or any other thing...

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

dbaseman · Answer 1 · 2012-09-01T10:04:00

The easiest way is probably to add a binding expression that does the subtraction. Let's say your existing DataList ItemTemplate code looks like this:

ASP

<itemtemplate>
  <tr>
    <td><![CDATA[<%# DataBinder.Eval(Container.DataItem, "Leave") %>]]></td>
    <td><![CDATA[<%# DataBinder.Eval(Container.DataItem, "balance") %>]]></td>
    <td><![CDATA[<%# DataBinder.Eval(Container.DataItem, "used") %>]]></td>
  </tr>
</itemtemplate>

Then, add the expression like this:

ASP

<table><tbody><tr><td><![CDATA[<%# (Container.DataItem as MyClass).balance - (Container.DataItem as MyClass).used %>]]></td></tr></tbody></table>

Where MyClass is the name of your data item class.

Silent Guardian · Answer 2 · 2012-09-06T22:34:00

create a class say Data and fill it with column names.

C#

Class Data
{
public string Leave { get; set; }
public string Balance { get; set; }
public string Used { get; set; }
public string Remain  { get; set; }
}

create a list of type Data

C#

List<Data> DataList = new List<Data>();

Now Create object of class Data and add it to list.

C#

DataList.Add(new Data{Leave=<value>,Balance="<value>",Used="<value>",Remain="<value>"});

Each element in this list corresponds to a row.
U can even directly set the Datasource of any collection acceptable Gui element to this List.
[Columns would have names of Properties]

Label in datalist in C#

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Label in datalist in C#

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us