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
Header | Value1 |Value2
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:
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
<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 ..