Questions on UI for ASP.NET AJAX Forum

7 answers

626 views

[Solved] New xlsx format and datetime format

Hi,

How do we set the date format when using the new xlsx format export from a grid?

All we get in Excel is that all datetime columns gets the custom format: M-D-ÅÅÅÅ. No matter what we do...

Even in the online sample, both date columns are formatted in this way:

http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/exporting/excel-export/defaultcs.aspx

We tried setting the DataFormatString of the grid column, no change...

Regards
Andreas

Grid

answered on 13 Jul 2015

1 answer

225 views

radgrid column alignment

I have a column in the grid which returns multiple data vertically. How can I display the content horizontally?

i.e. my column displays:

AB

CD

EF

but I need to display: AB, CD,EF

this is my code:

<telerik:GridBoundColumn DataField="Specialty" HeaderText="Specialty" SortExpression="Specialty" ItemStyle-Width="9%"
HeaderStyle-Width="9%" UniqueName="Specialty"
FilterControlWidth="30px" ItemStyle-HorizontalAlign="Left" FilterControlToolTip="Search by Specialty" AutoPostBackOnFilter="true"
FooterText="Total Credits: " FooterStyle-HorizontalAlign="Right" FooterStyle-Font-Bold="true" FilterImageToolTip="Search by Specialty" HeaderTooltip="Sort by Specialty" >
</telerik:GridBoundColumn>

Thanks,

Grid

answered on 13 Jul 2015

4 answers

129 views

Client side bug

Currently we have a modal, with a grid inside of that. The bug is, if I add a row then delete the same row then attempt to save the grid, there is a javascript error, linked below:

http://prntscr.com/7qf6zr

is this an issue with my code? this bug does not trigger itemcommand, or batcheditcommand. Probably because of the clientside bug.

Grid

answered on 13 Jul 2015

1 answer

152 views

Adding google map to RadPageView

I was interested in adding a google map to a page on a RadMultiPage. How do I get the javascript to execute whenever the specific RadPageView is actually visible?

* At its core, the google map is an image attached to a DIV tag. Here's a decent introduction to an older version (http://www.codeproject.com/Articles/291499/Google-Maps-API-V-for-ASP-NET).

Documentation and Tutorials

answered on 13 Jul 2015

3 answers

58 views

Page numbers

Can you provide an example on how to have page numbers on the exported pdf?

ClientExportManager

answered on 13 Jul 2015

3 answers

235 views

How can I set the select url client side?

I am doing the following at the moment and it seems to work, not sure there is not a method I could use.

var dataSource;

function RequestStart(sender, args) {

dataSource = $find('<%= RadClientDataSource1.ClientID %>');

dataSource._transport.read.url = dataSource._transport.baseUrl + "GetListProducts/3";

};

Thanks, Marty

ClientDataSource

answered on 13 Jul 2015

1 answer

100 views

Setting focus on page after insert

I have the following Radgrid control with AllowPaging = true. The Items in the Radgrid are sorted in decreasing order after the date in the second column. After I insert a row, I want the focus to be set on the page where the item was inserted. I have tried the following code in the Insert_Command event:

<telerik:RadGrid ID="rgCondica"

runat="server"

AllowPaging="true"

AllowCustomPaging="true"

AllowSorting="True"

AutoGenerateColumns="False"

Skin="Windows7"

OnItemCommand="rgCondica_ItemCommand"

OnItemDataBound="rgCondica_ItemDataBound"

OnInsertCommand="rgCondica_InsertCommand"

OnUpdateCommand="rgCondica_UpdateCommand"

OnDeleteCommand="rgCondica_DeleteCommand"

OnNeedDataSource="rgCondica_NeedDataSource"

CellSpacing="0"

CssClass="c1grid"

GridLines="None"

PageSize="5" PagerStyle-ShowPagerText="False"

PagerStyle-AlwaysVisible="true" MasterTableView-NoMasterRecordsText="Nu exista inregistrari" PagerStyle-FirstPageToolTip="Prima pagina"

PagerStyle-LastPageToolTip="Ultima pagina" PagerStyle-PageSizeLabelText="Nr. inregistrari:" PagerStyle-PrevPagesToolTip="Paginile anterioare"

PagerStyle-PrevPageToolTip="Pagina anterioara" PagerStyle-NextPagesToolTip="Paginile urmatoare" PagerStyle-NextPageToolTip="Pagina anterioara">

</telerik:RadGrid>

protected void rgCondica_InsertCommand(object sender,GridCommandEventArgs e){

GridDataItem item = rgCondica.MasterTableView.FindItemByKeyValue("IdCondica", c.IdCondica);

rgCondica.CurrentPageIndex = item.RowIndex;

rgCondica.Rebind();}

but it remains on the last page.

Any help is appreciated. Thank you.

Grid

answered on 13 Jul 2015

1 answer

151 views

How to change colors of RadGantt Buttons

Hi,

I just want to change color for "Week,Day,Month,Year" buttons to white because its unreadable. I couldn't find any property to change them please find the attached image of RadGantt and here is my code

<telerik:RadGantt ID="RadGantt1" runat="server" Height="245px" Width="1122px"
AutoGenerateColumns="false" ReadOnly="true" SelectedView="MonthView">
<YearView UserSelectable="true" />
<Columns>
<telerik:GanttBoundColumn DataField="Title" DataType="String"></telerik:GanttBoundColumn>
</Columns>
<DataBindings >
<TasksDataBindings IdField="ID" TitleField="Title" StartField="Start" EndField="End"
PercentCompleteField="PercentComplete" OrderIdField="OrderID" SummaryField="Summary" ParentIdField="ParentID" />
<DependenciesDataBindings IdField="ID" PredecessorIdField="PredecessorID"
SuccessorIdField="SuccessorID" TypeField="Type" />
</DataBindings>
</telerik:RadGantt>

Gantt

answered on 13 Jul 2015

1 answer

126 views

Not able to update\delete child Grid

I have hierarchy grid. I am able to edit\delete parent grid but not child grid (second grid). I using the same code behind and subs for both the grids. When I click on edit button for row of second grid, it enables edit mode but when I click on update button, it is not changing values on UI nor in database tables. And build is correct, it is not giving any error. Following is my code. If anybody can please help me!

<%@ Page Language="vb" AutoEventWireup="false" Inherits="WebApplication1.invoice_details" CodeBehind="invoice_details.aspx.vb" %>

<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
<telerik:RadSkinManager ID="RadSkinManager1" runat="server" ShowChooser="true" />
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="RadGrid1">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="RadGrid1"></telerik:AjaxUpdatedControl>
</UpdatedControls>
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager>

<div>
<telerik:RadGrid ID="RadGrid1" DataSourceID="SqlDataSource1" runat="server" ShowStatusBar="true"
AutoGenerateColumns="False" AllowSorting="True" AllowMultiRowSelection="False"
AllowAutomaticDeletes="True"
AllowAutomaticUpdates="True" OnItemUpdated="RadGrid1_ItemUpdated" OnItemDeleted="RadGrid1_ItemDeleted">
<PagerStyle Mode="NumericPages"></PagerStyle>
<MasterTableView DataSourceID="SqlDataSource1" EditMode = "InPlace" DataKeyNames="case_id" AllowMultiColumnSorting="True"
Width="100%" CommandItemDisplay="Top" Name="Cases">
<DetailTables>
<telerik:GridTableView EditMode = "InPlace" DataKeyNames="item_id" DataSourceID="SqlDataSource2" Width="100%"
runat="server" CommandItemDisplay="Top" Name="Items">
<ParentTableRelation>
<telerik:GridRelationFields DetailKeyField="case_id" MasterKeyField="case_id"></telerik:GridRelationFields>
</ParentTableRelation>
<Columns>
<telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn2">
<HeaderStyle Width="20px"></HeaderStyle>
<ItemStyle CssClass="MyImageButton"></ItemStyle>
</telerik:GridEditCommandColumn>
<telerik:GridBoundColumn SortExpression="grp_id" HeaderText="Group" HeaderButtonType="TextButton"
DataField="grp_id" UniqueName="grp_id" ReadOnly = "True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="item_id" HeaderText="Item ID" HeaderButtonType="TextButton"
DataField="item_id" UniqueName="item_id" ReadOnly = "True" Visible = "False">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="inv_item_desc" HeaderText="Item Description" HeaderButtonType="TextButton"
DataField="inv_item_desc" UniqueName="inv_item_desc">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="inv_item_rate" HeaderText="Rate" HeaderButtonType="TextButton"
DataField="inv_item_rate" UniqueName="inv_item_rate">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="inv_item_qty" HeaderText="Quantity" HeaderButtonType="TextButton"
DataField="inv_item_qty" UniqueName="inv_item_qty">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="total" HeaderText="Total" HeaderButtonType="TextButton"
DataField="total" UniqueName="total" ReadOnly = "True">
</telerik:GridBoundColumn>
<telerik:GridButtonColumn ConfirmText="Delete these details record?" ButtonType="ImageButton"
CommandName="Delete" Text="Delete" UniqueName="DeleteColumn2">
<HeaderStyle Width="20px"></HeaderStyle>
<ItemStyle HorizontalAlign="Center" CssClass="MyImageButton"></ItemStyle>
</telerik:GridButtonColumn>
</Columns>
</telerik:GridTableView>
</DetailTables>
<Columns>
<telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn">
<HeaderStyle Width="20px"></HeaderStyle>
<ItemStyle CssClass="MyImageButton"></ItemStyle>
</telerik:GridEditCommandColumn>
<telerik:GridBoundColumn SortExpression="case_id" HeaderText="Case ID" HeaderButtonType="TextButton"
DataField="case_id" UniqueName="case_id" MaxLength="5" ReadOnly = "True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="case_file_nbr" HeaderText="Case File Number" HeaderButtonType="TextButton"
DataField="case_file_nbr" UniqueName="case_file_nbr">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="case_desc" HeaderText="Case Description" HeaderButtonType="TextButton"
DataField="case_desc" UniqueName="case_desc">
</telerik:GridBoundColumn>
<telerik:GridButtonColumn ConfirmText="Delete this case?" ButtonType="ImageButton"
CommandName="Delete" Text="Delete" UniqueName="DeleteColumn">
<HeaderStyle Width="20px"></HeaderStyle>
<ItemStyle HorizontalAlign="Center" CssClass="MyImageButton"></ItemStyle>
</telerik:GridButtonColumn>
</Columns>
<SortExpressions>
<telerik:GridSortExpression FieldName="case_desc"></telerik:GridSortExpression>
</SortExpressions>
</MasterTableView>
</telerik:RadGrid>
</div>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="Server=172.18.1.11;Database=ent64ast;user id=entqalogin;password=en7qal8g1n5"
DeleteCommand="DELETE FROM tbl_inv_case WHERE org_id= 'Oindem' and inv_no=31 and case_id = @case_id"
SelectCommand="SELECT case_id,case_file_nbr,case_desc from tbl_inv_case where org_id='Oindem' and inv_no=31"
UpdateCommand="UPDATE tbl_inv_case SET case_file_nbr = @case_file_nbr, case_desc = @case_desc WHERE org_id= 'Oindem' and inv_no=31 and case_id = @case_id">
<DeleteParameters>
<asp:Parameter Name="case_id" Type="String"></asp:Parameter>
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="org_id" Type="String"></asp:Parameter>
<asp:Parameter Name="inv_no" Type="String"></asp:Parameter>
<asp:Parameter Name="case_id" Type="String"></asp:Parameter>
<asp:Parameter Name="case_file_nbr" Type="String"></asp:Parameter>
<asp:Parameter Name="case_desc" Type="String"></asp:Parameter>
<asp:Parameter Name="case_amnt" Type="String"></asp:Parameter>
<asp:SessionParameter Name="login_id" Type="string" SessionField="loginid" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="case_id" Type="String"></asp:Parameter>
<asp:Parameter Name="case_file_nbr" Type="String"></asp:Parameter>
<asp:Parameter Name="case_desc" Type="String"></asp:Parameter>
</UpdateParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="Server=172.18.1.11;Database=ent64ast;user id=entqalogin;password=en7qal8g1n5"
DeleteCommand="DELETE FROM tbl_inv_case_items WHERE org_id= 'Oindem' and inv_no=31 and case_id = @case_id and item_id = @item_id"
SelectCommand="SELECT grp_id,case_id,item_id,inv_item_desc,inv_item_rate,inv_item_qty, cast(inv_item_rate*inv_item_qty as decimal(18,2)) 'total' FROM tbl_inv_case_items WHERE org_id='Oindem' AND inv_no=31 AND case_id = @case_id ORDER BY grp_id,case_id, inv_item_seqn"
UpdateCommand="UPDATE tbl_inv_case_items SET inv_item_desc = @inv_item_desc, inv_item_rate = @inv_item_rate, inv_item_qty = @inv_item_qty WHERE org_id= 'Oindem' AND inv_no=31 AND case_id = @case_id AND item_id = @item_id">
<DeleteParameters>
<asp:Parameter Name="item_id" Type="Int32"></asp:Parameter>
<asp:Parameter Name="case_id" Type="String"></asp:Parameter>
</DeleteParameters>
<SelectParameters>
<asp:Parameter Name="case_id" Type="String"></asp:Parameter>
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="inv_item_desc" Type="String"></asp:Parameter>
<asp:Parameter Name="inv_item_rate" Type="Double"></asp:Parameter>
<asp:Parameter Name="inv_item_qty" Type="Double"></asp:Parameter>
<asp:Parameter Name="item_id" Type="String"></asp:Parameter>
<asp:Parameter Name="case_id" Type="String"></asp:Parameter>
</UpdateParameters>
</asp:SqlDataSource>
</form>
</body>
</html>

Grid

answered on 13 Jul 2015

1 answer

131 views

Batch Editing doesnt work with ajax

Hey guys,

im trying to follow the example from http://demos.telerik.com/aspnet-ajax/grid/examples/data-editing/batch-editing/defaultcs.aspx but i am unable to follow. I removed the datasource part becuase im not having the demo database installed and tried to use some static data instead but it seems like somehow neither my events nor the ajax stuff is fired. Anyone

Codebehind:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using Telerik.Web.UI;

namespace WebApplication2

{

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

DataTable dt = new DataTable();

DataColumn dc1 = new DataColumn();

dc1.ColumnName = "ProductID";

dc1.Caption = "ProductID";

dc1.DataType = typeof(int);

dt.Columns.Add(dc1);

DataColumn dc2 = new DataColumn();

dc2.ColumnName = "ProductName";

dc2.Caption = "ProductName";

dc2.DataType = typeof(string);

dt.Columns.Add(dc2);

DataColumn dc3 = new DataColumn();

dc3.ColumnName = "CategoryID";

dc3.Caption = "CategoryID";

dc3.DataType = typeof(int);

dt.Columns.Add(dc3);

DataColumn dc4 = new DataColumn();

dc4.ColumnName = "CategoryName";

dc4.Caption = "CategoryName";

dc4.DataType = typeof(string);

dt.Columns.Add(dc4);

DataColumn dc5 = new DataColumn();

dc5.ColumnName = "UnitPrice";

dc5.Caption = "UnitPrice";

dc5.DataType = typeof(decimal);

dt.Columns.Add(dc5);

DataColumn dc6 = new DataColumn();

dc6.ColumnName = "Discontinued";

dc6.Caption = "Discontinued";

dc6.DataType = typeof(bool);

dt.Columns.Add(dc6);

DataColumn dc7 = new DataColumn();

dc7.ColumnName = "UnitsInStock";

dc7.Caption = "UnitsInStock";

dc7.DataType = typeof(int);

dt.Columns.Add(dc7);

dt.Rows.Add(1, "name", 1, "cname", 20, false, 20);

RadGrid1.DataSource = dt;

}

protected void RadGrid1_BatchEditCommand(object sender, Telerik.Web.UI.GridBatchEditingEventArgs e)

{

SavedChangesList.Visible = true;

}

protected void RadGrid1_ItemUpdated(object source, Telerik.Web.UI.GridUpdatedEventArgs e)

{

GridEditableItem item = (GridEditableItem)e.Item;

String id = item.GetDataKeyValue("ProductID").ToString();

if (e.Exception != null)

{

e.KeepInEditMode = true;

e.ExceptionHandled = true;

NotifyUser("Product with ID " + id + " cannot be updated. Reason: " + e.Exception.Message);

}

else

{

NotifyUser("Product with ID " + id + " is updated!");

}

protected void RadGrid1_ItemInserted(object source, GridInsertedEventArgs e)

{

if (e.Exception != null)

{

e.ExceptionHandled = true;

NotifyUser("Product cannot be inserted. Reason: " + e.Exception.Message);

}

else

{

NotifyUser("New product is inserted!");

}

protected void RadGrid1_ItemDeleted(object source, GridDeletedEventArgs e)

{

GridDataItem dataItem = (GridDataItem)e.Item;

String id = dataItem.GetDataKeyValue("ProductID").ToString();

if (e.Exception != null)

{

e.ExceptionHandled = true;

NotifyUser("Product with ID " + id + " cannot be deleted. Reason: " + e.Exception.Message);

}

else

{

NotifyUser("Product with ID " + id + " is deleted!");

}

protected void RadGrid1_PreRender(object sender, EventArgs e)

{

//RadNumericTextBox unitsNumericTextBox = (RadGrid1.MasterTableView.GetBatchColumnEditor("UnitsInStock") as GridNumericColumnEditor).NumericTextBox;

//unitsNumericTextBox.Width = Unit.Pixel(60);

}

private void NotifyUser(string message)

{

RadListBoxItem commandListItem = new RadListBoxItem();

commandListItem.Text = message;

SavedChangesList.Items.Add(commandListItem);

}

Markup:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication2._Default" %>

<%@ Register Assembly="Telerik.Web.UI, Culture=neutral, PublicKeyToken=121fae78165ba3d4"

Namespace="Telerik.Web.UI" TagPrefix="telerik" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<html xmlns='http://www.w3.org/1999/xhtml'>

<head id="Head1" runat="server">

<title>Telerik ASP.NET Example</title>

</head>

<body>

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

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

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="RadGrid1">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1" />

<telerik:AjaxUpdatedControl ControlID="SavedChangesList" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<telerik:RadAjaxLoadingPanel runat="server" ID="RadAjaxLoadingPanel1">

</telerik:RadAjaxLoadingPanel>

<div id="demo" class="demo-container no-bg">

<telerik:RadListBox runat="server" ID="SavedChangesList" Width="600px" Height="200px"

Visible="false">

</telerik:RadListBox>

<telerik:RadGrid ID="RadGrid1" GridLines="None" runat="server" AllowAutomaticDeletes="True"

AllowAutomaticInserts="True" PageSize="10" OnItemDeleted="RadGrid1_ItemDeleted"

OnItemInserted="RadGrid1_ItemInserted" OnItemUpdated="RadGrid1_ItemUpdated" OnPreRender="RadGrid1_PreRender"

AllowAutomaticUpdates="True" AllowPaging="True" AutoGenerateColumns="False" OnBatchEditCommand="RadGrid1_BatchEditCommand">

<MasterTableView CommandItemDisplay="TopAndBottom" DataKeyNames="ProductID" HorizontalAlign="NotSet"

EditMode="Batch" AutoGenerateColumns="False">

<BatchEditingSettings EditType="Cell" />

<SortExpressions>

<telerik:GridSortExpression FieldName="ProductID" SortOrder="Descending" />

</SortExpressions>

<Columns>

<telerik:GridBoundColumn DataField="ProductName" HeaderStyle-Width="210px" HeaderText="ProductName"

SortExpression="ProductName" UniqueName="ProductName">

<ColumnValidationSettings EnableRequiredFieldValidation="true">

<RequiredFieldValidator ForeColor="Red" Text="*This field is required" Display="Dynamic">

</RequiredFieldValidator>

</ColumnValidationSettings>

</telerik:GridBoundColumn>

<telerik:GridNumericColumn DataField="UnitsInStock" HeaderStyle-Width="80px" HeaderText="Units In Stock"

SortExpression="UnitsInStock" UniqueName="UnitsInStock">

</telerik:GridNumericColumn>

<telerik:GridCheckBoxColumn DataField="Discontinued" HeaderStyle-Width="80px" HeaderText="Discontinued"

SortExpression="Discontinued" UniqueName="Discontinued">

</telerik:GridCheckBoxColumn>

<telerik:GridTemplateColumn HeaderText="UnitPrice" HeaderStyle-Width="80px" SortExpression="UnitPrice"

UniqueName="TemplateColumn" DataField="UnitPrice">

<ItemTemplate>

<asp:Label runat="server" ID="lblUnitPrice" Text='<%# Eval("UnitPrice", "{0:C}") %>'></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<span>

<telerik:RadNumericTextBox Width="55px" runat="server" ID="tbUnitPrice">

</telerik:RadNumericTextBox>

<span style="color: Red">

<asp:RequiredFieldValidator ID="RequiredFieldValidator1" ControlToValidate="tbUnitPrice"

ErrorMessage="*Required" runat="server" Display="Dynamic">

</asp:RequiredFieldValidator>

</span></span>

</EditItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridButtonColumn ConfirmText="Delete this product?" ConfirmDialogType="RadWindow"

ConfirmTitle="Delete" HeaderText="Delete" HeaderStyle-Width="50px" ButtonType="ImageButton"

CommandName="Delete" Text="Delete" UniqueName="DeleteColumn">

</telerik:GridButtonColumn>

</Columns>

</MasterTableView>

<ClientSettings AllowKeyboardNavigation="true">

</ClientSettings>

</telerik:RadGrid>

</div>

</form>

</body>

</html>

Grid

answered on 13 Jul 2015