Questions on UI for ASP.NET AJAX Forum

1 answer

150 views

Tab Strip with vertical text

hi

is there any skin/easy way of implementing the tab strip in vertical mode , but having the text vertical too ?

Peter

TabStrip

answered on 23 Apr 2015

2 answers

64 views

Using this control as plain textbox that completes the text you start typing

Can I use RadAutoCompleteBox for completing the text I write (not selecting single or multiple items) and bind just the text property in design time?

AutoCompleteBox

answered on 23 Apr 2015

1 answer

153 views

Databound source - Conditional item binding (and/or editing)

Hi.
I am porting an old applications chart section from RadChart to RadHtml chart and am struggeling with how to edit serie items prior to rendering. The main problem is that since we are binding against an list of objects where some integer properties contains -1 values (which in our context means NULL/UNDEFINED). I cannot change this behaviour of the object since the system heavily rely on that fact.

When using RadChart we could "hook into" the series items in the ItemDataBound event. See example below.

How can I achieve the same thing with RadHtmlChart ?

BR
Johan

var columnInfo = _basicReportsPresenter.GetColumnInfoByName(e.ChartSeries.DataYColumn);

if (!columnInfo.ColumnInfoAttribute.DisplayNegativeValues)

{

if (e.SeriesItem.YValue < 0)

{

if (_enableEmptyValues)

e.SeriesItem.Empty = true;

e.SeriesItem.YValue = 0;

}

Chart (HTML5)

answered on 23 Apr 2015

1 answer

219 views

UpdateCommand radgrid batch editing problem

Hi !
I'm trying to resolve a problem for a long time now without success and I really can’t find a solution…. Please, help me…
My problem is in the RadGrid1_UpdateCommand()
I can’t get a value from a RadNumericTextBox
Well, I get the value, but when there is a multiple edited values, my code only get the last edited value of the RadNumericTextBox

What I want to do :
I have 3 tables in my databases :

PRODUCTS
product_id
group_ref
…

CATEGORIES
category_id
…

LINKS
link_id
link_product_id
link_category_id
link_points

See my attached image to see the links between them..

This is my select command to fill the radgrid :
select distinct group_ref, link_points, link_category_id
FROM LINKS
INNER JOIN PRODUCTS ON PRODUCTS.product_id = LINKS.link_product_id
WHERE link_category_id=10
ORDER BY link_points desc, group_ref

I want to update all link_points that are associated to a link_category_id AND a group_ref
In the PRODUCTS Table, many products can have the same group_ref value.

So, this is my update command I want to do :
UPDATE LINKS SET link_points = ???
FROM LINKS
INNER JOIN PRODUCTS ON PRODUCTS.product_id = LINKS.link_product_id
WHERE group_ref ='xxxxx' AND link_category_id=xxxxx

This is my Radgrid html code :
<telerik:RadGrid ID="RadGrid1" GridLines="None" runat="server" AllowAutomaticInserts="false" AllowAutomaticDeletes="false" AllowAutomaticUpdates="True"
Skin="Metro" Width="100%" OnLoad="Unnamed_Load1" PageSize="100" AllowPaging="True" DataSourceID="SqlDataSource1" AutoGenerateColumns="False"
OnPreRender="RadGrid1_PreRender" OnItemDataBound="RadGrid1_ItemDataBound" OnUpdateCommand="RadGrid1_UpdateCommand">

<PagerStyle Mode="NextPrevAndNumeric" Position="Bottom" PageSizeLabelText="Nombre de ligne(s) :" PageSizeControlType="None" PageSizes="100"
NextPageToolTip="Page suivante" PrevPageToolTip="Page précédente" FirstPageToolTip="Première page" LastPageToolTip="Dernière page" />

<MasterTableView CommandItemDisplay="TopAndBottom" AllowAutomaticInserts="false" EditMode="Batch" InsertItemDisplay="bottom" AllowAutomaticUpdates="true"
DataSourceID="SqlDataSource1" HorizontalAlign="NotSet" AutoGenerateColumns="False">

<BatchEditingSettings EditType="Cell" />

<SortExpressions>
<telerik:GridSortExpression FieldName="group_ref" SortOrder="Descending" />
</SortExpressions>

<Columns>
<telerik:GridBoundColumn DataField="link_category_id" HeaderText="Produit matière" ReadOnly="true"
ItemStyle-HorizontalAlign="left" HeaderStyle-HorizontalAlign="left"
SortExpression="link_category_id" UniqueName="link_category_id">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="group_ref" HeaderText="Ref. de groupe" ReadOnly="true"
ItemStyle-HorizontalAlign="left" HeaderStyle-HorizontalAlign="left"
SortExpression="group_ref" UniqueName="group_ref">
</telerik:GridBoundColumn>
<telerik:GridNumericColumn DataField="link_points"
ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center"
HeaderStyle-Width="100px" HeaderText="Classement" ItemStyle-Width="100px"
SortExpression="link_points" UniqueName="link_points">
</telerik:GridNumericColumn>

</Columns>

</MasterTableView>

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

</telerik:RadGrid>

And this is my code behind :

Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
If Not IsPostBack Then
GET_SELECT_CMD()
End If
End Sub

Private Sub GET_SELECT_CMD()
Dim sscatid As String = Trim(Request.QueryString("o"))
Dim strCmd As String = "select distinct group_ref, link_points, link_category_id "
strCmd = strCmd & " from LINKS "
strCmd = strCmd & " INNER JOIN PRODUCTS ON PRODUCTS.product_id = LINKS.link_product_id "
strCmd = strCmd & " WHERE link_category_id=" & sscatid & " "
strCmd = strCmd & " ORDER BY link_points desc, group_ref "
SqlDataSource1.SelectCommand = strCmd
RadGrid1.MasterTableView.BatchEditingSettings.OpenEditingEvent = GridBatchEditingEventType.Click
End Sub

Protected Sub Unnamed_Load1(sender As Object, e As EventArgs)
GET_SELECT_CMD()
End Sub

Protected Sub RadGrid1_UpdateCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs)
Dim db As New DAL_SQL
Try
Dim item As GridEditableItem = DirectCast(e.Item, GridEditableItem)
Dim TriNumericTextBox As RadNumericTextBox = TryCast(item.OwnerTableView.GetBatchColumnEditor("link_points"), GridNumericColumnEditor).NumericTextBox
Dim strTriValue As String = TriNumericTextBox.Text.ToString()
Dim strSsCatId As String = Trim(Request.QueryString("o"))
Dim strRefGroupe As String = item.Cells(3).Text
If Not ((strTriValue <> "") And IsNumeric(strTriValue)) Then
strTriValue = "0"
End If
Dim sql_upd As String = "UPDATE LINKS SET link_points = " & strTriValue & " "
sql_upd = sql_upd & " FROM LINKS "
sql_upd = sql_upd & " INNER JOIN PRODUCTS ON PRODUCTS.product_id = LINKS.link_product_id "
sql_upd = sql_upd & " WHERE group_ref='" & strRefGroupe & "' AND link_category_id=" & strSsCatId
db.ExecuteNonQuery(sql_upd)
Catch ex As Exception
ErrTxt = ex.ToString()
End Try
db = Nothing
End Sub

Protected Sub RadGrid1_ItemDataBound(sender As Object, e As GridItemEventArgs)
If TypeOf e.Item Is GridCommandItem Then
Dim addButton As Button = TryCast(e.Item.FindControl("AddNewRecordButton"), Button)
addButton.Visible = False
Dim lnkButton As LinkButton = DirectCast(e.Item.FindControl("InitInsertButton"), LinkButton)
lnkButton.Visible = False
End If
End Sub

Everything works fine, but the line in RadGrid1_UpdateCommand() only get the last edited value and not the value of each item edited :
Dim TriNumericTextBox As RadNumericTextBox = TryCast(item.OwnerTableView.GetBatchColumnEditor("link_points"), GridNumericColumnEditor).NumericTextBox

How can I get the value of each RadNumericTextBox ?

Thanks a lot for every help you could give to me.

Grid

answered on 23 Apr 2015

1 answer

93 views

How to get the currentId of a content in inline editor

Hi,

I want to save data in database using inline editor but i am facing a problem.How can i get the Id of current content in the editor so can i save data.

Please help me on this issue.

Grid

answered on 23 Apr 2015

1 answer

109 views

NestedViewTemplate ItemCommand Bug

When we upgraded to 2015 Q1 release our itemCommand for a linkbutton inside a NesterViewTemplate stopped working. after reading the latest release notes it stated something which we thought would fix this but it did not, the note said,

The ItemCommand event is not fired when row was clicked and the grid is placed in NestedViewTemplate of another RadGrid.

But we don't have a grid relation between separate grids, or row click, but our issue is the ItemCommand event inside the first grid is not fired. our linkbutton (ID "lbDeletePart" below) should fire but does not..

<telerik:RadGrid ID="grArtList" runat="server" AllowSorting="true" onneeddatasource="grArtList_NeedDataSource" AutoGenerateColumns="False" CellSpacing="0" GridLines="None"

BorderStyle="None" Width="100%" AllowPaging="True" PageSize="20" onitemdatabound="grArtList_ItemDataBound" onitemcreated="grArtList_ItemCreated" EnableLinqExpressions="false"

onitemcommand="grArtList_ItemCommand" onprerender="grArtList_PreRender" EnableEmbeddedSkins="false" Skin="SLP" RegisterWithScriptManager="true"

AllowMultiRowSelection="true" OnColumnCreated="grArtList_ColumnCreated">

<ClientSettings DataBinding-ShowEmptyRowsOnLoad="false">

<ClientEvents OnRowMouseOver="rowExpand" OnRowSelected="rowExpand" OnRowCreated="checkBlocked" />

<Selecting AllowRowSelect="true" />

</ClientSettings>

<MasterTableView ShowHeadersWhenNoRecords="true" ShowGroupFooter="true" DataKeyNames="art_artnr, art_id, koppl_id, CartQuantity" ClientDataKeyNames="art_artnr, art_id, koppl_id, CartQuantity" HierarchyLoadMode="Client" CommandItemDisplay="Top">

<ExpandCollapseColumn Visible="false"></ExpandCollapseColumn>

<CommandItemTemplate>

<div style="padding: 5px 5px;">

<asp:LinkButton ID="lbAddPart" runat="server"><img src="Images/icons/24x24/Add.png" title="Add Part to Vehicle"/></asp:LinkButton>

<asp:LinkButton ID="lbCopyParts" runat="server" CommandName="CopySelected" Visible="True"><img src="Images/icons/24x24/copy.png" title="Copy selected parts to another Vehicle" /></asp:LinkButton>

</div>

</CommandItemTemplate>

<GroupByExpressions>

<telerik:GridGroupByExpression>

<SelectFields>

<telerik:GridGroupByField FieldName="category" HeaderText="category" />

</SelectFields>

<GroupByFields>

<telerik:GridGroupByField FieldName="category" SortOrder="Descending" />

</GroupByFields>

</telerik:GridGroupByExpression>

</GroupByExpressions>

<GroupHeaderTemplate>

<table style="border:none;">

<tr>

<td>

<asp:Label runat="server" ID="Label1" CssClass="txtGridGroupHeader" Text='<%# Eval("category") %>'>

</asp:Label>

</td>

<td>

<asp:Label runat="server" ID="labGroupCatCode" Visible="false" Text='<%# Eval("artkod") %>'></asp:Label>

<asp:LinkButton ID="lbAddPartByKat" runat="server" Visible="false"><img style="border:0; vertical-align:middle;" alt="" src="Images/icons/16x16/Add.png"/>Add new part to category</asp:LinkButton>

<asp:LinkButton ID="lbAddDrawing" runat="server" Visible="false"><img style="border:0; vertical-align:middle;" alt="" src="Images/icons/16x16/Add.png"/>Add new drawing to category</asp:LinkButton>

</td>

</tr>

<tr>

<td colspan="2">

<telerik:RadListView runat="server" ID="liDrawingMiniatures" ItemPlaceholderID="miniaturesContainer">

<LayoutTemplate>

<div style="width:100%;" id="list">

<asp:Panel ID="miniaturesContainer" runat="server">

</asp:Panel>

</div>

</LayoutTemplate>

<ItemTemplate>

<div id="miniatureItem" class="drawingMiniatureContainer" style="float:left; text-align:center;">

<a href='<%# "drawing.aspx?drawingID=" + Eval("abd_id") %>'><img id="imgMiniature" src='<%# Eval("abd_path")%>' height="125" alt="" /><br />

<asp:Label runat="server" ID="labDrawingName" Text='<%# Eval("Name")%>'></asp:Label></a><br /><br />

</div>

</ItemTemplate>

</telerik:RadListView>

</td>

</tr>

</table>

</GroupHeaderTemplate>

<Columns>

<telerik:GridBoundColumn DataField="art_artnr" UniqueName="art_artnr" Display="false" HeaderText="art_artnr" CurrentFilterFunction="NoFilter" FilterListOptions="VaryByDataType" ForceExtractValue="None" ReadOnly="true">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="art_id" FilterControlAltText="Filter art_id column" UniqueName="art_id" HeaderText="art_id">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="blocked" UniqueName="blocked" HeaderText="" HeaderStyle-Width="2px" ItemStyle-Width="2px" CurrentFilterFunction="NoFilter" FilterListOptions="VaryByDataType" ForceExtractValue="None" ReadOnly="true">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn UniqueName="chkOrdersvar" ItemStyle-Width="8px" HeaderStyle-Width="8px">

<ItemTemplate>

<asp:CheckBox id="chkCopy" runat="server" Text=" "></asp:CheckBox>

</ItemTemplate>

<HeaderTemplate>

<input id="chkCheckAll" onchange="for (var i = 0

; i < document.all.length; i++){ if (document.all(i).id.indexOf('chkCopy') > 0) { document.all(i).checked = chkCheckAll.checked; }}" type="checkbox" value="ChangeMe" />

</HeaderTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Art No." SortExpression="art_artnr" DataField="art_artnr" UniqueName="art" ItemStyle-Width="115px" >

<ItemTemplate>

<asp:HyperLink ID="hlArtnr" runat="server" NavigateUrl="#" Text='<%# Eval("art_artnr") %>'></asp:HyperLink>

<div id="container">

<div id="box"> </div>

</div>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Name" SortExpression="ben" DataField="ben" >

<ItemTemplate>

<asp:HyperLink ID="hlArtben" runat="server" NavigateUrl="#" Text='<%# Eval("ben") %>'></asp:HyperLink>

<asp:Label ID="labNews" CssClass="labNews" runat="server" Visible="false"> (New)</asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="refnr" FilterControlAltText="Filter ritning column" UniqueName="ritning" HeaderText="Volvo ref.">

</telerik:GridBoundColumn>

<telerik:GridNumericColumn DataField="display_price" DecimalDigits="2" FilterControlAltText="Filter Price column" UniqueName="price" HeaderText="Price" DataFormatString="{0:N}" DataType="System.Decimal">

<HeaderStyle HorizontalAlign="Right" />

<ItemStyle HorizontalAlign="Right" />

</telerik:GridNumericColumn>

<telerik:GridBoundColumn DataField="test" FilterControlAltText="Filter InStock column" UniqueName="test" HeaderText="test">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="category" FilterControlAltText="Filter category column" UniqueName="category" HeaderText="category">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="koppl_id" UniqueName="koppl_id" HeaderText="koppl_id">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="nyhet" UniqueName="nyhet" HeaderText="News">

</telerik:GridBoundColumn>

</Columns>

<NestedViewSettings>

<ParentTableRelation>

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

</ParentTableRelation>

</NestedViewSettings>

<NestedViewTemplate>

<asp:Panel ID="NestedViewPanel" runat="server" CssClass="divArtDetailsView">

<div class="contactWrap">

<table width="100%" cellpadding="0" cellspacing="0">

<tr>

<td width="130px">

<asp:image runat="server" ID="imgArt" src="" />

</td>

<td style="vertical-align:top;">

<asp:LinkButton ID="lbEditPart" runat="server" style="display:none;"><img style="border:0px;vertical-align:middle;" alt="" src="Images/icons/16x16/edit.png"/>Edit attributes</asp:LinkButton>

<asp:LinkButton ID="lbDeletePart" runat="server" style="display:none;" CommandName="deletePart"><img style="border:0px;vertical-align:middle;" alt="" src="Images/icons/16x16/delete.png"/>Delete part</asp:LinkButton>

<asp:Label runat="server" ID="labAttribut" Text=""></asp:Label>

</td>

<td style="vertical-align:top; text-align:right; padding-right:5px;">

<telerik:RadButton runat="server" ID="btnPinRow" AutoPostBack="false" ButtonType="ToggleButton" ToggleType="CheckBox" Checked="false" OnClientCheckedChanged="pinChanged">

<ToggleStates>

<telerik:RadButtonToggleState Width="16px" IsBackgroundImage="true" ImageUrl="images/pinned.png" />

<telerik:RadButtonToggleState Width="16px" IsBackgroundImage="true" ImageUrl="images/unpinned.png" HoveredImageUrl="images/pinned.png" Selected="false" />

</ToggleStates>

</telerik:RadButton>

<br /><br />

<telerik:RadNumericTextBox runat="server" ID="txtAnt" Width="45px" NumberFormat-DecimalDigits="0" Value="1" MinValue="0"></telerik:RadNumericTextBox>

<telerik:RadButton runat="server" ID="btnAddToCart" Text="Add" Skin="Telerik" AutoPostBack="False" OnClientClicked="btnAddToCart_clicked"></telerik:RadButton>

<br />

<asp:Label runat="server" ID="labAvailability" Text="Availability:"></asp:Label>

<asp:Label runat="server" ID="labStock" Text=""></asp:Label>

</td>

</tr>

</table>

</div>

</asp:Panel>

</NestedViewTemplate>

</MasterTableView>

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

</telerik:RadGrid


protected void grArtList_ItemCommand(object sender, GridCommandEventArgs e)
    {
        #region Copy
        if (e.CommandName == "CopySelected")
        {
            mService = new monService.SrvCoreClient();
 
            List<int> idList = new List<int>();
 
            foreach (GridDataItem item in grArtList.Items)
            { //Går igenom varje rad i dgOrdersvar
                CheckBox chk = (CheckBox)item.FindControl("chkCopy");
                if (chk.Checked) //Känner av om Checkboxen är ikryssad (den ska med)
                {
                    int rowID = int.Parse(item.GetDataKeyValue("koppl_id").ToString());
                    idList.Add(rowID);
                }
            }
            Session.Remove("copyIDList");
            Session.Add("copyIDList", idList);
 
            string CopyUrl = "'admCopyPopup.aspx?type=" + Request.QueryString["type"].ToString() + "'";
 
            RadAjaxManager.GetCurrent(Page).ResponseScripts.Add(String.Format("OpenWindow(" + CopyUrl + ", " + "'winCopy'); return false;"));
 
        }
        #endregion
 
        #region delete
        if (e.CommandName == "deletePart")
        {
            GridNestedViewItem nestedRow = (GridNestedViewItem)e.Item;
            GridDataItem row = (GridDataItem)nestedRow.ParentItem;
 
            mService = new monService.SrvCoreClient();
            DataTable dtSend = mService.GetEmptyMonodbcTable(common.getSession(Session).id, "anp_bw_artkoppling");
 
            dtSend.Clear();
            DataRow rowToDelete = dtSend.NewRow();
            rowToDelete["id"] = Convert.ToInt32(row.GetDataKeyValue("koppl_id").ToString());
 
            try
            {
                dtSend.Rows.Add(rowToDelete);
                mService.ExecuteDbRequest(common.getSession(Session).id, "anp_bw_artkoppling", dtSend, monService.DbHandlerdb_request_type.Delete, "EN", 0);
                grArtList.Rebind();
            }
            catch (Exception ex)
            {
                Label lblError = new Label();
                lblError.Text = "Unable to delete record. Reason: " + ex.Message;
                lblError.ForeColor = System.Drawing.Color.Red;
                grArtList.Controls.Add(lblError);
                e.Canceled = true;
            }
        }
        #endregion
    }

Grid

answered on 23 Apr 2015

1 answer

140 views

How to get user control defined by EditFormSettings when edit command button clicked

How to get user control defined by EditFormSettings when edit command button clicked?

I'm using a user control to update data, and setting EditFormSettings like this :

when "Edit" button clicked, the area defined in my webusercontrol is toggled, but the data was not loaded into the edit area, and just like this:

I used OnDataBound method to look for the usercontrol, but it does not work. and the code is like this:

In the function, the value of userControl is null

how to solve this problem?

Grid

answered on 23 Apr 2015

1 answer

123 views

Binding RadHtmlChart

hi,

i'm using control RadHtmlChart wich i bind it programaticly

this is part of my code and in the pic the data don't display i dont know why plz help me i'm using gridview to make sure if i have data in datatable and it works

string req = " select time_tag,[ain_sebou|niveau] from QTSW_DATA1 where time_tag between '15/01/2015 10:49:59' AND '15/02/2015 10:49:59'";
Connecter();
if (DS.Tables.Contains("TRChart"))
{
DS.Tables.Remove("TRChart");
}
SqlDataAdapter da = new SqlDataAdapter(req, con);
da.Fill(DS, "TRChart");
Deconnecter();
RChart.DataSource = DS.Tables["TRChart"];
RChart.DataBind();

ScatterLineSeries SL = new ScatterLineSeries();
SL.DataFieldX = "time_tag";
SL.DataFieldY = "ain_sebou|niveau";
RChart.PlotArea.Series.Add(SL);
RChart.PlotArea.XAxis.TitleAppearance.Text = "Date Time";
RChart.PlotArea.YAxis.TitleAppearance.Text = "Value Of AIn Sebou";

// here i bind Gridview

Gridview1.DataSource = DS.Tables["TRChart"];
Gridview1.DataBind();

plzz i need help

Chart (HTML5)

answered on 23 Apr 2015

1 answer

72 views

Export PDF missing links in nodes

Hi there,

We're using Org Chart with enable drill down and load on demand and data bind in code behind file.

Org Chart also have zooming feature ON.

When exporting char to pdf it only show NODES but there in not links/lines between nodes.

But if we disabled zooming it work well.

Any idea please?

OrgChart

answered on 23 Apr 2015

1 answer

123 views

Binding to linq anonymous type

Hi,

Im having an issue trying to bind to a linq anonymous type. I can bind find as long as i don't specify a 'DataFieldParentID', if i specify that DataFieldParentID then the dropdowntree control just displays no items.

So if i comment out the line below: rdt.DataFieldParentID = "ParentID"; then the control loads fine with the options i expect and i am able to select and use them fine, it simply seems to be an issue when trying to create a hierarchy.

My drop down tree control is inside a RadListView and i am binding on the ItemDataBound event, my code for binding if the following:

var x = from y in services select new { ID = y.ID, ParentID = y.PrimaryWorkType.ID, myText = y.Description};

RadDropDownTree rdt = (RadDropDownTree)e.Item.FindControl("ddlAffectedServices");

rdt.DataTextField = "myText";

rdt.DataValueField = "ID";

rdt.DataFieldID = "ID";

rdt.DataFieldParentID = "ParentID";

rdt.DataSource = x;

rdt.DataBind();

DropDownTree