Questions on UI for ASP.NET AJAX Forum

1 answer

765 views

What is qsf?

I see these tags from time to time. <qsf:whatever... but when I google Telerik qsf I don't get anything that explains what it stands for or why I would use it. So what's the deal?

General Discussions

answered on 21 Oct 2016

1 answer

297 views

Using Telerik's control to Edit MS Word File Online

Hi,

Please let me know can I use Talarik's control to edit MS Word file online? The one I tried with online demo at: https://demos.telerik.com/aspnet-ajax/editor/examples/ms-word-like-experience/defaultcs.aspx disturbed the format of MS Word file and also remove the forms fields.

I want my users to edit MS Word file containing Form Fields and save them back. Is it possible with Telerik in Asp.Net ?

General Discussions

answered on 21 Oct 2016

2 answers

176 views

Add a Link in Cell Template

Hi,

I have search everywhere.

Documentation( Really poor documentation on Pivot ) , Knowledge Base ( Last post 2015, the second last 2012 ) , Forum well ..

Is it possible to add a "Real link" in the cell of a PivotGrid.
By real , I mean base on data that are in the result set but are not diplayed. Things like id, number that are never displayed to Customer.

I would like to show some more information based on fields that are in the result set but are not diplayed.
Its to mutch information for a little tooltips.

I need to create a link with "~/Somewhere/MyDetailPage.aspx?P=HiddenRowField&Filter=ColumnField"

As its seems to be impossible to get multiple field value into a cell template.
If I add a button in the cell template. Will I be able to retrieve Row/Column Field Value Of the clicked Button ?

PivotGrid

answered on 21 Oct 2016

1 answer

400 views

How to capture the value from a dropdown list from InsertItemTemplate in a GridTemplateColumn?

I have a grid control with a GridTemplateColumn that contains an ItemTemplate and an InsertItemTemplate. The InsertItemTemplate contains a dropdown list. The problem is that I get a null reference exception when I try to insert a new record. I know that the issue lies in the code behind where I am using the following line:

new_doc_stat_cmd.Parameters.AddWithValue("@docStat", rg_doc_stats.MasterTableView.FindControl("docStatDdlInsert"));

When I replace the above line with the one below, the insert command is executed successfully:

new_doc_stat_cmd.Parameters.AddWithValue("@docStat", 4);

Here is the code for the grid:

<telerik:RadGrid

ID="rg_doc_stats"

runat="server"

DataSourceID="sdc_doc_stats"

AllowSorting="True"

Skin="Office2010Blue"

CellSpacing="-1"

GridLines="Both"

OnInsertCommand="rg_doc_stats_InsertCommand">

<ClientSettings AllowColumnsReorder="True" ReorderColumnsOnClient="True"></ClientSettings>

<MasterTableView DataSourceID="sdc_doc_stats" AutoGenerateColumns="False" DataKeyNames="docStatIdPk" CommandItemDisplay="Top">

<Columns>

<telerik:GridBoundColumn DataField="docStatIdPk" ReadOnly="True" HeaderText="docStatIdPk" SortExpression="docStatIdPk" UniqueName="docStatIdPk" DataType="System.Int32" FilterControlAltText="Filter docStatIdPk column"></telerik:GridBoundColumn>

<telerik:GridTemplateColumn DataField="docStat" HeaderText="Status" SortExpression="docStat" UniqueName="docStat" DataType="System.Int32" FilterControlAltText="Filter docStat column">

<ItemTemplate>

<asp:Label runat="server" Text='<%# Bind("stat") %>' ID="statLbl"></asp:Label>

</ItemTemplate>

<InsertItemTemplate>

<asp:DropDownList ID="docStatDdlInsert" runat="server"

SelectedValue='<%# Bind("docStat") %>' DataSourceID="sdc_stats" DataTextField="stat" DataValueField="statIdPk" AppendDataBoundItems="true"><

asp:ListItem Value="">--Please Select--</asp:ListItem></asp:DropDownList>

</InsertItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="docStatDt" HeaderText="Status Date" SortExpression="docStatDt" UniqueName="docStatDt" FilterControlAltText="Filter docStatDt column" DataType="System.DateTime" ReadOnly="true"></telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="docStatSetBy" HeaderText="Status Set By" SortExpression="docStatSetBy" UniqueName="docStatSetBy" FilterControlAltText="Filter docStatSetBy column" ReadOnly="true"></telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="docIdFk" HeaderText="docIdFk" SortExpression="docIdFk" UniqueName="docIdFk" DataType="System.Int32" FilterControlAltText="Filter docIdFk column" ReadOnly="true"></telerik:GridBoundColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

</telerik:RadPageView>

Here are the InsertParameters from the SqlDataSource:

<InsertParameters>

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

<asp:Parameter Name="docStatDt" Type="DateTime"></asp:Parameter>

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

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

</InsertParameters>

Here is the InsertCommand from the SqlDataSource:

InsertCommand=

"INSERT INTO [docStats] ([docStat], [docStatDt], [docStatSetBy], [docIdFk]) VALUES (@docStat, @docStatDt, @docStatSetBy, @docIdFk)"

Here is the InsertCommand from the code behind:

protected void rg_doc_stats_InsertCommand(object sender, GridCommandEventArgs e)

{

SqlConnection drap_cnxn = new SqlConnection("Server=Mine\\SQLEXPRESS;Initial Catalog=drap;Integrated Security=True;");

{

SqlCommand new_doc_stat_cmd = new SqlCommand(

"Insert Into docStats(docStat, docStatDt, docStatSetBy, docIdFk) Values(LTRIM(RTRIM(@docStat)), LTRIM(RTRIM(@docStatDt)), LTRIM(RTRIM(@docStatSetBy)), LTRIM(RTRIM(@docIdFk)))"

, drap_cnxn);

new_doc_stat_cmd.Parameters.AddWithValue("@docStat", rg_doc_stats.MasterTableView.FindControl("docStatDdlInsert"));

new_doc_stat_cmd.Parameters.AddWithValue("@docStatDt", DateTime.Now.ToString());

new_doc_stat_cmd.Parameters.AddWithValue("@docStatSetBy", HttpContext.Current.User.Identity.Name);

new_doc_stat_cmd.Parameters.AddWithValue("@docIdFk", hdn_doc_id.Value);

drap_cnxn.Open();

new_doc_stat_cmd.ExecuteNonQuery();

drap_cnxn.Close();

if (IsPostBack)

{

rg_ven_docs.DataBind();

rg_doc_stats.DataBind();

}

Thank you,

J

Grid

answered on 21 Oct 2016

1 answer

122 views

Two grids on same page using one grid "excel like filter"

Is it possible to have two grids on the same page that are synced to use the first gids header menus? I am trying to use the "excel like filtering" but I am having issues with refreshing both grids from one header.

Grid

answered on 21 Oct 2016

1 answer

99 views

Radgrid inside editform template makes command item display shrink

Hi,

I have a RadGrid2 inside Radgrid1 Edit form Template. When RadGrid1 is in edit mode, the command item row shrinks. I checked my css and that's not the problem. Has anyone ever dealt with this before?

Thanks

General Discussions

answered on 21 Oct 2016

11 answers

1.1K+ views

Unrecognized Tag Prefix

Following a crash of Visual Studio I'm experiencing an issue where all of my Telerik tags on my aspx pages have blue underlines. Mousing over the underlined tags reveals the following error message "Unrecognized tag prefix or device filter 'telerik'". I've also lost Telerik intellisense. Does anyone know what the solution is? I've tried removing and re-adding all of the Telerik references and bin files. This did not fix the problem.

Note, prior to Visual Studio crashing I had made only a few minor text edits to the project...nothing that major that I would expect could have caused these problems. I'm using VS 2010.

General Discussions

answered on 21 Oct 2016

14 answers

846 views

OLAP Connection not showing any data from cube

Hello,
I am connecting to my SSAS server but I am no showing any data when the page loads, no fields in the Configuration Panel as well. I know my connection string is correct because we currently use it with an OWC control we hope to replace with the PivotGrid, and I can also connect through Excel. I have tried connection both through the HTML markup as well as the code behind:

<OlapSettings ProviderType="Adomd">

<AdomdConnectionSettings

Cube="Leads"

DataBase="DBName"

ConnectionString="Provider=MSOLAP.5;Data Source=ServerName;User ID=webuser;Initial Catalog=DBName;" >

</AdomdConnectionSettings>

</OlapSettings>

I have not defined any columns as the examples I have seen on your site have not shown that they need to be predefined, which would defeat the purpose of the control.
I have also tried in the code behind:

rpg.OlapSettings.ProviderType = Telerik.Web.UI.PivotGridOlapProviderType.Adomd

rpg.OlapSettings.AdomdConnectionSettings.Cube = "Leads"

rpg.OlapSettings.AdomdConnectionSettings.DataBase = "DBName"

rpg.OlapSettings.AdomdConnectionSettings.ConnectionString = "Provider=MSOLAP.5;Data Source=ServerName;User ID=XXX;Initial Catalog=DBName;"

Is there is something I am missing or I am doing wrong? I have been through the threads here and checked numerous examples, but just can't seem to get it.
Any help would be great. I am getting frustrated

Thanks,
Jim

PivotGrid

answered on 20 Oct 2016

2 answers

206 views

Change ShowExportToExcelButton Size?

Hello, I've been using the export to excel settings in the rad grid, which works great, but many of the users that work with my system have been complaining on the button size since it seems to be pretty small, I tried to change it myself but didn't seem to find a property to do that, I've only been able to change the command items bar but the button stays the same size.

Is there any way to change the button size and place for the "CommandItemSettings ShowExportToExcelButton"?

I leave my code below

Thanks a lot!

Grid

answered on 20 Oct 2016

3 answers

726 views

Refreshing a grid in a tab from a different tab

Hi,

I have a multipage control that has 5 tabs. On the 2nd tab Ihave a grid which displays order details and on the 5th tab I have another grid which allows the selection of a product to be inserted into the grid on tab #2. When the product row is double-clicked a RadWindow is popped into which the full order details can be added. On completing the data entry a button then inserts the added data into the datatable which is the source of the grid on tab #2 and executes a "CloseAndRebind" script in the window code-behind e.g.:

protected void btnInsertClicked(object sender, EventArgs e)

{

DataSet ds = Session["OrdersTables"] as DataSet;

DataRow nr = ds.Tables["LineItems"].NewRow();

nr["LineItem_Id"] = GetNewItemId(23);

...

.... data inserted into DataRow

...

ds.Tables["LineItems"].Rows.Add(nr);

// update the session

Session.Remove("OrdersTables");

Session.Add("OrdersTables", ds);

ClientScript.RegisterStartupScript(Page.GetType(), "mykey", "CloseAndRebind();", true);

}

This script comes from one of your examples :

function CloseAndRebind(args) {

GetRadWindow().BrowserWindow.refreshGrid(args);

GetRadWindow().close();

}

which bubbles back to the parent page and triggers this AJAX request to execute a ReBind on the grid in tab #2

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" OnAjaxRequest="RadAjaxManager1_AjaxRequest" DefaultLoadingPanelID="mainLoadingPanel">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="RadAjaxManager1">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadGrid2" LoadingPanelID="grid2LoadingPanel" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

The AJAX request triggers the NeedDataSource event of the grid on tab #2 to re-load the DataSource however on switching to tab #2 the grid was still showing the old data. At this point clicking the refresh option top-right of the grid the NeedDataSource event is again triggered and this time the new line is displayed.

I'd like the AJAX request to switch to tab #2 and then issue the refresh so coded:

protected void RadAjaxManager1_AjaxRequest(object sender, AjaxRequestEventArgs e)

{

if (e.Argument == "Rebind")

{

// swap back to the order lines tab then refresh it

RadTab rt = RadTabStrip1.Tabs.FindTabByText("Order Items");

rt.Selected = true;

RadGrid1.MasterTableView.SortExpressions.Clear();

RadGrid1.MasterTableView.GroupByExpressions.Clear();

RadGrid1.Rebind();

}