Questions on UI for ASP.NET AJAX Forum

110,826 questions

4 answers

409 views

I would like to set the grid PagerStyle mode in code behind in order to display different pagers depending on various criteria (namely the available width expected on the particular screen the grid displays on). The criteria I will base this decision on are all available in code behind, but I can't seem to get the setting of the grid PagerStyler.Mode property to work. It seems to ignore anything I set in code behind and go with what is specified in the grid declaration. I have tried setting this in page load prior to the grid being bound and also in the item created event. Can you let me know how I can set the PagerStyle mode in code behind?

Thanks.

Grid

answered on 15 Jan 2014

5 answers

340 views

Radlistview with image button

Hello
i added asp image and image buttons in rad list view read from DB source
my problem i cant get selected picture form rad button to so image
<asp:Image ID="Image1" runat="server" Width="300px" />
 
 <telerik:RadListView ID="RadListView3" runat="server" AllowPaging="True"
 onselectedindexchanged="RadListView3_SelectedIndexChanged"
 OnItemDataBound="RadListView3_ItemDataBound" PageSize="4"
 AllowCustomPaging="True" Skin="Vista">
 <LayoutTemplate>
 <asp:PlaceHolder ID="itemPlaceholder" runat="server"></asp:PlaceHolder>
 </LayoutTemplate>
 <ItemTemplate>
 <asp:ImageButton ID="ImageButton2" runat="server" Height="80px"
 ImageUrl='<%# Eval("Pic_Path") %>' onclick="ImageButton2_Click" Width="60px" />
 </ItemTemplate>
 </telerik:RadListView>

can you help me ??

ListView

answered on 15 Jan 2014

7 answers

283 views

Ajaxifying Nested Listview

Using this Demo, with a listview nested within another listview, I am attempting to ajaxify the controls with a tabstrip above (Clicking tab buttons refreshes the listview with different data). I've tried and tried, but i cannot get the settings right for ajaxing with an ajax manager. If I place the tapstrip and listviews in an ajax panel, it works perfectly, but I'd prefer not to use an ajax panel (it can reduce performance, correct?).

What is the proper way to ajaxify the tapstrip and listviews with ajax manager?

ListView

answered on 15 Jan 2014

2 answers

119 views

hierarchy table in 4 layer not showing

I have problem to hierarchy table in 4 layer not showing
--
   table1
             table2
                       table3
                                 table4(not showing)

 

 <%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage_Menu.master" AutoEventWireup="true" CodeFile="Coding.aspx.cs" Inherits="Coding" %> 

  

 <asp:Content ID="Content1" ContentPlaceHolderID="nestedContent" Runat="Server"> 

  

  

 <form id="form1" runat ="server"> 

 <div style="min-height:600px"> 

 <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> 

 <Scripts> 

 <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" /> 

 <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" /> 

 <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" /> 

 </Scripts> 

 </telerik:RadScriptManager> 

 <telerik:RadGrid ID="RadGrid1" ShowStatusBar="True"  

 AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowAutomaticDeletes="True" 

 DataSourceID="SqlDataSource1" runat="server" AutoGenerateColumns="False" PageSize="15" 

 AllowSorting="True" AllowMultiRowSelection="True" AllowPaging="True" 

 OnItemUpdated="RadGrid1_ItemUpdated" OnItemDeleted="RadGrid1_ItemDeleted" 

 OnItemInserted="RadGrid1_ItemInserted" OnInsertCommand="RadGrid1_InsertCommand" 

 Height="95px" onupdatecommand="RadGrid1_UpdateCommand" 

 > 

 <PagerStyle Mode="NumericPages"></PagerStyle> 

 <MasterTableView DataSourceID="SqlDataSource1" Font-Names="Tahoma" DataKeyNames="GroupHesabId" CommandItemDisplay="Top" 

 Name="GroupHesab" AllowMultiColumnSorting="True" ExpandCollapseColumn-Display="true" Dir ="RTL" ItemStyle-BackColor="#00CCFF" AlternatingItemStyle-BackColor="#00CCFF" 

 RowIndicatorColumn-Display="false" AllowAutomaticUpdates="True" EditMode ="PopUp" > 

 <DetailTables> 

 <telerik:GridTableView Caption="جدول گروه حسابها" Name="Kol" DataKeyNames="KolId" EditMode ="InPlace" ItemStyle-BackColor="Yellow" AlternatingItemStyle-BackColor="Yellow" 

 runat="server" CommandItemDisplay="Top" Font-Names="Tahoma" DataSourceID="SqlDataSource2" EditItemStyle-HorizontalAlign="Right"> 

 <ParentTableRelation> 

 <telerik:GridRelationFields DetailKeyField="GroupHesabId" MasterKeyField="GroupHesabId"></telerik:GridRelationFields> 

 </ParentTableRelation> 

 <DetailTables> 

 <telerik:GridTableView Caption="" Name="Moien" DataKeyNames="MoeinId" EditMode ="PopUp" Font-Names="Tahoma" ItemStyle-BackColor="#80E680" AlternatingItemStyle-BackColor="#80E680" 

 runat="server" CommandItemDisplay="Top" DataSourceID="SqlDataSource3" Dir="RTL" EditItemStyle-HorizontalAlign="Right"> 

 <ParentTableRelation> 

 <telerik:GridRelationFields DetailKeyField="KolId" MasterKeyField="KolId"></telerik:GridRelationFields> 

 </ParentTableRelation> 

 <DetailTables> 

 <telerik:GridTableView Name="TafsiliGroupMoien" DataKeyNames="TafsiliGroupMoienId" EditMode ="PopUp" Font-Names="Tahoma" ItemStyle-BackColor="#80E680" AlternatingItemStyle-BackColor="#80E680" 

 runat="server" AutoGenerateColumns="false" CommandItemDisplay="Top" DataSourceID="TafsiliGroupMoienSqlDataSource" Dir="RTL" EditItemStyle-HorizontalAlign="Right"> 

 <ParentTableRelation> 

 <telerik:GridRelationFields DetailKeyField="MoienId" MasterKeyField="MoienId"></telerik:GridRelationFields> 

 </ParentTableRelation> 

  

 <Columns> 

 <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumnTafsiliGroup"> 

 <HeaderStyle Width="20px"></HeaderStyle> 

 </telerik:GridEditCommandColumn> 

  

 <telerik:GridTemplateColumn HeaderText="گروه تفصیلی" ItemStyle-Width="240px"> 

 <ItemTemplate> 

 <%#DataBinder.Eval(Container.DataItem, "TafsiliGroupName")%> 

 </ItemTemplate> 

 <EditItemTemplate> 

 <telerik:RadComboBox runat="server" ID="RadComboBox6" DataTextField="TafsiliGroupName" 

 DataValueField="TafsiliGroupId" DataSourceID="TafsiliGroupDataSource" SelectedValue='<%#Bind("TafsiliGroupId") %>' > 

 </telerik:RadComboBox> 

 </EditItemTemplate> 

  

 <ItemStyle Width="240px"></ItemStyle> 

 </telerik:GridTemplateColumn> 

  

 <telerik:GridButtonColumn ConfirmText="آیا این گروه تفصیلی حذف گردد؟" ButtonType="ImageButton" 

 CommandName="Delete" Text="Delete" UniqueName="DeleteColumn4"> 

 <HeaderStyle Width="20px"></HeaderStyle> 

 <ItemStyle HorizontalAlign="Center" CssClass="MyImageButton"></ItemStyle> 

 </telerik:GridButtonColumn> 

 </Columns> 

 <EditFormSettings> 

 <EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn> 

 </EditFormSettings> 

  

 <ItemStyle BackColor="#80E680"></ItemStyle> 

  

 <AlternatingItemStyle BackColor="#80E680"></AlternatingItemStyle> 

  

 <EditItemStyle HorizontalAlign="Right"></EditItemStyle> 

  

 <PagerStyle PageSizeControlType="RadComboBox"></PagerStyle> 

  

 </telerik:GridTableView> 

 </DetailTables> 

  

 <Columns> 

 <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn"> 

 <HeaderStyle Width="20px"></HeaderStyle> 

 </telerik:GridEditCommandColumn> 

  

 <telerik:GridBoundColumn SortExpression="MoienNum" ItemStyle-HorizontalAlign="Right" HeaderText="کد معین" HeaderButtonType="TextButton" 

 DataField="MoienNum" UniqueName="MoienNum" HeaderStyle-Font-Bold="true" ItemStyle-Width="50"> 

 <HeaderStyle Font-Bold="True"></HeaderStyle> 

  

 <ItemStyle HorizontalAlign="Right" Width="50px"></ItemStyle> 

 </telerik:GridBoundColumn> 

 <telerik:GridBoundColumn SortExpression="MoienName" HeaderStyle-Font-Bold="true" ItemStyle-HorizontalAlign="Right" HeaderText="نام معین" HeaderButtonType="TextButton" 

 DataField="MoienName" UniqueName="MoienName"> 

 <HeaderStyle Font-Bold="True"></HeaderStyle> 

  

 <ItemStyle HorizontalAlign="Right"></ItemStyle> 

 </telerik:GridBoundColumn> 

 <telerik:GridTemplateColumn HeaderText="ماهیت حساب معین" ItemStyle-Width="240px"> 

 <ItemTemplate> 

 <%#DataBinder.Eval(Container.DataItem, "MahiyatMoinName")%> 

 </ItemTemplate> 

 <EditItemTemplate> 

 <telerik:RadComboBox runat="server" ID="RadComboBox2" DataTextField="MahiyatMoinName" 

 DataValueField="MahiyatMoinID" DataSourceID="MahiyatMoienDataSource" SelectedValue='<%#Bind("MahiyatMoinID") %>' > 

 </telerik:RadComboBox> 

 </EditItemTemplate> 

  

 <ItemStyle Width="240px"></ItemStyle> 

 </telerik:GridTemplateColumn> 

  

 <telerik:GridButtonColumn ConfirmText="آیا این حساب معین حذف گردد؟" ButtonType="ImageButton" 

 CommandName="Delete" Text="Delete" UniqueName="DeleteColumn2"> 

 <HeaderStyle Width="20px"></HeaderStyle> 

 <ItemStyle HorizontalAlign="Center" CssClass="MyImageButton"></ItemStyle> 

 </telerik:GridButtonColumn> 

  

 </Columns> 

  

 <EditFormSettings> 

 <EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn> 

 </EditFormSettings> 

  

 <ItemStyle BackColor="#80E680"></ItemStyle> 

  

 <AlternatingItemStyle BackColor="#80E680"></AlternatingItemStyle> 

  

 <EditItemStyle HorizontalAlign="Right"></EditItemStyle> 

  

 <PagerStyle PageSizeControlType="RadComboBox"></PagerStyle> 

 </telerik:GridTableView> 

 </DetailTables> 

  

 <CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings> 

  

 <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn> 

  

 <ExpandCollapseColumn Visible="True" Created="True" FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn> 

 <Columns> 

  

 <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn"> 

 <HeaderStyle Width="20px"></HeaderStyle> 

 <ItemStyle CssClass="MyImageButton"></ItemStyle> 

 </telerik:GridEditCommandColumn> 

  

 <telerik:GridBoundColumn ItemStyle-HorizontalAlign="Right" SortExpression="KolNum" HeaderStyle-Font-Bold="true" HeaderText="کد حساب کل" HeaderButtonType="TextButton" ItemStyle-Width="50" 

 DataField="KolNum" UniqueName="KolNum"> 

 <HeaderStyle Font-Bold="True"></HeaderStyle> 

  

 <ItemStyle HorizontalAlign="Right" Width="50px"></ItemStyle> 

 </telerik:GridBoundColumn> 

 <telerik:GridBoundColumn SortExpression="KolName" HeaderText="نام حساب کل" HeaderStyle-Font-Bold="true" HeaderButtonType="TextButton" 

 DataField="KolName" UniqueName="KolName"> 

  

 <HeaderStyle Font-Bold="True"></HeaderStyle> 

 </telerik:GridBoundColumn> 

 <telerik:GridTemplateColumn HeaderText="ماهیت حساب کل" ItemStyle-Width="240px"> 

 <ItemTemplate> 

 <%#DataBinder.Eval(Container.DataItem, "MahiyatKolName")%> 

 </ItemTemplate> 

 <EditItemTemplate> 

 <telerik:RadComboBox runat="server" ID="RadComboBox2" DataTextField="MahiyatKolName" 

 DataValueField="MahiyatKolId" DataSourceID="MahiyatKolDataSource" SelectedValue='<%#Bind("MahiyatKolId") %>' > 

 </telerik:RadComboBox> 

 </EditItemTemplate> 

  

 <ItemStyle Width="240px"></ItemStyle> 

 </telerik:GridTemplateColumn> 

 <telerik:GridButtonColumn ConfirmText="آیا این حساب کل حذف گردد؟" ButtonType="ImageButton" 

 CommandName="Delete" Text="Delete" UniqueName="DeleteColumn3"> 

 <HeaderStyle Width="20px"></HeaderStyle> 

 <ItemStyle HorizontalAlign="Center" CssClass="MyImageButton"></ItemStyle> 

 </telerik:GridButtonColumn> 

 </Columns> 

  

 <EditFormSettings> 

 <EditColumn UniqueName="EditCommandColumn" FilterControlAltText="Filter EditCommandColumn column"></EditColumn> 

 </EditFormSettings> 

  

 <ItemStyle BackColor="Yellow"></ItemStyle> 

  

 <AlternatingItemStyle BackColor="Yellow"></AlternatingItemStyle> 

  

 <EditItemStyle HorizontalAlign="Right"></EditItemStyle> 

  

 <PagerStyle PageSizeControlType="RadComboBox"></PagerStyle> 

 </telerik:GridTableView> 

 </DetailTables> 

  

 <CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings> 

  

 <RowIndicatorColumn Display="False" FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn> 

  

 <ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column" Created="True"></ExpandCollapseColumn> 

 <Columns> 

 <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn"> 

 <HeaderStyle Width="20px"></HeaderStyle> 

 <ItemStyle CssClass="MyImageButton"></ItemStyle> 

 </telerik:GridEditCommandColumn> 

  

 <telerik:GridBoundColumn SortExpression="GroupHsabNum" HeaderText="کد گروه حساب" HeaderStyle-Font-Bold="true" HeaderButtonType="TextButton" ItemStyle-Width="50" 

 DataField="GroupHsabNum" UniqueName="GroupHsabNum"> 

 <HeaderStyle Font-Bold="True"></HeaderStyle> 

  

 <ItemStyle Width="50px"></ItemStyle> 

 </telerik:GridBoundColumn> 

 <telerik:GridBoundColumn SortExpression="GroupHesabName" HeaderText="نام گروه حساب" HeaderStyle-Font-Bold="true" HeaderButtonType="TextButton" 

 DataField="GroupHesabName" UniqueName="GroupHesabName"> 

 <HeaderStyle Font-Bold="True"></HeaderStyle> 

 </telerik:GridBoundColumn> 

  

 <telerik:GridTemplateColumn HeaderText="نوع گروه حساب" ItemStyle-Width="240px"> 

 <ItemTemplate> 

 <%#DataBinder.Eval(Container.DataItem, "TypeOfGroupHesabName")%> 

 </ItemTemplate> 

 <EditItemTemplate> 

 <telerik:RadComboBox runat="server" ID="RadComboBox2" DataTextField="TypeOfGroupHesabName" 

 DataValueField="TypeOfGroupHesabId" DataSourceID="TypeHesabDataSource" SelectedValue='<%#Bind("TypeOfHesabId") %>' > 

 </telerik:RadComboBox> 

 </EditItemTemplate> 

  

 <ItemStyle Width="240px"></ItemStyle> 

 </telerik:GridTemplateColumn> 

  

  

  

 <telerik:GridButtonColumn ConfirmText="آیا این گروه حساب حذف گردد؟" ButtonType="ImageButton" 

 CommandName="Delete" Text="Delete" UniqueName="DeleteColumn4"> 

 <HeaderStyle Width="20px"></HeaderStyle> 

 <ItemStyle HorizontalAlign="Center" CssClass="MyImageButton"></ItemStyle> 

 </telerik:GridButtonColumn> 

 </Columns> 

  

 <EditFormSettings> 

 <EditColumn UniqueName="EditCommandColumn" FilterControlAltText="Filter EditCommandColumn column"></EditColumn> 

 </EditFormSettings> 

  

 <ItemStyle BackColor="#00CCFF"></ItemStyle> 

  

 <AlternatingItemStyle BackColor="#00CCFF"></AlternatingItemStyle> 

  

 <PagerStyle PageSizeControlType="RadComboBox"></PagerStyle> 

  

 </MasterTableView> 

  

 <ClientSettings Selecting-AllowRowSelect="true"> 

 <Selecting AllowRowSelect="True"></Selecting> 

 </ClientSettings> 

  

 <FilterMenu EnableImageSprites="False"></FilterMenu> 

 </telerik:RadGrid> 

 <asp:SqlDataSource ID="TypeHesabDataSource" ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>" 

 ProviderName="System.Data.SqlClient" SelectCommand="SELECT TypeOfGroupHesabId,TypeOfGroupHesabName FROM TypeOfGroupHesab" 

 runat="server"> 

 </asp:SqlDataSource> 

 <asp:SqlDataSource ID="MahiyatKolDataSource" ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>" 

 ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM MahiyatKol" 

 runat="server"> 

 </asp:SqlDataSource> 

 <asp:SqlDataSource ID="MahiyatMoienDataSource" ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>" 

 ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM MahiyatMoien" 

 runat="server"> 

 </asp:SqlDataSource> 

 <asp:SqlDataSource ID="TafsiliGroupDataSource" ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>" 

 ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM TafsiliGroup" 

 runat="server"> 

 </asp:SqlDataSource> 

 <asp:SqlDataSource ID="TafsiliGroupMoienSqlDataSource" ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>" 

 ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM TafsiliGroupMoien tgm inner join TafsiliGroup tg on tgm.TafsiliGroupId=tg.TafsiliGroupId where MoienId=@MoienId" 

 InsertCommand="INSERT INTO TafsiliGroupMoien(MoienId,TafsiliGroupId) VALUES (@MoienId,@TafsiliGroupId)" 

 DeleteCommand="Delete from TafsiliGroupMoien where TafsiliGroupMoienId=@TafsiliGroupMoienId" 

 UpdateCommand ="Update TafsiliGroupMoien Set MoienId=@MoienId ,TafsiliGroupId=@TafsiliGroupId where TafsiliGroupMoienId=@TafsiliGroupMoienId" 

 runat="server"> 

 <UpdateParameters> 

  

 <asp:Parameter Name="MoienId" Type="Int32"></asp:Parameter> 

 <asp:Parameter Name="TafsiliGroupId" Type="Int16"></asp:Parameter> 

 <asp:Parameter Name="TafsiliGroupMoienId" Type="Int32"></asp:Parameter> 

 </UpdateParameters> 

 <DeleteParameters> 

 <asp:Parameter Name="TafsiliGroupMoienId" Type="Int32"></asp:Parameter> 

 </DeleteParameters> 

 <InsertParameters> 

 <asp:Parameter Name="MoienId" Type="Int32"></asp:Parameter> 

 <asp:Parameter Name="TafsiliGroupId" Type="Int16"></asp:Parameter> 

  

 </InsertParameters> 

 <SelectParameters> 

 <asp:SessionParameter Name="MoienId" SessionField="MoienId" Type="string"></asp:SessionParameter> 

 </SelectParameters> 

  

 </asp:SqlDataSource> 

 <asp:SqlDataSource ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>" 

 ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM GroupHesab g inner join TypeOfGroupHesab t on t.TypeOfGroupHesabId=g.TypeOfHesabId" 

 InsertCommand="INSERT INTO GroupHesab(GroupHesabName,GroupHsabNum,TypeOfHesabId) VALUES (@GroupHesabName,@GroupHsabNum,@TypeOfHesabId)" 

 DeleteCommand="Delete from GroupHesab where GroupHesabId=@GroupHesabId" 

 UpdateCommand ="Update GroupHesab Set GroupHesabName=@GroupHesabName ,GroupHsabNum=@GroupHsabNum,TypeOfHesabId=@TypeOfHesabId where GroupHesabId=@GroupHesabId" 

 runat="server"> 

 <UpdateParameters> 

 <asp:Parameter Name="GroupHesabId" Type="Int32" ></asp:Parameter> 

 <asp:Parameter Name="GroupHesabName" Type="String"></asp:Parameter> 

 <asp:Parameter Name="GroupHsabNum" Type="String"></asp:Parameter> 

 <asp:Parameter Name="TypeOfHesabId" Type="Int16"></asp:Parameter> 

 </UpdateParameters> 

 <DeleteParameters> 

 <asp:Parameter Name="GroupHesabId" Type="Int32"></asp:Parameter> 

 </DeleteParameters> 

 <InsertParameters> 

 <asp:Parameter Name="GroupHesabName" Type="String"></asp:Parameter> 

 <asp:Parameter Name="GroupHsabNum" Type="String"></asp:Parameter> 

 <asp:Parameter Name="TypeOfHesabId" Type="Int16"></asp:Parameter> 

  

 </InsertParameters> 

  

 </asp:SqlDataSource> 

 <asp:SqlDataSource ID="SqlDataSource2" ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>" 

 ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM Kol k LEFT OUTER JOIN MahiyatKol m on k.MahiyatKolID=m.MahiyatKolID Where GroupHesabId = @GroupHesabId" 

 InsertCommand="INSERT INTO Kol(KolName,KolNum,GroupHesabId,MahiyatKolID) VALUES (@KolName,@KolNum,@GroupHesabId,@MahiyatKolID)" 

 DeleteCommand="Delete from Kol where KolId=@KolId" 

 UpdateCommand ="Update Kol Set KolName=@KolName ,KolNum=@KolNum,GroupHesabId=@GroupHesabId,MahiyatKolID=@MahiyatKolID where KolId=@KolId" 

  

 runat="server"> 

 <UpdateParameters> 

 <asp:Parameter Name="KolName" Type="String"></asp:Parameter> 

 <asp:Parameter Name="KolNum" Type="String"></asp:Parameter> 

 <asp:Parameter Name="GroupHesabId" Type="Int32"></asp:Parameter> 

 <asp:Parameter Name="MahiyatKolID" Type="Int16"></asp:Parameter> 

 <asp:Parameter Name="KolId" Type="Int32"></asp:Parameter> 

 </UpdateParameters> 

 <DeleteParameters> 

 <asp:Parameter Name="KolId" Type="Int32"></asp:Parameter> 

 </DeleteParameters> 

 <InsertParameters> 

 <asp:Parameter Name="KolName" Type="String"></asp:Parameter> 

 <asp:Parameter Name="KolNum" Type="String"></asp:Parameter> 

 <asp:Parameter Name="GroupHesabId" Type="Int32"></asp:Parameter> 

 <asp:Parameter Name="MahiyatKolID" Type="Int16"></asp:Parameter> 

  

 </InsertParameters> 

 <SelectParameters> 

 <asp:SessionParameter Name="GroupHesabId" SessionField="GroupHesabId" Type="string"></asp:SessionParameter> 

 </SelectParameters> 

 </asp:SqlDataSource> 

 <asp:SqlDataSource ID="SqlDataSource3" ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>" 

 ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [Moien] m LEFT OUTER JOIN MahiyatMoien mh on m.MahiyatMoinID=mh.MahiyatMoinID where KolId = @KolId" 

 InsertCommand="INSERT INTO Moien(MoienName,MoienNum,KolId,MahiyatMoinId) VALUES (@MoienName,@MoienNum,@KolId,@MahiyatMoinId)" 

 DeleteCommand="Delete from Moien where MoeinId=@MoeinId" 

 UpdateCommand ="Update Moien Set MoienName=@MoienName ,MoienNum=@MoienNum,KolId=@KolId,MahiyatMoinId=@MahiyatMoinId where MoeinId=@MoeinId" 

 runat="server"> 

 <UpdateParameters> 

 <asp:Parameter Name="MoienName" Type="String"></asp:Parameter> 

 <asp:Parameter Name="MoienNum" Type="String"></asp:Parameter> 

 <asp:Parameter Name="KolId" Type="Int32"></asp:Parameter> 

 <asp:Parameter Name="MahiyatMoinId" Type="Int16"></asp:Parameter> 

 <asp:Parameter Name="MoeinId" Type="Int32"></asp:Parameter> 

 </UpdateParameters> 

 <DeleteParameters> 

 <asp:Parameter Name="MoeinId" Type="Int32"></asp:Parameter> 

 </DeleteParameters> 

 <InsertParameters> 

 <asp:Parameter Name="MahiyatMoinId" Type="Int16"></asp:Parameter> 

 <asp:Parameter Name="MoienName" Type="String"></asp:Parameter> 

 <asp:Parameter Name="MoienNum" Type="String"></asp:Parameter> 

 <asp:Parameter Name="KolId" Type="Int32"></asp:Parameter> 

  

 </InsertParameters> 

 <SelectParameters> 

 <asp:SessionParameter Name="KolId" SessionField="KolId" Type="Int32"></asp:SessionParameter> 

 </SelectParameters> 

 </asp:SqlDataSource> 

 </div> 

 </form> 

 </asp:Content>

Thank you

Grid

answered on 15 Jan 2014

1 answer

115 views

RadGrid filtering with JavaScript Ajax and Ajax History

Hello. I am tring to get a grid to filter based on a drop down selection. I have this working fine, except when the page is loaded from a history point.
Below is one of the columns in the my grid. Note the Java script within the RadScriptBlock5.

<telerik:GridTemplateColumn DataField="Sale Price" HeaderText="Price" SortExpression="Sale Price" UniqueName="SalePrice">

<FilterTemplate>

<telerik:RadComboBox ID="RadComboBoxSalePrice" runat="server" AppendDataBoundItems="true"

EnableScreenBoundaryDetection="false" ExpandDirection="Down" DataSourceID="SalePriceDataSource" DataTextField="Sale Price"

DataValueField="Sale Price Numeric" Height="220px" MarkFirstMatch="true" NoWrap="True"

OnClientDropDownOpening="OnClientItemsRequestedHandler" OnClientItemsRequested="OnClientItemsRequestedHandler"

OnClientSelectedIndexChanged="SalePriceIndexChanged"

SelectedValue='<%# TryCast(Container, GridItem).OwnerTableView.GetColumn("SalePrice").CurrentFilterValue%>'

Sort="Ascending" SortCaseSensitive="False" Width="70px">

<Items>

<telerik:RadComboBoxItem Text="All" />

</Items>

</telerik:RadComboBox>

<telerik:RadScriptBlock ID="RadScriptBlock5" runat="server">

<script type="text/javascript">

function SalePriceIndexChanged(sender, args) {

var tableView = $find("<%# TryCast(Container,GridItem).OwnerTableView.ClientID %>");

tableView.filter("SalePrice", args.get_item().get_value(), "EqualTo");

}

</script>

</telerik:RadScriptBlock>

<br />

<div style="height: 35px; margin-top: 5px;">

<asp:ImageButton runat="server" ID="btnClear" ImageUrl="~/images/used equipment clear button.gif" OnClick="btnClear_Click" />

</div>

</FilterTemplate>

<ItemTemplate>

<%# Eval("Price Combo")%>

</ItemTemplate>

<ItemStyle HorizontalAlign="Right" Width="70px" />

<HeaderStyle HorizontalAlign="Right" Width="70px" />

</telerik:GridTemplateColumn>

When the use navigates away from the page, and returns to the page, using the history navigation
I get the following error:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; xs-ivyEL6bAur8;Cm8Afr; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E)

Timestamp: Tue, 14 Jan 2014 19:35:52 UTC

Message: 'SalePriceIndexChanged' is undefined

Line: 247648215

Char: 5

Code: 0

URI: http://localhost/used-equipment.aspx

This java script is wrapped in RadScriptBlock.

Any ideas how to resolve this?

Ajax

answered on 15 Jan 2014

1 answer

187 views

Grid Settings Persister

Good Morning All,

We currently use the GridSettingsPersister class to save the users settings.

I just wanted to ask a quick question as to whether we should be looking to replace that with the Persistence Framework control that is part of the collection.

Basically, are there any benefits for swapping?

Regards, Paul.

Grid

answered on 15 Jan 2014

6 answers

549 views

[Solved] Hide GridBoundColumn on Editform

Hi,

Here is a code snipped from my MasterTableView in my RadGrid. When I clik on the edit hylperlink, I'd like to hide the txtLastName field and its label, so that noone knows it's there and no editing can happen to that field. How can I do this in the code behind?

    
            <Columns>    
        
                    <telerik:GridEditCommandColumn UniqueName="editCommand"></telerik:GridEditCommandColumn>    
        
                    <telerik:GridBoundColumn DataField="numPersonnelID" DataType="System.Int32"      
        
                        HeaderText="Personnel ID" ReadOnly="True" SortExpression="numPersonnelID"      
        
                        UniqueName="numPersonnelID" Visible="False">     
        
                    </telerik:GridBoundColumn>    
        
                    <telerik:GridBoundColumn DataField="txtLastName" HeaderText="Last Name"      
        
                        SortExpression="txtLastName" UniqueName="txtLastName" MaxLength="50" Visible="false">     
        
                    </telerik:GridBoundColumn>    
        
                    <telerik:GridBoundColumn DataField="txtFirstName" HeaderText="First Name"      
        
                        SortExpression="txtFirstName" UniqueName="txtFirstName" MaxLength="50">     
        
                    </telerik:GridBoundColumn>    
        
            </Columns>

Thanks,
Greg

Grid

answered on 15 Jan 2014

3 answers

137 views

Pivot Grid (OLAP) avoid adding fields to inappropriate zones

Pivot grid allows users to add any field to any zone type, but in OLAP connection it doesn't make sense because only measure fields give a meaningful data representation when added to aggregate zone and other dimension fields adding to column/row/filter zones. Configuration Panel Fields Context Menu is misleading because when clicked on any dimension it allows user to add any field to any zone as mentioned. how to avoid this. Disable "move to aggregate fields" for dimension fields and enable only "move to aggregate fields" for measures in Configuration Panel Fields Context Menu.

PivotGrid

answered on 15 Jan 2014

1 answer

340 views

EDITOR,HTML Table borders and PDF Export

Hi! I'm just back from solving a problem with HTML Table borders when being exported to PDF by editor. It seems that the PDF exporter has a bug or a feature :D that makes the border property of the <TABLE> element for the outline border. So that means you need to give borders to every <TD> element that needs one. But if you put them where the outline is, you'll have an ugly extra/double bolded border. If you dont want that you have to specify borders for every TD element that is not outlined by the border property of the <TABLE> element. I know that telerik knows of this bug since when you copy paste a table from MS Word the editor makes tables in the same fashion (they remove some left,right,top borders...). Is this gonna be fixed or should I template my tables for exporting like that?

EDIT (how i came to this problem):

The problem comes when you have custom tags in the editor (e.g. <CustomerTable type=7>). I replace these tags with live data from DB and generate a document like this:

editor_doc.Content = myTemplate.GenerateDocFromTemplate(customerID, editor_doc.Content)

editor_doc.ExportToPdf()

I run a GenerateDocFromTemplate method which just replaces all of the custom TAGs so you're not using the "copy-paste" method described above. That's where the problem comes.

This really should be documented.

Editor

answered on 15 Jan 2014

3 answers

88 views

RadComboBox disabled on IE9 Windows 2008

I have recently upgraded the Telerik.Web.UI.dll to version 2013.3.1114.40. When I tested in my dev environment, everything works as expected. However our QA team has an IE9 browser running on Windows Server 2008. When they point that browser at the application hosted in my dev environment (which is running on Windows 7), the RadComboBox becomes unusable. When you try to click on it, nothing happens. There are many "$telerik is undefined" javascript errors. I have reproduced this behavior using another IE9 browser on a different Windows 2008 box. However, as long as I'm using IE9 on any other machine (running Windows 7), the controls work fine.

I assume that the issue is with the client, maybe some security setting related to Windows 2008/IE9. I have disabled IE ESC and that did not fix the issue. What is causing this problem?

ComboBox

answered on 15 Jan 2014

Top users last month