or
<
telerik:RadPanelBar
ID
=
"RadPanelBar1"
Runat
=
"server"
ExpandMode
=
"FullExpandedItem"
Height
=
"700px"
Width
=
"280px"
>
<
Items
>
<%--
<!-- DEFAULT TABS FOR EITHER FMS OR POLICYHOLDER -->
--%>
<
telerik:RadPanelItem
Expanded
=
"true"
text
=
"Favorites"
Visible
=
"true"
>
<
ContentTemplate
>
<
telerik:RadTreeView
ID
=
"_rtvwFavorites"
runat
=
"server"
DataSourceID
=
"XmlDataSource4"
CheckBoxes
=
"True"
CheckChildNodes
=
"True"
TriStateCheckBoxes
=
"False"
>
<
DataBindings
>
<
telerik:RadTreeNodeBinding
DataMember
=
"Node"
TextField
=
"Text"
ExpandedField
=
"Expanded"
Checked
=
"True"
ValueField
=
"ID"
></
telerik:RadTreeNodeBinding
>
</
DataBindings
>
</
telerik:RadTreeView
>
<
asp:XmlDataSource
ID
=
"XmlDataSource4"
runat
=
"server"
DataFile
=
"~/Common/FavoritesTree.xml"
XPath
=
"/Favorites/Node"
></
asp:XmlDataSource
>
</
ContentTemplate
>
</
telerik:RadPanelItem
>
<
telerik:RadPanelItem
Text
=
"Credit Union"
Visible
=
"true"
>
<
ContentTemplate
>
<
telerik:RadTreeView
ID
=
"_rtvwCreditUnion"
runat
=
"server"
DataSourceID
=
"XmlDataSource3"
CheckBoxes
=
"True"
CheckChildNodes
=
"True"
TriStateCheckBoxes
=
"False"
>
<
DataBindings
>
<
telerik:RadTreeNodeBinding
DataMember
=
"Node"
TextField
=
"Text"
ExpandedField
=
"Expanded"
ValueField
=
"ID"
></
telerik:RadTreeNodeBinding
>
</
DataBindings
>
</
telerik:RadTreeView
>
<
asp:XmlDataSource
ID
=
"XmlDataSource3"
runat
=
"server"
DataFile
=
"~/Common/CuInfoTree.xml"
XPath
=
"/CUInfo/Node"
></
asp:XmlDataSource
>
</
ContentTemplate
>
</
telerik:RadPanelItem
>
<
telerik:RadPanelItem
Text
=
"Financial"
Visible
=
"true"
>
<
ContentTemplate
>
<
telerik:RadTreeView
ID
=
"_rtvwFinancialList"
Runat
=
"server"
DataSourceID
=
"XmlDataSource1"
CheckBoxes
=
"True"
CheckChildNodes
=
"True"
TriStateCheckBoxes
=
"False"
>
<
DataBindings
>
<
telerik:RadTreeNodeBinding
DataMember
=
"Node"
TextField
=
"Text"
ExpandedField
=
"Expanded"
ValueField
=
"ID"
></
telerik:RadTreeNodeBinding
>
</
DataBindings
>
</
telerik:RadTreeView
>
<
asp:XmlDataSource
ID
=
"XmlDataSource1"
runat
=
"server"
DataFile
=
"~/Common/FinancialTree.xml"
XPath
=
"/Financial/Node"
></
asp:XmlDataSource
>
</
ContentTemplate
>
</
telerik:RadPanelItem
>
<
telerik:RadPanelItem
Text
=
"Ratio"
Visible
=
"True"
>
<
ContentTemplate
>
<
telerik:RadTreeView
ID
=
"_rtvwRatioList"
Runat
=
"server"
DataSourceID
=
"_RatioListData"
CheckBoxes
=
"True"
CheckChildNodes
=
"True"
TriStateCheckBoxes
=
"False"
Visible
=
"True"
>
<
DataBindings
>
<
telerik:RadTreeNodeBinding
DataMember
=
"Node"
TextField
=
"Text"
ExpandedField
=
"Expanded"
ValueField
=
"ID"
></
telerik:RadTreeNodeBinding
>
</
DataBindings
>
</
telerik:RadTreeView
>
<
asp:XmlDataSource
ID
=
"_RatioListData"
runat
=
"server"
DataFile
=
"~/Common/RatioTree.xml"
XPath
=
"/Ratio/Node"
></
asp:XmlDataSource
>
</
ContentTemplate
>
</
telerik:RadPanelItem
>
<%--
<!-- END DEFAULT TABS -->
</
Items
>
</
telerik:RadPanelBar
>
DateTime startDate = DateTime.Parse(
"2013-10-01"
);
uxBookOrderGrid.MasterTableView.FilterExpression =
"(([StatusDescription] LIKE \'%Approved%\') AND ([TimeStamp] >= '"
+ startDate.ToString(
"g"
) +
"'))"
;
uxBookOrderGrid.Rebind();
<
telerik:GridDateTimeColumn
DataFormatString
=
"{0:g}"
DataType
=
"System.DateTime"
FilterControlWidth
=
"90%"
HeaderText
=
"Date"
DataField
=
"TimeStamp"
UniqueName
=
"TimeStamp"
/>
<
telerik:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
=
"server"
>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"uxStaffList"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"uxStaffList"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
</
AjaxSettings
>
</
telerik:RadAjaxManager
>
<
cc1:IbsRadGridList
ID
=
"uxStaffList"
runat
=
"server"
Factory
=
"StaffFactory"
AllowPaging
=
"true"
PageSize
=
"20"
DeleteButtonVisible
=
"false"
>
<
MasterTableView
DataKeyNames
=
"StaffId"
>
<
EditFormSettings
UserControlName
=
"StaffEditControl.ascx"
PopUpSettings-Width
=
"940px"
CaptionDataField
=
"FullName"
></
EditFormSettings
>
</
MasterTableView
>
</
cc1:IbsRadGridList
>
...
<
div
class
=
"control-group"
>
<
asp:Label
ID
=
"BirthDateLabel"
runat
=
"server"
CssClass
=
"control-label"
AssociatedControlID
=
"uxBirthDate"
>Birthday</
asp:Label
>
<
div
class
=
"controls"
>
<
telerik:RadDatePicker
ID
=
"uxBirthdate"
runat
=
"server"
MinDate
=
"1/1/1913"
ClientEvents-OnPopupOpening
=
"setDefaultBirthDate"
></
telerik:RadDatePicker
>
</
div
>
</
div
>
...
<
script
type
=
"text/javascript"
>
function setDefaultBirthDate(sender, e) {
if (sender.isEmpty()) {
var d = new Date();
d.setFullYear(d.getFullYear() - 21);
sender.set_selectedDate(d);
}
}
</
script
>
<
Columns
>
<
telerik:GridNumericColumn
DataField
=
"CarID"
DataType
=
"System.Int32"
HeaderText
=
"ID"
SortExpression
=
"CarID"
UniqueName
=
"CarID"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"EqualTo"
HeaderStyle-Width
=
"100"
ItemStyle-Width
=
"100"
FilterControlWidth
=
"60"
ReadOnly
=
"false"
/>
<
telerik:GridBoundColumn
DataField
=
"CarMake"
DataType
=
"System.String"
HeaderText
=
"Car Make"
SortExpression
=
"CarMake"
UniqueName
=
"CarMake"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
HeaderStyle-Width
=
"120"
ItemStyle-Width
=
"120"
FilterControlWidth
=
"80"
/>
<
telerik:GridBoundColumn
DataField
=
"CarModel"
DataType
=
"System.String"
HeaderText
=
"Car Model"
SortExpression
=
"CarModel"
UniqueName
=
"CarModel"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
HeaderStyle-Width
=
"120"
ItemStyle-Width
=
"120"
FilterControlWidth
=
"80"
/>
<
telerik:GridBoundColumn
DataField
=
"CarTrim"
DataType
=
"System.String"
HeaderText
=
"Car Trim"
SortExpression
=
"CarTrim"
UniqueName
=
"CarTrim"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
HeaderStyle-Width
=
"200"
ItemStyle-Width
=
"200"
FilterControlWidth
=
"160"
/>
<
telerik:GridNumericColumn
DataField
=
"CarYear"
DataType
=
"System.Int32"
HeaderText
=
"Car Year"
SortExpression
=
"CarYear"
UniqueName
=
"CarYear"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"EqualTo"
HeaderStyle-Width
=
"100"
ItemStyle-Width
=
"100"
FilterControlWidth
=
"60"
/>
</
Columns
>
Case
"Save"
For
Each
editedItem
As
GridEditableItem
In
RadGridViewExcelGridTest.EditItems
Dim
newValues
As
Hashtable =
New
Hashtable
'The GridTableView will fill the values from all editable columns in the hash
e.Item.OwnerTableView.ExtractValuesFromItem(newValues, editedItem)
SqlDataSourceExcelGridTest.UpdateCommandType = SqlDataSourceCommandType.StoredProcedure
SqlDataSourceExcelGridTest.UpdateCommand =
"spExcelGridTestUpdateTable"
SqlDataSourceExcelGridTest.UpdateParameters.Add(
New
Parameter(
"CarID"
, DbType.Int32))
SqlDataSourceExcelGridTest.UpdateParameters.Add(
New
Parameter(
"CarMake"
, DbType.
String
))
SqlDataSourceExcelGridTest.UpdateParameters.Add(
New
Parameter(
"CarModel"
, DbType.
String
))
SqlDataSourceExcelGridTest.UpdateParameters.Add(
New
Parameter(
"CarTrim"
, DbType.
String
))
SqlDataSourceExcelGridTest.UpdateParameters.Add(
New
Parameter(
"CarYear"
, DbType.Int32))
SqlDataSourceExcelGridTest.Update()
editedItem.Edit =
False
Next
ALTER
PROCEDURE
[dbo].[spExcelGridTestUpdateTable]
-- Add the parameters for the stored procedure here
@CarID
int
,
@CarMake
varchar
(100),
@CarModel
varchar
(100),
@CarTrim
varchar
(100),
@CarYear
int
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET
NOCOUNT
ON
;
UPDATE
[dbo].[TestTable_Cars]
SET
CarMake=@CarMake, CarModel=@CarModel, CarTrim=@CarTrim, CarYear=@CarYear
WHERE
CarID=@CarID
END
SqlDataSourceExcelGridTest.UpdateParameters.Clear()