or
<DataBindings> <telerik:RadTreeNodeBinding CheckedField="isChecked" Expanded="True" CheckableField="isSelectable" /> </DataBindings><telerik:RadDropDownList ID="MarketDropDownList" runat="server" DefaultMessage="--Select Market--" Width="200px" DataSourceID="ddlDataSource" DataTextField="MarketName" DataValueField="MarketID" AutoPostBack="true" OnSelectedIndexChanged="MarketDropDownList_SelectedIndexChanged"></telerik:RadDropDownList><telerik:RadGrid ID="radProductsGrid" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" GridLines="None" OnNeedDataSource="radProductsGrid_NeedDataSource" OnSortCommand="radProductsGrid_SortCommand" PageSize="100" CellSpacing="0"> <MasterTableView AllowMultiColumnSorting="false" AllowNaturalSort="false" AllowSorting="true" AutoGenerateColumns="false" Width="100%"> <CommandItemTemplate> <telerik:RadComboBox ID="RadComboBox1" DataTextField="ProductID" DataValueField="ProductID" runat="server"> </telerik:RadComboBox> </CommandItemTemplate> <Columns> <telerik:GridTemplateColumn AllowFiltering="true" HeaderText="Product in Market" ReadOnly="true" UniqueName="TemplateColumnCheckBox"> <HeaderTemplate> <asp:CheckBox ID="selectAllCheckboxes" runat="server" onClick="javascript:SelectDeselectAllCheckboxes(this);" /> </HeaderTemplate> <ItemTemplate> <asp:CheckBox ID="ProductInMarketCheckBox" runat="server" /> <asp:HiddenField runat="server" ID="ProductID" Value="ProductID" /> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn AllowFiltering="true" DataField="ItemNumber" HeaderText="Item Number" ReadOnly="true" SortExpression="ItemNumber" UniqueName="ItemNumber"> </telerik:GridBoundColumn> <telerik:GridBoundColumn AllowFiltering="true" DataField="ProductName" HeaderText="Product Name" ReadOnly="true" SortExpression="ProductName" UniqueName="ProductName"> </telerik:GridBoundColumn> <telerik:GridBoundColumn AllowFiltering="true" DataField="CategoryName" HeaderText="Category Name" ReadOnly="true" SortExpression="CategoryName" UniqueName="CategoryName"> </telerik:GridBoundColumn> </Columns> </MasterTableView></telerik:RadGrid> <asp:Button ID="btnAddProductToMarket" runat="server" border="0" Text="Save" ToolTip="Select Checkbox and Add Product to Market" OnClick="btnAddProductToMarket_Click" />protected void btnAddProductToMarket_Click(object sender, EventArgs e) { int[] myArray = new int[0]; try { GridCommandItem cmdItem = (GridCommandItem)radProductsGrid.MasterTableView.GetItems(GridItemType.CommandItem)[0]; RadComboBox combo = (RadComboBox)cmdItem.FindControl("RadComboBox1"); string strtxt = combo.Text; foreach (GridDataItem items in radProductsGrid.Items) { if (((CheckBox)items["TemplateColumnCheckBox"].FindControl("ProductInMarketCheckBox")).Checked) { HiddenField ProductID = null; ProductID = (HiddenField)items.FindControl("ProductID"); Array.Resize(ref myArray, myArray.Length + 1); myArray[myArray.Length - 1] = new int(); myArray[myArray.Length - 1] = int.Parse(ProductID.Value); //update query String ConnString = ConfigurationManager.ConnectionStrings["DBConnectingString"].ConnectionString; SqlConnection conn = new SqlConnection(ConnString); String query = @"UPDATE vPanel_MarketMappings SET ProductID = @ProductID, MarketID = @MarketID"; using (SqlCommand cmd = new SqlCommand(query,conn)) { cmd.Parameters.AddWithValue("@ProductID", ProductID); cmd.Parameters.AddWithValue("@MarketID", (CheckBox)items.FindControl("ProductInMarketCheckBox")); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } } } } catch ( Exception ex ) { LogException( Logging.PageType.ProductManage, Logging.MessageType.Exception, ex.ToString() ); UIUtils.ShowMessageToUser( "OnErrorMesg", this.Page ); } }<telerik:GridBoundColumn DataField="ShipName" HeaderText="ShipName" UniqueName="ShipName"> <ColumnValidationSettings EnableRequiredFieldValidation="true" EnableModelErrorMessageValidation="true"> <RequiredFieldValidator ForeColor="Red" ErrorMessage="This field is required"></RequiredFieldValidator> <ModelErrorMessage BackColor="Red" /> </ColumnValidationSettings> </telerik:GridBoundColumn>
Hi:
I am trying to emulate a given Excel pivot table with the RadPivotGrid control. This pivot table has a calculated field used on the ‘∑ Values’ section with a ‘SUM’ aggregate function. I haven’t found a way to correctly set the PivotGridAggregateField tag. The formula for the calculated field is to divide other two fields, ex. field1/field2. What happens is that for each row Excel do: sum(field1) / sum(field2).
I am using ASP.NET 4.5, Windows 8, Internet Explorer 10.0.9200.16721, Telerik v.2013.2.717.45, C#.
The provided help will be appreciated.
Thanks!
Jose
function hello() {if(confirm("hello"))alert("yes");elsealert("no");}function hello(){ showconfirm(); if (test) { alert("yes");//Here I might use some local variables } else alert("Cancelled");//Here I might use some local variables } function showconfirm() { radconfirm("Hello", confirmCallbackFunction); } function confirmCallbackFunction(arg) { test = arg; }<param name="Movie" value="/admin/static/qa3/usermedia/FrogLifeCycle.swf"/> <param name="play" value="true"/> <param name="quality" value="high"/> <param name="wmode" value="transparent"/> <param name="loop" value="false"/> <param name="menu" value="false"/><embed src="/usermedia/FrogLifeCycle.swf" originalAttribute="src" originalPath="/usermedia/FrogLifeCycle.swf" originalAttribute="src" originalPath="/usermedia/FrogLifeCycle.swf" width="150" height="150" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" quality="high" wmode="transparent" loop="false" menu="false"></embed></OBJECT>

| protected void Grid_ExcelMLExportRowCreated ( object source, Telerik.Web.UI.GridExcelBuilder.GridExportExcelMLRowCreatedArgs e ) |
| { |
| if ( e.RowType == GridExportExcelMLRowType.HeaderRow ) |
| { |
| RowElement myNewRow = new RowElement(); |
| CellElement myNewCell = new CellElement(); |
| myNewCell.StyleValue = "myNewStyle"; |
| myNewCell.MergeAcross = e.Row.Cells.Count - 1; |
| //now call the hypothetical property which doesn't seem to exist... |
| myNewCell.WrapText = true; |
| //etc... |
| } |
| } |