or
<
telerik:RadGrid
ID
=
"RadGrid1"
runat
=
"server"
AutoGenerateColumns
=
"False"
CellSpacing
=
"0"
OnItemDataBound
=
"RadGrid1_ItemDataBound"
OnItemCommand
=
"ViewResponse"
OnSortCommand
=
"RadGrid1_SortCommand"
OnPageIndexChanged
=
"RadGrid1_PageIndexChanged"
OnPageSizeChanged
=
"RadGrid1_PageSizeChanged"
Skin
=
"Office2007"
ShowStatusBar
=
"true"
Width
=
"100%"
AllowSorting
=
"True"
AllowPaging
=
"True"
PageSize
=
"20"
OnNeedDataSource
=
"GridNeedsDataSource"
OnPreRender
=
"RadGrid1_PreRender"
OnDetailTableDataBind
=
"RadGrid1_DetailTableDataBind"
OnUpdateCommand
=
"RadGrid1_UpdateCommand"
OnInsertCommand
=
"RadGrid1_InsertCommand"
>
<
MasterTableView
DataKeyNames
=
"response_id, survey_id, email_sent_history_id"
>
<
DetailTables
>
<
telerik:GridTableView
DataKeyNames
=
"email_sent_history_id"
Name
=
"Calls"
Width
=
"100%"
runat
=
"server"
CommandItemDisplay
=
"Top"
>
<
ParentTableRelation
>
<
telerik:GridRelationFields
DetailKeyField
=
"email_sent_history_id"
MasterKeyField
=
"email_sent_history_id"
/>
</
ParentTableRelation
>
<
Columns
>
<
telerik:GridDateTimeColumn
HeaderText
=
"Call Date"
DataField
=
"call_date"
UniqueName
=
"call_date"
PickerType
=
"DatePicker"
>
</
telerik:GridDateTimeColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Call Outcome"
DataField
=
"call_outcome"
UniqueName
=
"call_outcome"
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
telerik:GridTableView
>
</
DetailTables
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"email_sent_history_id"
UniqueName
=
"ResponseId"
Visible
=
"false"
/>
<
telerik:GridBoundColumn
DataField
=
"response_id"
UniqueName
=
"ResponseId"
Visible
=
"false"
/>
<
telerik:GridBoundColumn
UniqueName
=
"first_name"
DataField
=
"first_name"
HeaderText
=
"First Name"
/>
<
telerik:GridBoundColumn
DataField
=
"last_name"
HeaderText
=
"Last Name"
/>
<
telerik:GridBoundColumn
DataField
=
"organization"
HeaderText
=
"Organization"
/>
<
telerik:GridBoundColumn
DataField
=
"pi_name"
Headertext
=
"PI Name"
/>
<
telerik:GridBoundColumn
DataField
=
"response_date"
DataFormatString
=
"{0:MM/dd/yyyy}"
Headertext
=
"Response Date"
/>
<
telerik:GridBoundColumn
DataField
=
"current_status"
HeaderText
=
"Survey Status"
/>
<
telerik:GridBoundColumn
DataField
=
"score"
Headertext
=
"Score"
/>
<
telerik:GridButtonColumn
UniqueName
=
"Response"
Text
=
"View"
HeaderText
=
"Response"
CommandName
=
"ViewResponse"
/>
<
telerik:GridBoundColumn
DataField
=
"feasibility_status"
HeaderText
=
"feasibility_status"
/>
</
Columns
>
<
PagerStyle
AlwaysVisible
=
"True"
Mode
=
"NextPrevAndNumeric"
Position
=
"TopAndBottom"
></
PagerStyle
>
</
MasterTableView
>
<
ClientSettings
>
<
Selecting
AllowRowSelect
=
"true"
/>
</
ClientSettings
>
</
telerik:RadGrid
>
protected void RadGrid1_InsertCommand(object source, GridCommandEventArgs e)
{
GridEditFormInsertItem item = e.Item as GridEditFormInsertItem;
if (item == null)
{
return;
}
string errorString = string.Empty;
Hashtable values = new Hashtable();
item.ExtractValues(values);
try
{
var callDate = values["call_date"] == null ? string.Empty : values["call_date"].ToString();
var callOutcome = values["call_outcome"] == null ? string.Empty : values["call_outcome"].ToString();
/*Do some error checking and update the DB if we have values. callDate and callOutcome are always an empty string!*/
}
catch (Exception ex)
{
RadGrid1.Controls.Add(new LiteralControl(string.Format("<
span
style
=
'color:red'
>{0}</
span
>", ex.Message)));
e.Canceled = true;
}
}
<
telerik:RadGrid
ID
=
"rgData"
runat
=
"server"
AllowSorting
=
"true"
Skin="<%$Appsettings:TelerikSkin %>"
ClientSettings-AllowColumnsReorder="true"
ClientSettings-Resizing-AllowColumnResize="true"
DataSourceID="odsGrid"
Width
=
"400px"
AutoGenerateColumns="false">
<
MasterTableView
>
<
Columns
>
<
telerik:GridBoundColumn
HeaderText
=
"AttributeName"
SortExpression
=
"AttributeName"
DataField
=
"AttributeName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"DataValue"
SortExpression
=
"DataValue"
DataField
=
"DataValue"
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
<
asp:GridView
ID
=
"gData"
runat
=
"server"
AllowSorting
=
"true"
DataSourceID
=
"odsGrid"
Width
=
"400px"
AutoGenerateColumns
=
"false"
>
<
Columns
>
<
asp:BoundField
HeaderText
=
"AttributeName"
SortExpression
=
"AttributeName"
DataField
=
"AttributeName"
>
</
asp:BoundField
>
<
asp:BoundField
HeaderText
=
"DataValue"
SortExpression
=
"DataValue"
DataField
=
"DataValue"
>
</
asp:BoundField
>
</
Columns
>
</
asp:GridView
>
<
asp:ObjectDataSource
ID
=
"odsGrid"
SelectMethod
=
"GetGridData"
TypeName
=
"dataViewGridInterface"
runat
=
"server"
></
asp:ObjectDataSource
>