or
<
Window
x:Class
=
"AggregateFunctions.MainWindow"
xmlns:telerik
=
"http://schemas.telerik.com/2008/xaml/presentation"
WindowState
=
"Maximized"
Title
=
"MainWindow"
Height
=
"350"
Width
=
"525"
>
<
Grid
>
<
telerik:RadGridView
HorizontalAlignment
=
"Stretch"
Margin
=
"5"
Name
=
"radGridView1"
VerticalAlignment
=
"Stretch"
Grid.Row
=
"2"
Grid.Column
=
"0"
Grid.ColumnSpan
=
"3"
AutoGenerateColumns
=
"True"
CanUserDeleteRows
=
"False"
CanUserInsertRows
=
"False"
CanUserSelect
=
"False"
GridLinesVisibility
=
"Horizontal"
ShowInsertRow
=
"False"
ShowGroupFooters
=
"False"
ShowColumnHeaders
=
"True"
RowIndicatorVisibility
=
"Collapsed"
FrozenColumnCount
=
"3"
AlternationCount
=
"2"
Loaded
=
"radGridView1_Loaded"
AlternateRowBackground
=
"#F8F8F8"
AutoGeneratingColumn
=
"radGridView1_AutoGeneratingColumn"
>
<
telerik:RadGridView.Columns
>
<
telerik:GridViewDataColumn
Header
=
"Company Name"
DataMemberBinding
=
"{Binding CompanyName}"
Width
=
"180"
IsReadOnly
=
"True"
></
telerik:GridViewDataColumn
>
<
telerik:GridViewDataColumn
Header
=
"Ticker"
DataMemberBinding
=
"{Binding Ticker}"
Width
=
"80"
IsReadOnly
=
"True"
></
telerik:GridViewDataColumn
>
<
telerik:GridViewDataColumn
Header
=
"MIC"
DataMemberBinding
=
"{Binding MicCode}"
IsReadOnly
=
"True"
></
telerik:GridViewDataColumn
>
<
telerik:GridViewDataColumn
Header
=
"Publisher"
DataMemberBinding
=
"{Binding Publisher}"
IsReadOnly
=
"True"
></
telerik:GridViewDataColumn
>
<
telerik:GridViewDataColumn
Header
=
"Industry"
DataMemberBinding
=
"{Binding Industry}"
IsReadOnly
=
"True"
></
telerik:GridViewDataColumn
>
<
telerik:GridViewDataColumn
Header
=
"Model Name"
DataMemberBinding
=
"{Binding RegressionName}"
Width
=
"180"
IsReadOnly
=
"True"
></
telerik:GridViewDataColumn
>
<
telerik:GridViewDataColumn
Header
=
"Multiple"
DataMemberBinding
=
"{Binding Multiple}"
Width
=
"120"
IsReadOnly
=
"True"
></
telerik:GridViewDataColumn
>
<
telerik:GridViewDataColumn
Header
=
"Qtrs Lead"
DataMemberBinding
=
"{Binding NumQtrsLead}"
IsReadOnly
=
"True"
></
telerik:GridViewDataColumn
>
<
telerik:GridViewDataColumn
Header
=
"Time Period"
DataMemberBinding
=
"{Binding TimePeriod}"
DataFormatString
=
"{}{0:MM/dd/yyyy}"
IsReadOnly
=
"True"
></
telerik:GridViewDataColumn
>
<
telerik:GridViewDataColumn
Header
=
"Model Case"
DataMemberBinding
=
"{Binding ModelCase}"
IsReadOnly
=
"True"
></
telerik:GridViewDataColumn
>
<
telerik:GridViewDataColumn
Header
=
"Is Default"
DataMemberBinding
=
"{Binding IsDefault}"
IsReadOnly
=
"True"
></
telerik:GridViewDataColumn
>
<
telerik:GridViewDataColumn
Header
=
"R. Squared"
DataMemberBinding
=
"{Binding RSquared}"
IsReadOnly
=
"True"
TextAlignment
=
"Right"
></
telerik:GridViewDataColumn
>
<
telerik:GridViewDataColumn
Header
=
"Indicator Percentile"
DataMemberBinding
=
"{Binding IndicatorPercentile}"
DataFormatString
=
"{}{0:P2}"
TextAlignment
=
"Right"
IsReadOnly
=
"True"
></
telerik:GridViewDataColumn
>
<
telerik:GridViewDataColumn
Header
=
"Over Under Valuation"
DataMemberBinding
=
"{Binding OverUnderValuation}"
DataFormatString
=
"{}{0:P2}"
TextAlignment
=
"Right"
IsReadOnly
=
"True"
></
telerik:GridViewDataColumn
>
</
telerik:RadGridView.Columns
>
</
telerik:RadGridView
>
</
Grid
>
</
Window
>
using
System;
using
System.Collections.Generic;
using
System.Data;
using
System.Windows;
using
Telerik.Windows.Controls;
namespace
AggregateFunctions
{
/// <summary>
/// Interaction logic for MainWindow.xaml
/// </summary>
public
partial
class
MainWindow : Window
{
List<
string
> lstColumns =
new
List<
string
>();
public
MainWindow()
{
InitializeComponent();
lstColumns.Add(
"CompanyName"
);
lstColumns.Add(
"Ticker"
);
lstColumns.Add(
"MicCode"
);
lstColumns.Add(
"RegressionName"
);
lstColumns.Add(
"Publisher"
);
lstColumns.Add(
"Industry"
);
lstColumns.Add(
"Multiple"
);
lstColumns.Add(
"NumQtrsLead"
);
lstColumns.Add(
"TimePeriod"
);
lstColumns.Add(
"ModelCase"
);
lstColumns.Add(
"RSquared"
);
lstColumns.Add(
"IndicatorPercentile"
);
lstColumns.Add(
"OverUnderValuation"
);
}
private
void
radGridView1_AutoGeneratingColumn(
object
sender, Telerik.Windows.Controls.GridViewAutoGeneratingColumnEventArgs e)
{
if
(lstColumns.Contains(e.Column.UniqueName))
e.Cancel =
true
;
else
{
e.Column.TextAlignment = TextAlignment.Right;
e.Column.Width =
new
GridViewLength(110);
e.Column.IsReadOnly =
true
;
}
}
private
DataTable LoadData()
{
int
counter = 0;
DataTable dt =
new
DataTable();
foreach
(var item
in
lstColumns)
{
if
(counter <= 6)
dt.Columns.Add(item,
typeof
(
string
));
else
if
(counter == 7)
dt.Columns.Add(item,
typeof
(
int
));
else
if
(counter == 8)
dt.Columns.Add(item,
typeof
(DateTime));
else
if
(counter == 9)
dt.Columns.Add(item,
typeof
(
string
));
else
dt.Columns.Add(item,
typeof
(
double
));
counter++;
}
dt.Columns.Add(
"OilWith1M"
,
typeof
(
double
));
dt.Columns.Add(
"CapUtilPC"
,
typeof
(
double
));
dt.Columns.Add(
"UnEmployement"
,
typeof
(
double
));
dt.Columns.Add(
"NaturalGas"
,
typeof
(
double
));
dt.Columns.Add(
"10YTreasury"
,
typeof
(
double
));
dt.Columns.Add(
"USUnEmployemnet"
,
typeof
(
double
));
dt.Columns.Add(
"IndustrialProduction"
,
typeof
(
double
));
dt.Columns.Add(
"NewHomeSales"
,
typeof
(
double
));
dt.Columns.Add(
"InventorySalesRatio"
,
typeof
(
double
));
dt.Columns.Add(
"NaturalGasNYM"
,
typeof
(
double
));
Random r =
new
Random();
for
(
int
i = 1; i < 500; i++)
{
DataRow row = dt.NewRow();
counter = 0;
foreach
(var item
in
dt.Columns)
{
if
(counter <= 6)
row[item.ToString()] = Guid.NewGuid().ToString().Substring(0, 5);
else
if
(counter == 7)
row[item.ToString()] = r.Next(1000 * i);
else
if
(counter == 8)
row[item.ToString()] = DateTime.Now.AddDays(i);
else
if
(counter == 9)
row[item.ToString()] = Guid.NewGuid().ToString().Substring(0, 5);
else
row[item.ToString()] = r.Next(1000 * i);
counter++;
}
dt.Rows.Add(row);
}
return
dt;
}
private
void
radGridView1_Loaded(
object
sender, RoutedEventArgs e)
{
this
.radGridView1.ItemsSource = LoadData();
}
}
}
<
telerik:RadGridView
Margin
=
"0,0,0,0"
Name
=
"grdGeneralPayments"
SelectionMode
=
"Extended"
ShowGroupPanel
=
"False"
ShowColumnFooters
=
"False"
CanUserSelect
=
"False"
CanUserInsertRows
=
"False"
CanUserDeleteRows
=
"False"
IsSynchronizedWithCurrentItem
=
"False"
MouseDoubleClick
=
"grdGeneralPayments_MouseDoubleClick"
SelectionChanged
=
"grdGeneralPayments_SelectionChanged"
Filtering
=
"grdGeneralPayments_Filtering"
Filtered
=
"grdGeneralPayments_Filtered"
ScrollViewer.VerticalScrollBarVisibility
=
"Auto"
ScrollViewer.HorizontalScrollBarVisibility
=
"Auto"
DockPanel.Dock
=
"Top"
>
</
telerik:RadGridView
>
<
telerik:RadDataPager
Name
=
"radDataPager"
Margin
=
"0,0,0,0"
DockPanel.Dock
=
"Bottom"
PageSize
=
"10"
Source
=
"{Binding Items, ElementName=grdGeneralPayments}"
PageIndexChanging
=
"radDataPager_PageIndexChanging"
/>
//Because grid columns are auto generated we need to add the select row checkbox column ourselves.
GridViewSelectColumn selectCol = new GridViewSelectColumn();
selectCol.Name = "Select";
//Put select row checkbox column on LHS of the grid.
this.grdGeneralPayments.Columns.Insert(0, selectCol);
public ApproveGeneralPayments()
{
InitializeComponent();
this.grdGeneralPayments.Items.PageChanged += new EventHandler<
EventArgs
>(Items_PageChanged);
private void Items_PageChanged(object sender, EventArgs e)
{
this.SelectGloballySelectedItems();
this.changingPage = false;
}
<ControlTemplate x:Key="OtherWorkEditTemplate">
<Grid x:Name="LayoutRoot">
<GroupBox Header="Something" BorderBrush="{DynamicResource SolidColorBlueBrush}">
<Grid>
...
<telerik:RadDatePicker SelectedValue="{Binding OtherWork.InvoiceDate}" VerticalAlignment="Top" Margin="88.787,98.458,8,0" DateTimeWatermarkContent="Enter" telerik:StyleManager.Theme="Metro" />
</Grid>
</GroupBox>
</Grid>
</ControlTemplate>
How can i solve this?
Thanks a lot,
Attila