Click here to Skip to main content
15,867,756 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
I have a data grid & a Listview.
The datagrid displays a table from a database vertically.
and I have added a listview that shows the status of the servers.

Now I have to added a new column called Delta which should display the difference between the Average column 108 & 121 from the datagrid.

the datagrid gets the data from DB using sql connectionstring & I used
<datagrid.layouttransform> for rotating the datagrid vertically.
&

Since I cant upload an image here, I will type the skeleton how my datagrid and listview looks like :

datagrid
SQL
Header          | Value1       |Value2

SQL
TimeoutSeconnd |     120      |   120
Position Type  |     Primary  |   Primary
Average        |     108      |   121


listview
Server | Role | ConnectionStatus | Delta
Test_server1 | Primary | Running | ??

I have created the listview using ObservableCollection as follows:
C#
   private ObservableCollection<serverData> _ServerCollection = new   ObservableCollection<serverData>();
public ObservableCollection<serverData> serverCollection
  { get{ return _ServerCollection; } }

  public class serverData
  {   public string ServerID { get; set; }
      public string Role { get; set; }
      public string ConnectionStatus { get; set; }
      public string Delta { get; set; }
  }

at XAML

HTML
<ListView Height="auto" Name="listView1" Width="auto"   ItemsSource="{Binding ElementName=Page1,Path=serverCollection}">
     <ListView.View>
      <GridView>
      <GridViewColumn DisplayMemberBinding="{Binding ServerID}" />
      <GridViewColumn DisplayMemberBinding="{Binding Role}" />
      <GridViewColumn DisplayMemberBinding="{Binding ConnectionStatus}" />
      <GridViewColumn DisplayMemberBinding="{Binding Delta}" />
     </GridView>
    </ListView.View>
  </ListView>


How to achieve the difference calculation from the datagrid and displaying in the listview?!
Kindly help.. I would be grateful.. Thanks ..
Posted
Updated 3-Jan-13 12:44pm
v2

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900