I have a grid in which two columns are linked, ie Project Type Categories and Project Types. On itemcreated I am adding select index changed and when editing it is working fine, however when inserting a new row, the second row does not reflect the changes.
.aspx
<
telerik:RadGrid ID="rgBenchmarkedHours" Skin="WebBlue" AutoGeneBenchmarkedHourColumns="false" Width="650px" AllowPaging="true" PageSize="10" OnPreRender="rgBenchmarkedHours_PreRender" OnNeedDataSource="rgBenchmarkedHours_NeedDataSource" OnUpdateCommand="rgBenchmarkedHours_UpdateCommand"
OnInsertCommand="rgBenchmarkedHours_InsertCommand" OnDeleteCommand="rgBenchmarkedHours_DeleteCommand"
OnItemCreated="rgBenchmarkedHours_ItemCreated" runat="server">
<PagerStyle AlwaysVisible="true" Mode="Slider"/>
<HeaderStyle HorizontalAlign="Center" />
<ItemStyle HorizontalAlign="Left" />
<AlternatingItemStyle HorizontalAlign="Left" />
<MasterTableView EditMode="InPlace" CommandItemDisplay="Top" CommandItemSettings-AddNewRecordImageUrl="~/images/add.png"
CommandItemSettings-AddNewRecordText="Add row" AutoGenerateColumns="false" DataKeyNames="BenchmarkedHoursID" >
<Columns>
<telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn" ItemStyle-HorizontalAlign="Center"></telerik:GridEditCommandColumn>
<telerik:GridBoundColumn UniqueName="BenchmarkedHoursID" DataField="BenchmarkedHoursID" HeaderText="BenchmarkedHoursID" ReadOnly="true" Visible="false"></telerik:GridBoundColumn>
<telerik:GridBoundColumn UniqueName="AgencyID" DataField="AgencyID" HeaderText="AgencyID" Visible="false"></telerik:GridBoundColumn>
<telerik:GridDropDownColumn UniqueName="ProjectTypeCategoryID" DataSourceID="ProjectTypeCategoryNameSource" ItemStyle-Width="250px"
DataField="ProjectTypeCategoryID" ListTextField="ProjectTypeCategoryName" ListValueField="ProjectTypeCategoryID" HeaderText="Project Type Category" ReadOnly="false"></telerik:GridDropDownColumn>
<telerik:GridDropDownColumn UniqueName="ProjectTypeNameDesc" DataSourceID="ProjectTypeNameSource" ItemStyle-Width="250px"
DataField="ProjectTypeID" ListTextField="ProjectTypeName" CurrentFilterFunction="EqualTo" CurrentFilterValue="ProjectTypeCategoryID" ListValueField="ProjectTypeID" HeaderText="Project Type">
</telerik:GridDropDownColumn>
<telerik:GridBoundColumn UniqueName="Category" DataField="CategoryName" HeaderText="Category" ReadOnly="true"></telerik:GridBoundColumn>
<telerik:GridBoundColumn UniqueName="EASFunction" DataField="EASFunction" HeaderText="EASFunction" Visible="false"></telerik:GridBoundColumn>
<telerik:GridDropDownColumn UniqueName="EASFunctionDesc" DataSourceID="EASFunctionSource" ItemStyle-Width="250px"
DataField="EASFunction" ListTextField="EASFunctionDesc" ListValueField="EASFunction"
HeaderText="EAS Function"></telerik:GridDropDownColumn>
<telerik:GridNumericColumn UniqueName="BenchmarkedHour" DataField="Hours" HeaderText="Benchmarked Hour" NumericType="Number" ItemStyle-HorizontalAlign="Right"></telerik:GridNumericColumn>
<telerik:GridButtonColumn ConfirmText="Delete this Benchmarked Hour?" ConfirmDialogType="RadWindow"
ConfirmTitle="Delete" ButtonType="ImageButton" CommandName="Delete" Text="Delete"
UniqueName="DeleteColumn">
<ItemStyle HorizontalAlign="Center"/>
</telerik:GridButtonColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>
<
asp:SqlDataSource ID="ProjectTypeNameSource" runat="server"
ConnectionString="<%$ ConnectionStrings:EuroEstimatesConnectionString %>"
SelectCommand="SELECT PT.[ProjectTypeID], PT.[ProjectTypeName] FROM [ProjectTypes] PT UNION SELECT 0, '- Select Type' ORDER BY PT.[ProjectTypeName]">
</asp:SqlDataSource>
<
asp:SqlDataSource ID="ProjectTypeCategoryNameSource" runat="server"
ConnectionString="<%$ ConnectionStrings:EuroEstimatesConnectionString %>"
SelectCommand="SELECT [ProjectTypeCategoryID], [ProjectTypeCategoryName] FROM [ProjectTypeCategories] UNION SELECT 0, '- Select Category' ORDER BY [ProjectTypeCategoryName]">
</asp:SqlDataSource>
.cs
protected
void rgBenchmarkedHours_ItemCreated(object sender, GridItemEventArgs e)
{
if (e.Item is GridEditableItem && e.Item.IsInEditMode)
{
RadComboBox list = (e.Item as GridEditableItem)["ProjectTypeCategoryID"].Controls[0] as RadComboBox;
list.AutoPostBack =
true;
list.SelectedIndexChanged +=
new RadComboBoxSelectedIndexChangedEventHandler(list_SelectedIndexChanged);
}
}
void list_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)
{
GridEditableItem editedItem = (sender as RadComboBox).NamingContainer as GridEditableItem;
RadComboBox ddList = editedItem["ProjectTypeNameDesc"].Controls[0] as RadComboBox;
int ptc = int.Parse((editedItem["ProjectTypeCategoryID"].Controls[0] as RadComboBox).SelectedValue);
ddList.ClearSelection();
ddList.DataSource = da.GetProjectTypeNameDescription(ptc);
ddList.DataBind();
}
Thank you!
protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e) { if (e.Item is GridPagerItem) { GridPagerItem item = e.Item as GridPagerItem; Label pageOfLabel = e.Item.FindControl("PageOfLabel") as Label; pageOfLabel.Text = "OF " + item.Paging.PageCount.ToString(); } }
I am using rad grid in my application .some of Data I have showed in rad grid .we have used 5 column in rad grid, like Name, age, address, sex and date of birth .
We have given Search option for Filter column in rad gird. Filter Column are Rad combo box .in Age Filter combo box is not filtering (in rad grid Age Data type is integer)
function AgeIndexChanged(sender, args) {
var Ageobj = $find("<%=rgResults.ClientID%>").get_masterTableView()
Ageobj.filter("Age", args.get_item().get_value(), "Contains");
}
Inside the Rad grid Column is like (Rad grid Id is rgResults)
<telerik:GridBoundColumn DataField="Age" HeaderText="Age" SortExpression="Age" UniqueName="Age"
FilterControlWidth="50px" ItemStyle-Width="50px" AllowFiltering="true">
<FilterTemplate>
<telerik:RadComboBox ID="RadComboBoxAge" DataSourceID="AgeSqlDataSource" DataTextField="Age"
DataValueField="Age" Width="50px" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("Age").CurrentFilterValue %>'
Height="200px" AppendDataBoundItems="true" runat="server" OnClientSelectedIndexChanged="AgeIndexChanged">
<Items>
<telerik:RadComboBoxItem Text="All" />
</Items>
</telerik:RadComboBox>
</FilterTemplate>
</telerik:GridBoundColumn>
Can you please give the Correct Solution?
<
telerik:RadAjaxLoadingPanel
ID
=
"RadAjaxLoadingPanel_LOS"
runat
=
"server"
Skin
=
""
>
<
div
style
=
"height: 100%; width: 100%"
>
<
asp:Image
ID
=
"imgLoading"
runat
=
"server"
ImageUrl
=
"~/Images/Misc/loading2.gif"
AlternateText
=
"loading"
/>
</
div
>
</
telerik:RadAjaxLoadingPanel
>
<
telerik:AjaxSetting
AjaxControlID
=
"tsCRMPPSA"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"mpCRMPPSA"
UpdatePanelHeight
=
"400px"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>