or
Protected Sub myRadGrid_ItemDataBound(sender As Object, e As Telerik.Web.UI.GridItemEventArgs) Handles myRadGrid.ItemDataBound
If TypeOf e.Item Is GridDataItem Then
Dim gr As DropDownList = CType(e.Item.FindControl("ddlRank"), DropDownList)
Dim rank As String = e.Item.Cells(6).Text
sql = "Select * from OPENQUERY(SIDPERS, 'Select Distinct PAY_GR, PAY_GR GR from PERS_GRABBR_CODE_TBL ORDER BY PAY_GR')"
myDataTable = New DataTable
myDataTable = getData(sql)
gr.DataSource = myDataTable
gr.DataTextField = "GR"
gr.DataValueField = "PAY_GR"
gr.SelectedValue = DirectCast(DataBinder.Eval(e.Item.DataItem, rank).ToString(), String)
gr.DataBind()
End If
End Sub
<
EditFormSettings
EditFormType
=
"Template"
>
<
FormTemplate
>
<
table
width
=
"100%"
>
<
tr
>
<
td
style
=
"width:50%"
align
=
"right"
>Prior Uic: </
td
>
<
td
style
=
"width:50%"
align
=
"left"
><
asp:TextBox
ID
=
"txtPriorUic"
runat
=
"server"
Width
=
"100px"
Text='<%# Bind("strPrevUic") %>'></
asp:TextBox
></
td
>
</
tr
>
<
tr
>
<
td
style
=
"height:5px"
></
td
>
</
tr
>
<
tr
>
<
td
style
=
"width:50%"
align
=
"right"
>Para: </
td
>
<
td
style
=
"width:50%"
align
=
"left"
"><
asp:TextBox
ID
=
"txtpara"
runat
=
"server"
Width
=
"100px"
Text='<%# Bind("strPara") %>'></
asp:TextBox
></
td
>
</
tr
>
<
tr
>
<
td
style
=
"height:5px"
></
td
>
</
tr
>
<
tr
>
<
td
style
=
"width:50%"
align
=
"right"
> Line: </
td
>
<
td
style
=
"width:50%"
align
=
"left"
><
asp:TextBox
ID
=
"txtLine"
runat
=
"server"
Width
=
"100px"
Text='<%# Bind("strLine") %>'></
asp:TextBox
></
td
>
</
tr
>
<
tr
>
<
td
style
=
"height:5px"
></
td
>
</
tr
>
<
tr
>
<
td
style
=
"width:50%"
align
=
"right"
>Return Grade: </
td
>
<
td
style
=
"width:50%"
align
=
"left"
><
asp:DropDownList
ID
=
"ddlRank"
runat
=
"server"
Width
=
"105px"
> </
asp:DropDownList
>
</
td
>
</
tr
>
</
table
>
<
table
width
=
"100%"
>
<
tr
>
<
td
style
=
"width:50%"
align
=
"right"
></
td
>
<
td
style
=
"width:50%"
align
=
"left"
>
<
asp:LinkButton
ID
=
"lnkSubmit"
runat
=
"server"
text='<%# IIf((TypeOf(Container) is GridEditFormInsertItem), "Insert", "Update") %>'
CommandName='<%# IIf((TypeOf(Container) is GridEditFormInsertItem), "PerformInsert", "Update")%>'></
asp:LinkButton
>
<
asp:LinkButton
ID
=
"lnkCancel"
runat
=
"server"
CausesValidation
=
"false"
CommandName
=
"Cancel"
Text
=
"Cancel"
></
asp:LinkButton
>
</
td
>
</
tr
>
</
table
>
</
FormTemplate
>
</
EditFormSettings
>
<
telerik:GridBoundColumn
DataField
=
"StatusName"
HeaderText
=
"Status Name"
SortExpression
=
"StatusName"
UniqueName
=
"StatusName"
>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"RadComboBoxSts"
DataSourceID
=
"SDSStatus"
DataTextField
=
"StsName"
DataValueField
=
"StsName"
Skin
=
"Office2007"
Width
=
"100%"
Height
=
"100px"
AppendDataBoundItems
=
"true"
SelectedValue='<%# TryCast(Container,GridItem).OwnerTableView.GetColumn("StatusName").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="StsIndexChanged">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
<
telerik:RadComboBoxItem
Text
=
"Open Only"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock3"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function StsIndexChanged(sender, args) {
var tableView = $find("<%# TryCast(Container,GridItem).OwnerTableView.ClientID %>");
If(args.get_item().get_text() == "Open Only")
{
tableView.filter("TaskTypeName", "Closed", "NotEqualTo");
// Combo selected text must be Open Only after filtering.
}
Else
{
tableView.filter("TaskTypeName", args.get_item().get_value(), "EqualTo");
}
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
<
HeaderStyle
Width
=
"6%"
VerticalAlign
=
"Top"
/>
<
ItemStyle
Width
=
"6%"
VerticalAlign
=
"Top"
/>
</
telerik:GridBoundColumn
>
<?
xml
version
=
"1.0"
encoding
=
"UTF-8"
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<
html
xmlns
=
"http://www.w3.org/1999/xhtml"
xml:lang
=
"en"
lang
=
"en"
>
<
head
profile
=
"http://selenium-ide.openqa.org/profiles/test-case"
>
<
meta
http-equiv
=
"Content-Type"
content
=
"text/html; charset=UTF-8"
/>
<
link
rel
=
"selenium.base"
href
=
"http://localhost:3623/"
/>
<
title
>New Test</
title
>
</
head
>
<
body
>
<
table
cellpadding
=
"1"
cellspacing
=
"1"
border
=
"1"
>
<
thead
>
<
tr
><
td
rowspan
=
"1"
colspan
=
"3"
>New Test</
td
></
tr
>
</
thead
><
tbody
>
<
tr
>
<
td
>open</
td
>
<
td
>/Default.aspx</
td
>
<
td
></
td
>
</
tr
>
<
tr
>
<
td
>click</
td
>
<
td
>id=ddItem_Arrow</
td
>
<
td
></
td
>
</
tr
>
<
tr
>
<
td
>type</
td
>
<
td
>id=ddItem_Input</
td
>
<
td
>Item4</
td
>
</
tr
>
<
tr
>
<
td
>click</
td
>
<
td
>css=li.rcbHovered.</
td
>
<
td
></
td
>
</
tr
>
<
tr
>
<
td
>clickAndWait</
td
>
<
td
>id=Button1</
td
>
<
td
></
td
>
</
tr
>
</
tbody
></
table
>
</
body
>
</
html
>
selenium.Open(
"/Default.aspx"
);
selenium.Click(
"id=ddItem_Arrow"
);
selenium.Type(
"id=ddItem_Input"
,
"Item4"
);
selenium.Click(
"css=li.rcbHovered."
);
selenium.Click(
"id=Button1"
);
selenium.WaitForPageToLoad(
"30000"
);
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
div
>
<
asp:ScriptManager
ID
=
"ScriptManager1"
runat
=
"server"
>
</
asp:ScriptManager
>
<
telerik:RadComboBox
ID
=
"ddItem"
runat
=
"server"
>
</
telerik:RadComboBox
>
<
asp:Button
ID
=
"Button1"
runat
=
"server"
Text
=
"Button"
onclick
=
"Button1_Click"
/>
<
br
/>
<
asp:TextBox
ID
=
"txtbxShow"
runat
=
"server"
></
asp:TextBox
>
</
div
>
</
form
>
</
body
>
protected
void
Page_Load(
object
sender, EventArgs e)
{
if
(!IsPostBack)
{
ddItem.Items.Add(
new
RadComboBoxItem(
"Item1"
));
ddItem.Items.Add(
new
RadComboBoxItem(
"Item2"
));
ddItem.Items.Add(
new
RadComboBoxItem(
"Item3"
));
ddItem.Items.Add(
new
RadComboBoxItem(
"Item4"
));
}
}
protected
void
Button1_Click(
object
sender, EventArgs e)
{
txtbxShow.Text = ddItem.SelectedItem.Text;
}
<
script
type
=
"text/javascript"
>
function RowClick(sender, eventArgs) {
var MasterTableView = eventArgs.get_tableView();
var row = MasterTableView.get_dataItems()[eventArgs.get_itemIndexHierarchical()];
var cell = MasterTableView.getCellByColumnUniqueName(row, "ID");
var oWnd = radopen("Details.aspx?ID=" + cell.innerHTML);
}
</
script
>
<
asp:SqlDataSource
ID
=
"SqlDataSource1"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:bessacarrConnectionString %>"
SelectCommand="SELECT [ID], [DateStart], [DateEnd], [RallyName], [Location] FROM [tblRallies] WHERE DateDiff(day, getDate(), [DateStart]) > 1 ORDER BY [DateStart]">
</
asp:SqlDataSource
>
<
telerik:RadGrid
ID
=
"RadGrid1"
runat
=
"server"
DataSourceID
=
"SqlDataSource1"
GridLines
=
"None"
Skin
=
"WebBlue"
AutoGenerateColumns
=
"False"
>
<
ClientSettings
>
<
ClientEvents
OnRowClick
=
"RowClick"
/>
</
ClientSettings
>
<
MasterTableView
datakeynames
=
"ID"
datasourceid
=
"SqlDataSource1"
>
<
CommandItemSettings
ExportToPdfText
=
"Export to Pdf"
></
CommandItemSettings
>
<
RowIndicatorColumn
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
RowIndicatorColumn
>
<
ExpandCollapseColumn
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
ExpandCollapseColumn
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"ID"
DataType
=
"System.Int32"
HeaderText
=
"ID"
ReadOnly
=
"True"
SortExpression
=
"ID"
UniqueName
=
"ID"
Visible
=
"False"
>
</
telerik:GridBoundColumn
>
<
telerik:GridTemplateColumn
DataField
=
"DateStart"
DataType
=
"System.DateTime"
HeaderText
=
"Start"
SortExpression
=
"DateStart"
UniqueName
=
"DateStart"
>
<
EditItemTemplate
>
<
asp:TextBox
ID
=
"DateStartTextBox"
runat
=
"server"
Text='<%# Bind("DateStart") %>'></
asp:TextBox
>
</
EditItemTemplate
>
<
ItemTemplate
>
<
asp:Label
ID
=
"DateStartLabel"
runat
=
"server"
Text='<%# Eval("DateStart", "{0:dd/M/yyyy}") %>'></
asp:Label
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"DateEnd"
DataType
=
"System.DateTime"
HeaderText
=
"End"
SortExpression
=
"DateEnd"
UniqueName
=
"DateEnd"
>
<
EditItemTemplate
>
<
asp:TextBox
ID
=
"DateEndTextBox"
runat
=
"server"
Text='<%# Bind("DateEnd") %>'></
asp:TextBox
>
</
EditItemTemplate
>
<
ItemTemplate
>
<
asp:Label
ID
=
"DateEndLabel"
runat
=
"server"
Text='<%# Eval("DateEnd", "{0:dd/M/yyyy}") %>'></
asp:Label
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"RallyName"
HeaderText
=
"RallyName"
SortExpression
=
"RallyName"
UniqueName
=
"RallyName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Location"
HeaderText
=
"Location"
SortExpression
=
"Location"
UniqueName
=
"Location"
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
<
HeaderContextMenu
EnableImageSprites
=
"True"
CssClass
=
"GridContextMenu GridContextMenu_Default"
></
HeaderContextMenu
>
</
telerik:RadGrid
>
<
telerik:RadWindowManager
ID
=
"RadWindowManager1"
runat
=
"server"
>
</
telerik:RadWindowManager
>