Questions on UI for ASP.NET AJAX Forum

1 answer

655 views

Setting borders (left,right,top,bottom) on Export to excel (HTML)

I'm exporting a grid to Excel (HTML format) and i Need to have more control over the borders.

For example If I have columns "A","B", and "C" and I do not want to see the B's right border, which I guess you could also assume was C's left border.

How can I, upon exporting to excel from the rad grid, set this properly.

I've created the desired look in EXCL and attached a screen shot.

Thanks,

Grid

answered on 25 Jun 2015

3 answers

192 views

Will Telerik Rad controls (server side controls) work with angularJS?

I am searching for a solutions for 2days

Is it possible to telerik rad controls inside a AngularJS Single page application? when i add a rad combo box or an rad grid. i am getting the display of the grild/combo. but non of the basic functionality working in the page

for example when i add a rad grid: pagination, sorting, grouping fix/width/height not working. But when i enable fillter in the grid the filter is working perfectly.

Any Idea why? if you need i can attach the source file.

General Discussions

answered on 25 Jun 2015

1 answer

105 views

Grid and Form integration

I'm trying to write a grid and form where the form will display the data for the line selected on the grid.

Grid and DS

<telerik:RadGrid ID="GridPeople" runat="server" AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="SQLDSPeople" GroupPanelPosition="Top">

<ClientSettings EnablePostBackOnRowClick="true">

<Selecting AllowRowSelect="True" />

</ClientSettings>

<MasterTableView DataSourceID="SQLDSPeople">

<Columns>

<telerik:GridBoundColumn DataField="person_ref" visible="false" UniqueName="person_ref" />

<telerik:GridBoundColumn DataField="forename1" FilterControlAltText="Filter" HeaderText="Forename" UniqueName="forename" />

<telerik:GridBoundColumn DataField="surname" FilterControlAltText="Filter" HeaderText="Surname" UniqueName="surname" />

</Columns>

</MasterTableView>

</telerik:RadGrid>

<asp:SqlDataSource ID="SQLDSPeople"

runat="server"

ProviderName="System.Data.SqlClient"

SelectCommand="SELECT [person_ref], [forename1 ], [surname] FROM [PERSON] " />

With just this, everything works find, I can select different rows and the row highlights and the code behind event gets called.

Here's the dataform and its DS.

<telerik:RadDataForm ID="FormPerson" runat="server" DataKeyNames="person_ref" DataSourceID="SQLDSPerson">

<LayoutTemplate>

<div id="itemPlaceholder" runat="server"></div>

</LayoutTemplate>

<ItemTemplate>

<fieldset>

<div>

<asp:Label runat="server" ID="FirstNameLabel2" Text="First Name:"></asp:Label>

<telerik:RadTextBox runat="server" ID="FirstNameTextBox2" Text='<%# Bind("forename1")%>' MaxLength="20" />

</div>

<div>

<asp:Label runat="server" ID="LastNameLabel2" Text="Last Name:"></asp:Label>

<telerik:RadTextBox runat="server" ID="LastNameTextBox2" Text='<%# Bind("surname")%>' MaxLength="20" />

</div>

<div>

<telerik:RadButton ID="ButtonUpdate" Text="Update" runat="server" CommandName="Update" />

</div>

</fieldset>

</ItemTemplate>

</telerik:RadDataForm>

<asp:SqlDataSource ID="SQLDSPerson"

runat="server"

ProviderName="System.Data.SqlClient"

SelectCommand="SELECT [person_ref], [forename1], [surname] FROM [PERSON] WHERE ([person_ref] = @person_ref)"

UpdateCommand="UPDATE [PERSON] SET [forename1] = @forename1, [surname] = @surname WHERE [person_ref] = @person_ref">

<SelectParameters>

<asp:ControlParameter ControlID="GridPeople" Name="person_ref" PropertyName="SelectedValue" Type="String" />

</SelectParameters>

<UpdateParameters>

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

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

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

</UpdateParameters>

</asp:SqlDataSource>

As soon as I add this, the grid select row stops working and no events are fired. Also, the grid doesn't appear at all.

Here's the code behind bits.

Private Sub Page_Init1(sender As Object, e As EventArgs) Handles Me.Init

SQLDSPeople.ConnectionString = MyConnStr

SQLDSPerson.ConnectionString = MyConnStr

End Sub

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If Not IsPostBack Then

GridPeople.SelectedIndexes.Add(0)

End If

End Sub

Private Sub GridPeople_SelectedIndexChanged(sender As Object, e As EventArgs) Handles GridPeople.SelectedIndexChanged

FormPerson.Rebind()

End Sub

Private Sub FormPerson_ItemUpdated(sender As Object, e As Telerik.Web.UI.RadDataFormUpdatedEventArgs) Handles FormPerson.ItemUpdated

GridPeople.Rebind()

End Sub

Am I doing something wrong in the RadDataForm ?

General Discussions

answered on 25 Jun 2015

2 answers

93 views

Error with Drag and Drop in Filtereds Fields

Hi Guys i have two problems with the pivotgrid...

1.- Is when use the drag and drop for move a field into the everywhere boxes (all fields, filter fields, row fields, column fields, aggregate filds)

2.- I was implement the export to excel from this example and works fine, but when i am group the fields programatically with this other example, the excel have no data...

thanks a lot.. srry for my bad english

PivotGrid

answered on 25 Jun 2015

1 answer

147 views

RadGrid hide wrapped text

I have a RadGrid with many columns but one column has a lot of text and I want its width to be 150px.

I do not want it to wrap to the next line, it needs to be one line but it must hide all of the wrapped text.

By hide I mean the user should be able to drag the size of the column and if they make it bigger more text can be visible.

How is that achieved?

Grid

answered on 25 Jun 2015

1 answer

76 views

Creating a column of links which depend on data in Radgrid

Hello

I currently have a RadGrid with some data which is fetched with a stored procedure. After the grid is populated I append a GridHyperLinkColumn to the end of it. I am trying to store links in each cell of this column whose URL parameter depends on a value stored in the same row of the grid. Is there a simple way to iterate through each link in the column and construct a URL based on the value of a cell in that same row?

Thanks for the help.

Grid

answered on 25 Jun 2015

1 answer

95 views

Setting Upload Enabled With Javascript Problem

Hello,

My problem is this:

I have an upload control (Cloud or Async depending on the setup) in a mulitpage tab.

I have a checkbox that the user has to check to say that they have the right to upload the file.

I would like to disable the Upload until the user checks the checkbox

If I set the Upload Enabled to false in the code behind, when I set it to enabled with javascript (upload.set_enabled(true)) the Upload no longer functions (the file dialog does not open when the control is clicked).

I have tried to set upload.set_enabled(false) when the document is ready but this doesn't work because the Upload is on a tab it isn't rendered until that tab is open, I think, and so a $find(uploadclientid) in javascript returns null.

Is there a workaround for any of this?

Thank you

Paul Herzberg

Upload (Obsolete)

answered on 25 Jun 2015

1 answer

152 views

Too Many Tabs Issue in Small screen view

Hello,

I have a 15 Tabs on my TabStrip(each tab has 10 child Tabs). It Show all Tabs in One Line on Big Screen(like Desktops or Big Monitors)

But on small screens(Laptops) TabStrip shows as Two Lines and occupying 20% off screen height.

I tried to use ScrollChildren="true" but it didn't work

So is there any way if it's small a screen then display rest of the Tabs like Menu option?

TabStrip

answered on 25 Jun 2015

6 answers

549 views

In custome paging Next ,Previous ,Fisrt, Last Paging button not working

When i click on fist second Page index it works good but when i click on Next,Previous and last Fist Page Index Button it does not working.

here is my aspx page

<telerik:RadGrid ID="grdReferralSearch" runat="server" AllowFilteringByColumn="True"

AllowPaging="True" AllowCustomPaging="true" AutoGenerateColumns="False" GridLines="None"

OnItemDataBound="grdReferralSearch_OnItemDataBound" OnItemCreated="grdReferralSearch_ItemCreated"

Width="100%" Skin="Windows7" ShowGroupPanel="false" CellSpacing="0" PageSize="50"

OnPageIndexChanged="grdReferralSearch_PageIndexChanged" OnPageSizeChanged="grdReferralSearch_PageSizeChanged">

<GroupingSettings ShowUnGroupButton="true" CaseSensitive="false" />

<MasterTableView DataKeyNames="Id" AllowFilteringByColumn="True" ShowHeader="true"

AllowMultiColumnSorting="false" >

<ItemStyle BorderStyle="Solid" />

<SortExpressions>

<telerik:GridSortExpression FieldName="ReferralName" SortOrder="Ascending" />

</SortExpressions>

<HeaderStyle Font-Bold="true" />

<Columns>

<telerik:GridBoundColumn DataField="ReferralName" HeaderText="Referral Name" SortExpression="ReferralName"

FilterControlWidth="100" ItemStyle-Width="100" />

</Columns>

<PagerStyle Mode="NextPrevAndNumeric" AlwaysVisible="True" Position="Top" HorizontalAlign="Right" />

</MasterTableView>

<FilterMenu EnableImageSprites="False">

</FilterMenu>

</telerik:RadGrid>

and here is my code

protected void Page_Load(object sender, EventArgs e)

{

try

{

if (IsPostBack == false)

{

BindReferralLookUp();

}

if (Page.IsCallback == false)

{

BindReferralLookUp();

}

catch (Exception ex)

{

ShowError(ex.Message);

}

protected void grdReferralSearch_PageIndexChanged(object sender, GridPageChangedEventArgs e)

{

try

{

grdReferralSearch.CurrentPageIndex = e.NewPageIndex;

BindReferralLookUp();

}

catch (Exception ex)

{

ShowError(ex.Message);

}

private void BindReferralLookUp()

{

try

{

grdReferralSearch.VirtualItemCount = 10000;

grdReferralSearch.DataSource = GetDataSource();

grdReferralSearch.DataBind();

}

catch (Exception ex)

{

throw ex;

}

private List<ReferralSearchLookUp> GetDataSource()

{

try

{

lblTotalFound.Text = string.Empty;

string referralName = string.Empty;

if (!string.IsNullOrEmpty(txtReferralName.Text.Trim()))

{

referralName = txtReferralName.Text.Trim();

}

int pageIndex = grdReferralSearch.CurrentPageIndex + 1;

int pageSize = grdReferralSearch.PageSize;

int startIndex = (pageIndex - 1) * pageSize + 1;

int endIndex = (pageIndex * pageSize);

var data = ReferralsData.ReferralSearch(referralName, startIndex, endIndex);

return data;

}

catch (Exception ex)

{

throw ex;

}

Can anybody help me?

Thanks,

Grid

answered on 25 Jun 2015

1 answer

136 views

Disable enter key in Radtextbox with multi line

Hi

I have a RadGrid with batch edit mode and in cell edit mode, i have radtextbox with multiline enable. I want enter should work as a next line in radtextbox with multiline but when i hit enter, it close edit mode.

Grid

answered on 25 Jun 2015