Questions on UI for ASP.NET AJAX Forum

1 answer

180 views

In my page i have placed one textbox, one label,three buttons.
When i click on one image button the radtooltip gets appear. On that i have shown the tooltip text in label and one edit button.
To edit the text inside the tooltip, i have functionality to click on the edit button. And with this edit click i am replacing label with text box and edit buttons with the save and cancel button.

My problem is whenever i click edit button postback occurs and it removes the tooltip from the page and then when i click again on the image button for tooltip i see only text box and two button of save and cancel.

My requirement is like, if i click on edit button i don't want a page to get refresh. And as soon as i click on edit button the textbox will be appeared and save and cancel button.

Can any one help me? It would be great if you can provide any sample application for this.

ToolTip

answered on 17 Jul 2009

4 answers

241 views

[Solved] Scrolling Problem: Auto-Generated Columns

Hello, this is my 1st post as a member (just wanted to say how awesome Telerik controls are)

Ok, my problem is that i have the columns generated at runtime in my grid, and i want the columns to overun so it scrolls like in the example http://demos.telerik.com/aspnet-ajax/grid/examples/client/scrolling/defaultcs.aspx

The problem is that the columns are resising when more get added to fit the space they are in, and not just over flowing to allow horizontal scrolling.

You can find a preview image here:
http://x-volt.com/pics/telerik_grid-resize_problem.jpg

My code is in a Rad MultiPage tab window, i dont know if thats playing up with it, but i was wondering if anyone can help? The display code is:

<telerik:RadMultiPage ID="MP" runat="server" CssClass="tabMultiPage" meta:resourcekey="MPResource1" SelectedIndex="0" >

<telerik:RadPageView ID="T1" runat="server" height="420px" width="97%" Selected="True" meta:resourcekey="T1Resource1">

<asp:label id="lblNoGraphData" runat="server" cssclass="Warning" Text="There is no data to view for these dates." meta:resourcekey="lblNoGraphDataResource1" />

</div>

<c1webchart:c1webchart id="WebChart" Height="420px" Width="960px" runat="server" imagetransfermethod="File" meta:resourcekey="WebChartResource1">

</c1webchart:c1webchart>

</telerik:RadPageView>

<telerik:RadPageView ID="T2" runat="server" height="420px" width="100%" meta:resourcekey="T2Resource1" >

<asp:label id="lblNoData" runat="server" cssclass="DataGridInfoText" Text="There is no data to view for these dates." meta:resourcekey="lblNoDataResource1" />

<!- -----------------------TELERIK GRID START----------------------- -->

<telerik:RadGrid ID="uxTelerikGrid" runat="server" Skin="Office2007" AutoGenerateColumns="true">

</ClientSettings>

</ExportSettings>

</MasterTableView>

</telerik:RadGrid>

</telerik:RadPageView>

</telerik:RadMultiPage>

Thanks for your help,

Simon

Grid

answered on 17 Jul 2009

1 answer

106 views

HELP: Problem with extracting data in row selection from a RadGrid with an itemtemplate (Client Side)

Hi,

what I'am trying to do is to simply extract data from the selected row in the grid on the client side. I've gone through most of the API material available and according to it everything should work.... But it does not...

My suspicion is that when using an item-template in the RadGrid the column data in the selected row is not available, is this correct? If so, how should I get it in Javascript then? Or have I completely missed something?

    
            <telerik:RadScriptBlock id="RadScriptBlock1" runat="server"> 
        
              <script language="javascript" type="text/javascript"> 
        
                  var grid; 
        
                  function RowSelected(rowObject) { 
        
                      //alert("ROWSEL"); 
        
                      alert(rowObject); 
        
                      var selRow = this.GetCellByColumnUniqueName(rowObject, "Id"); 
        
                      alert(rowObject.KeyValues["Id"]); 
        
                      //here selRow.innerHTML will hold the value for the selected row contact name 
        
                  } 
        
                  function GridCreated() { 
        
                      grid = this; 
        
                  } 
        
            </script> 
        
            </telerik:RadScriptBlock> 
        
            <input id="media_id" type="hidden" /> 
        
            <telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True" GridLines="None" 
        
                OnSelectedIndexChanged="RadGrid1_SelectedIndexChanged" AutoGenerateColumns="False" 
        
                HorizontalAlign="Left" Width="380px"> 
        
                <ClientSettings> 
        
                    <Selecting AllowRowSelect="True" /> 
        
                    <ClientEvents OnGridCreated="GridCreated" OnRowSelected="RowSelected"></ClientEvents> 
        
                    <Scrolling AllowScroll="True" UseStaticHeaders="True"></Scrolling> 
        
                </ClientSettings> 
        
                <PagerStyle Mode="NumericPages" /> 
        
                <MasterTableView TableLayout="Fixed"> 
        
                    <ItemTemplate> 
        
                        <asp:Image ID="Image1" Style="float: left;" Width="40px" Height="40px" ImageUrl='<%# Eval("ThumbnailURL") %>' 
        
                            runat="server" AlternateText="" /> 
        
                        <span>&nbsp <b>Title:</b></span> 
        
                        <%# Eval("Title")%><br /> 
        
                        <span>&nbsp <b>Type:</b></span> 
        
                        <%# Eval("Type")%> 
        
                        <br /> 
        
                        <span>&nbsp <b>Description:</b></span> 
        
                        <%# Eval("Description")%> 
        
                    </ItemTemplate> 
        
                    <Columns> 
        
                        <telerik:GridBoundColumn DataField="Title" HeaderText="Title" UniqueName="column1" 
        
                            AutoPostBackOnFilter="True" FilterControlWidth="90px"> 
        
                        </telerik:GridBoundColumn> 
        
                        <telerik:GridBoundColumn DataField="Type" HeaderText="Type" UniqueName="column" AutoPostBackOnFilter="True" 
        
                            FilterControlWidth="80px" Visible="true"> 
        
                        </telerik:GridBoundColumn> 
        
                        <telerik:GridBoundColumn DataField="Description" HeaderText="Description" UniqueName="column2" 
        
                            AutoPostBackOnFilter="True" FilterControlWidth="90px"> 
        
                        </telerik:GridBoundColumn> 
        
                        <telerik:GridBoundColumn DataField="Id" UniqueName="Id"  
        
                            AutoPostBackOnFilter="True" Display="False" Visible="False"> 
        
                        </telerik:GridBoundColumn> 
        
                    </Columns> 
        
                </MasterTableView> 
        
            </telerik:RadGrid>

Grid

answered on 17 Jul 2009

1 answer

121 views

Edit RadToolTip Text

I have requirement where in i want Radtooltip text to be edited. If i double click the Radtooltip, can i get the radtooltip control in some editable state so that i can edit the text inside radtooltip and once click on the the tooltip, radtooltip text gets saved in database.

Is there any feature in radtooltip to make it editable when it shows on the screen?

ToolTip

answered on 17 Jul 2009

1 answer

75 views

[3:01:59 p.m.] Lin Li: RadScheduler cant get start time correct when switch between 'Day' and 'Week'

Hi, we use RadToolBar to create our own RadScheduler header, Scheduler set show 24hr and start time is 8am, if we scroll down like 2pm and click 'week', it should start from 8am as well, but we get start from 2pm, do you have any solution for that?
Thanks

Scheduler

answered on 17 Jul 2009

1 answer

114 views

3 level hierarchy via client api performs poorly - any fixes or tips

Hi, I followed the guidance provided by Telerik Support in this blog, for a 2 level deep client api driven hierarchical grid, and I modified the code to implement a 3rd level hierarchy following the same pattern.

The blog entry has a zip file you can download for the basic pattern. I created a page called 3levels.aspx which extends the concept to add a 3rd level, and I modified the web service and the lSQL entities to map out a 3rd level of data.

If you load default.aspx from the project you will see the page come up and render very quickly, performing as expected

If you load my 3levels.aspx (see below code) you will see a 20-30 second delay while rendering churns, before the browser responds and renders the markup.

These pages request the data after the page has rendered, so the rendering churn is what's killing the 3rd level grid approach.

Okay you grid masters! Please review and let me know what I can do to work past this issue!

I appreciate any insights!

Thanks and regards!
Scott Burkhalter
SR. SDE Microsoft OEM IT
Dev Lead, Grid Replacement Project

3Levels.aspx - new file add to website

    
            <%@ Page EnableViewState="false" Language="C#" %> 
        
            <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" 
        
                TagPrefix="act" %> 
        
            <%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %> 
        
            <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
        
            <html xmlns="http://www.w3.org/1999/xhtml">  
        
            <head runat="server">  
        
                <title>Three level hierarchy</title> 
        
                <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">  
        
                    <script type="text/javascript" src="Script1.js"></script> 
        
                    <script type="text/javascript">  
        
                        function pageLoad(sender, args) {  
        
                            tableView = $find("<%= RadGrid1.ClientID %>").get_masterTableView();  
        
                            commandName = "Load" 
        
                            WebService.GetCustomers(0, tableView.get_pageSize(),  
        
                                tableView.get_sortExpressions().toString(), tableView.get_filterExpressions().toDynamicLinq(),  
        
                                    updateGrid);  
        
                        }  
        
                    </script> 
        
                </telerik:RadCodeBlock> 
        
            </head> 
        
            <body> 
        
                <form id="form1" runat="server">  
        
                <div> 
        
                    <telerik:RadScriptManager ID="RadScriptManager1" runat="server">  
        
                        <Services> 
        
                            <asp:ServiceReference Path="~/WebService.asmx" /> 
        
                        </Services> 
        
                    </telerik:RadScriptManager> 
        
                    <telerik:RadStyleSheetManager ID="RadStyleSheetManager1" runat="server" /> 
        
                    <telerik:RadGrid ID="RadGrid1" AllowFilteringByColumn="true" Skin="Telerik" runat="server" 
        
                        GridLines="None" AllowPaging="true" AllowSorting="true" PageSize="10">  
        
                        <ClientSettings> 
        
                            <ClientEvents OnCommand="RadGrid1_Command" OnHierarchyExpanding="RadGrid1_HierarchyExpanding" /> 
        
                        </ClientSettings> 
        
                        <MasterTableView HierarchyLoadMode="Client" ClientDataKeyNames="CustomerID">  
        
                            <Columns> 
        
                                <telerik:GridBoundColumn SortExpression="CustomerID" DataField="CustomerID" HeaderText="CustomerID" /> 
        
                                <telerik:GridBoundColumn SortExpression="CompanyName" DataField="CompanyName" HeaderText="CompanyName" /> 
        
                                <telerik:GridBoundColumn SortExpression="ContactName" DataField="ContactName" HeaderText="ContactName" /> 
        
                                <telerik:GridBoundColumn SortExpression="ContactTitle" DataField="ContactTitle" HeaderText="ContactTitle" /> 
        
                                <telerik:GridBoundColumn SortExpression="Country" DataField="Country" HeaderText="Country" /> 
        
                                <telerik:GridBoundColumn SortExpression="City" DataField="City" HeaderText="City" /> 
        
                            </Columns> 
        
                            <NestedViewTemplate> 
        
                                <telerik:RadGrid ID="RadGrid2" AllowFilteringByColumn="true" Skin="Telerik" runat="server" 
        
                                    GridLines="None" AllowPaging="true" AllowSorting="true" PageSize="5">  
        
                                    <ClientSettings> 
        
                                        <ClientEvents OnCommand="RadGrid2_Command" OnHierarchyExpanding="RadGrid2_HierarchyExpanding" /> 
        
                                    </ClientSettings> 
        
                                    <MasterTableView HierarchyLoadMode="Client" ClientDataKeyNames="OrderID">  
        
                                        <Columns> 
        
                                            <telerik:GridBoundColumn SortExpression="OrderID" DataField="OrderID" HeaderText="OrderID" 
        
                                                DataType="System.Int32" /> 
        
                                            <telerik:GridBoundColumn SortExpression="OrderDate" DataField="OrderDate" HeaderText="OrderDate" 
        
                                                DataType="System.DateTime" DataFormatString="{0:MM/dd/yyyy}" /> 
        
                                            <telerik:GridBoundColumn SortExpression="ShipName" DataField="ShipName" HeaderText="ShipName" /> 
        
                                            <telerik:GridBoundColumn SortExpression="ShipCity" DataField="ShipCity" HeaderText="ShipCity" /> 
        
                                            <telerik:GridBoundColumn SortExpression="ShipCountry" DataField="ShipCountry" HeaderText="ShipCountry" /> 
        
                                        </Columns> 
        
                                        <NestedViewTemplate> 
        
                                            <telerik:RadGrid ID="RadGrid3" AllowFilteringByColumn="true" Skin="Telerik" runat="server" 
        
                                                GridLines="None" AllowPaging="true" AllowSorting="true" PageSize="3">  
        
                                                <ClientSettings> 
        
                                                    <ClientEvents OnCommand="RadGrid3_Command" /> 
        
                                                </ClientSettings> 
        
                                                <MasterTableView HierarchyLoadMode="Client" ClientDataKeyNames="ProductID">  
        
                                                    <Columns> 
        
                                                        <telerik:GridBoundColumn SortExpression="ProductID" DataField="ProductID" HeaderText="ProductID" 
        
                                                            DataType="System.Int32" /> 
        
                                                        <telerik:GridBoundColumn SortExpression="ProductName" DataField="ProductName" HeaderText="ProductName" /> 
        
                                                        <telerik:GridBoundColumn SortExpression="QuantityPerUnit" DataField="QuantityPerUnit" HeaderText="Quantity PerUnit" DataType="System.String" /> 
        
                                                        <telerik:GridBoundColumn SortExpression="UnitsOnOrder" DataField="UnitsOnOrder" HeaderText="Units On Order" DataType="System.Int16" /> 
        
                                                    </Columns> 
        
                                                </MasterTableView> 
        
                                                <PagerStyle AlwaysVisible="true" /> 
        
                                            </telerik:RadGrid> 
        
                                        </NestedViewTemplate> 
        
                                    </MasterTableView> 
        
                                    <PagerStyle AlwaysVisible="true" /> 
        
                                </telerik:RadGrid> 
        
                            </NestedViewTemplate> 
        
                        </MasterTableView> 
        
                        <PagerStyle AlwaysVisible="true" /> 
        
                    </telerik:RadGrid> 
        
                </div> 
        
                </form> 
        
            </body> 
        
            </html>

Referenced js file Script1.js - modified to handle 3rd level hierarchy data requests - replaces file in sample site

    
            var commandName = "";  
        
            var tableView = null;  
        
            var ordersView = null;  
        
            var productsView = null;  
        
            var ordersCommandName = "";  
        
            var productsCommandName = "";  
        
            function RadGrid1_Command(sender, args) {  
        
                args.set_cancel(true);  
        
                commandName = args.get_commandName();  
        
                WebService.GetCustomers(tableView.get_currentPageIndex() * tableView.get_pageSize(), tableView.get_pageSize(),  
        
                                tableView.get_sortExpressions().toString(), tableView.get_filterExpressions().toDynamicLinq(),  
        
                                    updateGrid);  
        
            }  
        
            function updateGrid(result) {  
        
                tableView.set_dataSource(result);  
        
                tableView.dataBind();  
        
                var dataItems = tableView.get_dataItems();  
        
                if (commandName == "Filter" || commandName == "Load") {  
        
                    WebService.GetCustomersCount(updateVirtualItemCount);  
        
                }  
        
            }  
        
            function updateVirtualItemCount(result) {  
        
                tableView.set_virtualItemCount(result);  
        
            }  
        
            function RadGrid1_HierarchyExpanding(sender, args) {  
        
                var customerID = args.getDataKeyValue("CustomerID");  
        
                var nestedViewItem = args.get_nestedViewItem();  
        
                ordersView = $telerik.findControl(nestedViewItem, "RadGrid2").get_masterTableView();  
        
                ordersCommandName = "Load";  
        
                WebService.GetOrdersByCustomerID(customerID, ordersView.get_currentPageIndex() * ordersView.get_pageSize(), ordersView.get_pageSize(),  
        
                                ordersView.get_sortExpressions().toString(), ordersView.get_filterExpressions().toDynamicLinq(),  
        
                                    updateOrdersGrid, updateFailed);  
        
            }  
        
            function updateOrdersGrid(result) {  
        
                ordersView.set_dataSource(result);  
        
                ordersView.dataBind();  
        
                if (ordersCommandName == "Filter" || ordersCommandName == "Load") {  
        
                    WebService.GetOrdersByCustomerIDCount(updateOrdersVirtualItemCount);  
        
                }  
        
            }  
        
            function updateFailed(ex) {  
        
                alert(ex.get_message());  
        
            }  
        
            function updateOrdersVirtualItemCount(result) {  
        
                ordersView.set_virtualItemCount(result);  
        
            }  
        
            function RadGrid2_Command(sender, args) {  
        
                ordersView = sender.get_masterTableView();  
        
                var nestedViewItem = sender.get_element().parentNode.parentNode;  
        
                var parentGridDataItem = $find(Telerik.Web.UI.Grid.GetNodePreviousSiblingByTagName(nestedViewItem, "tr").id);  
        
                var customerID = parentGridDataItem.getDataKeyValue("CustomerID");  
        
                args.set_cancel(true);  
        
                ordersCommandName = args.get_commandName();  
        
                WebService.GetOrdersByCustomerID(customerID, ordersView.get_currentPageIndex() * ordersView.get_pageSize(), ordersView.get_pageSize(),  
        
                                ordersView.get_sortExpressions().toString(), ordersView.get_filterExpressions().toDynamicLinq(),  
        
                                    updateOrdersGrid, updateFailed);  
        
            }  
        
            function RadGrid2_HierarchyExpanding(sender, args) {  
        
                var orderID = args.getDataKeyValue("OrderID");  
        
                var nestedViewItem = args.get_nestedViewItem();  
        
                productsView = $telerik.findControl(nestedViewItem, "RadGrid3").get_masterTableView();  
        
                productsCommandName = "Load";  
        
                WebService.GetProductsByOrderID(orderID, productsView.get_currentPageIndex() * productsView.get_pageSize(), productsView.get_pageSize(),  
        
                                productsView.get_sortExpressions().toString(), productsView.get_filterExpressions().toDynamicLinq(),  
        
                                    updateEmployeesGrid, updateFailed);  
        
            }  
        
            function updateEmployeesGrid(result) {  
        
                productsView.set_dataSource(result);  
        
                productsView.dataBind();  
        
                if (productsCommandName == "Filter" || productsCommandName == "Load") {  
        
                    WebService.GetEmployeesByEmployeeIDCount(updateOrdersVirtualItemCount, updateFailed);  
        
                }  
        
            }  
        
            function updateOrdersVirtualItemCount(result) {  
        
                ordersView.set_virtualItemCount(result);  
        
            }  
        
            function RadGrid3_Command(sender, args) {  
        
                productsView = sender.get_masterTableView();  
        
                var nestedViewItem = sender.get_element().parentNode.parentNode;  
        
                var parentGridDataItem = $find(Telerik.Web.UI.Grid.GetNodePreviousSiblingByTagName(nestedViewItem, "tr").id);  
        
                var orderID = parentGridDataItem.getDataKeyValue("OrderID");  
        
                args.set_cancel(true);  
        
                productsCommandName = args.get_commandName();  
        
                WebService.GetProductsByOrderID(orderID, productsView.get_currentPageIndex() * productsView.get_pageSize(), productsView.get_pageSize(),  
        
                                productsView.get_sortExpressions().toString(), productsView.get_filterExpressions().toDynamicLinq(),  
        
                                    updateEmployeesGrid, updateFailed);  
        
            }

Modified webservice.asmx including code to obtain 3rd level data:

    
            <%@ WebService Language="C#" Class="WebService" %>  
        
            using System;  
        
            using System.Web;  
        
            using System.Web.Services;  
        
            using System.Web.Services.Protocols;  
        
            using System.Linq;  
        
            using System.Linq.Dynamic;  
        
            using System.Collections.Generic;  
        
            [WebService(Namespace = "http://tempuri.org/")]  
        
            [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]  
        
            // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.   
        
            [System.Web.Script.Services.ScriptService]  
        
            public class WebService : System.Web.Services.WebService  
        
            {  
        
                IQueryable<Customer> customers = new DataClassesDataContext().Customers.AsQueryable<Customer>();  
        
                IQueryable<Order> orders = new DataClassesDataContext().Orders.AsQueryable<Order>();  
        
                IQueryable<Order_Detail> order_details = new DataClassesDataContext().Order_Details.AsQueryable<Order_Detail>();  
        
                IQueryable<Product> products = new DataClassesDataContext().Products.AsQueryable<Product>();  
        
                [WebMethod(EnableSession = true)]  
        
                public List<Customer> GetCustomers(int startIndex, int maximumRows, string sortExpression, string filterExpression)  
        
                {  
        
                    if (!String.IsNullOrEmpty(filterExpression))  
        
                    {  
        
                        customers = customers.Where(filterExpression);  
        
                    }  
        
                    if (!String.IsNullOrEmpty(sortExpression))  
        
                    {  
        
                        customers = customers.OrderBy(sortExpression);  
        
                    }  
        
                    HttpContext.Current.Session["CustomersCount"] = customers.Count();  
        
                    return customers.Skip(startIndex).Take(maximumRows).ToList();  
        
                }  
        
                [WebMethod(EnableSession = true)]  
        
                public int GetCustomersCount()  
        
                {  
        
                    return (int)HttpContext.Current.Session["CustomersCount"];  
        
                }  
        
                [WebMethod(EnableSession = true)]  
        
                public List<Order> GetOrdersByCustomerID(string customerID, int startIndex, int maximumRows, string sortExpression, string filterExpression)  
        
                {  
        
                    if (!String.IsNullOrEmpty(filterExpression))  
        
                    {  
        
                        orders = orders.Where(String.Format(@"CustomerID == ""{0}"" AND {1}", customerID, filterExpression));  
        
                    }  
        
                    else 
        
                    {  
        
                        orders = orders.Where(c => c.CustomerID == customerID);  
        
                    }  
        
                    if (!String.IsNullOrEmpty(sortExpression))  
        
                    {  
        
                        orders = orders.OrderBy(sortExpression);  
        
                    }  
        
                    HttpContext.Current.Session["OrdersByCustomerCount"] = orders.Count();  
        
                    foreach (var o1 in orders)  
        
                        o1.Order_Details = null;  
        
                    return orders.Skip(startIndex).Take(maximumRows).ToList();  
        
                }  
        
                [WebMethod(EnableSession = true)]  
        
                public int GetOrdersByCustomerIDCount()  
        
                {  
        
                    return (int)HttpContext.Current.Session["OrdersByCustomerCount"];  
        
                }  
        
                [WebMethod(EnableSession = true)]  
        
                public List<ProductPOCO> GetProductsByOrderID(string orderID, int startIndex, int maximumRows, string sortExpression, string filterExpression)  
        
                {  
        
                    if (!String.IsNullOrEmpty(filterExpression))  
        
                    {  
        
                        orders = orders.Where(String.Format(@"OrderID == ""{0}"" AND {1}", orderID, filterExpression));  
        
                    }  
        
                    else 
        
                    {  
        
                        orders = orders.Where(o => o.OrderID == Int32.Parse(orderID));  
        
                    }  
        
                    if (!String.IsNullOrEmpty(sortExpression))  
        
                    {  
        
                        orders = orders.OrderBy(sortExpression);  
        
                    }  
        
                    HttpContext.Current.Session["ProductsByOrderIDCount"] = orders.FirstOrDefault().Products.Count();  
        
                    var q = from p in orders.FirstOrDefault().Products  
        
                            select new ProductPOCO  
        
                                {  
        
                                    ProductID = p.ProductID,  
        
                                    ProductName = p.ProductName,  
        
                                    QuantityPerUnit = p.QuantityPerUnit,  
        
                                    UnitsOnOrder = p.UnitsOnOrder  
        
                                };  
        
                    return q.Skip(startIndex).Take(maximumRows).ToList();  
        
                }  
        
                [WebMethod(EnableSession = true)]  
        
                public int GetEmployeesByEmployeeIDCount()  
        
                {  
        
                    return (int)HttpContext.Current.Session["ProductsByOrderIDCount"];  
        
                }  
        
                public class ProductPOCO  
        
                {  
        
                    public int ProductID { get; set; }  
        
                    public string ProductName { get; set; }  
        
                    public string QuantityPerUnit { get; set; }  
        
                    public short? UnitsOnOrder { get; set; }  
        
                }  
        
            }

ListSelector needed for many to many relationship between Orders and Products (put in App_Code) directory as ListSelector.cs

    
            using System;  
        
            using System.Collections.Generic;  
        
            using System.Linq;  
        
            using System.Text;  
        
            using System.Collections;  
        
            using System.ComponentModel;  
        
            namespace ListSelector  
        
            {  
        
                public class BindingListSelector<TSource, T> : ListSelector<TSource, T>, IBindingList  
        
                {  
        
                    public BindingListSelector(IBindingList source, Func<TSource, T> selector):base(source as IList<TSource>, selector)  
        
                    {  
        
                        sourceAsBindingList = source;  
        
                    }  
        
                    protected IBindingList sourceAsBindingList; 
        
                    #region IBindingList Members  
        
                    public void AddIndex(PropertyDescriptor property)  
        
                    {  
        
                        sourceAsBindingList.AddIndex(property);  
        
                    }  
        
                    public object AddNew()  
        
                    {  
        
                        return sourceAsBindingList.AddNew();  
        
                    }  
        
                    public bool AllowEdit  
        
                    {  
        
                        get { return sourceAsBindingList.AllowEdit; }  
        
                    }  
        
                    public bool AllowNew  
        
                    {  
        
                        get { return sourceAsBindingList.AllowNew; }  
        
                    }  
        
                    public bool AllowRemove  
        
                    {  
        
                        get { return sourceAsBindingList.AllowRemove; }  
        
                    }  
        
                    public void ApplySort(PropertyDescriptor property, ListSortDirection direction)  
        
                    {  
        
                        sourceAsBindingList.ApplySort(property, direction);  
        
                    }  
        
                    public int Find(PropertyDescriptor property, object key)  
        
                    {  
        
                        return sourceAsBindingList.Find(property, key);  
        
                    }  
        
                    public bool IsSorted  
        
                    {  
        
                        get { return sourceAsBindingList.IsSorted; }  
        
                    }  
        
                    public event ListChangedEventHandler ListChanged  
        
                    {  
        
                        add  
        
                        {  
        
                            sourceAsBindingList.ListChanged += value;  
        
                        }  
        
                        remove  
        
                        {  
        
                            sourceAsBindingList.ListChanged -= value;  
        
                        }  
        
                    }  
        
                    public void RemoveIndex(PropertyDescriptor property)  
        
                    {  
        
                        sourceAsBindingList.RemoveIndex(property);  
        
                    }  
        
                    public void RemoveSort()  
        
                    {  
        
                        sourceAsBindingList.RemoveSort();  
        
                    }  
        
                    public ListSortDirection SortDirection  
        
                    {  
        
                        get { return sourceAsBindingList.SortDirection; }  
        
                    }  
        
                    public PropertyDescriptor SortProperty  
        
                    {  
        
                        get { return sourceAsBindingList.SortProperty; }  
        
                    }  
        
                    public bool SupportsChangeNotification  
        
                    {  
        
                        get { return sourceAsBindingList.SupportsChangeNotification; }  
        
                    }  
        
                    public bool SupportsSearching  
        
                    {  
        
                        get { return sourceAsBindingList.SupportsSearching; }  
        
                    }  
        
                    public bool SupportsSorting  
        
                    {  
        
                        get { return sourceAsBindingList.SupportsSorting; }  
        
                    } 
        
                    #endregion  
        
                }  
        
                public static class ListSelectorExtensions  
        
                {  
        
                    public static ListSelector<TSource, T> AsListSelector<TSource, T>(this IList<TSource> source, Func<TSource, T> selector)  
        
                    {  
        
                        return new ListSelector<TSource, T>(source, selector);  
        
                    }  
        
                    public static BindingListSelector<TSource, T> AsListSelector<TSource, T>(this IBindingList source, Func<TSource, T> selector)  
        
                    {  
        
                        return new BindingListSelector<TSource, T>(source, selector);  
        
                    }  
        
                }  
        
                public class ListSelector<TSource, T> : IList<T>, IList  
        
                {  
        
                    public ListSelector(IList<TSource> source, Func<TSource, T> selector)  
        
                    {  
        
                        this.source = source;  
        
                        this.selector = selector;  
        
                        projection = source.Select(selector);  
        
                    }  
        
                    protected IList<TSource> source;  
        
                    protected Func<TSource, T> selector;  
        
                    protected IEnumerable<T> projection; 
        
                    #region IList<T> Members  
        
                    public int IndexOf(T item)  
        
                    {  
        
                        int i = 0;  
        
                        foreach (T t in projection)  
        
                        {  
        
                            if (t.Equals(item))  
        
                                return i;  
        
                            i++;  
        
                        }  
        
                        return -1;  
        
                    }  
        
                    public void Insert(int index, T item)  
        
                    {  
        
                        throw new Exception("The method or operation is not implemented.");  
        
                    }  
        
                    public void RemoveAt(int index)  
        
                    {  
        
                        throw new Exception("The method or operation is not implemented.");  
        
                    }  
        
                    public T this[int index]  
        
                    {  
        
                        get 
        
                        {  
        
                            return selector(source[index]);  
        
                        }  
        
                        set 
        
                        {  
        
                            throw new Exception("The method or operation is not implemented.");  
        
                        }  
        
                    } 
        
                    #endregion  
        
                    #region ICollection<T> Members  
        
                    public void Add(T item)  
        
                    {  
        
                        throw new Exception("The method or operation is not implemented.");  
        
                    }  
        
                    public void Clear()  
        
                    {  
        
                        throw new Exception("The method or operation is not implemented.");  
        
                    }  
        
                    public bool Contains(T item)  
        
                    {  
        
                        return projection.Contains(item);  
        
                    }  
        
                    public void CopyTo(T[] array, int arrayIndex)  
        
                    {  
        
                        //source.CopyTo(projection.ToArray(), arrayIndex);  
        
                    }  
        
                    public int Count  
        
                    {  
        
                        get { return source.Count; }  
        
                    }  
        
                    public bool IsReadOnly  
        
                    {  
        
                        get { return true; }  
        
                    }  
        
                    public bool Remove(T item)  
        
                    {  
        
                        throw new Exception("The method or operation is not implemented.");  
        
                    } 
        
                    #endregion  
        
                    #region IEnumerable<T> Members  
        
                    public IEnumerator<T> GetEnumerator()  
        
                    {  
        
                        return projection.GetEnumerator();  
        
                    } 
        
                    #endregion  
        
                    #region IEnumerable Members  
        
                    System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator()  
        
                    {  
        
                        return projection.GetEnumerator();  
        
                    } 
        
                    #endregion  
        
                    #region IList Members  
        
                    int IList.Add(object value)  
        
                    {  
        
                        throw new Exception("The method or operation is not implemented.");  
        
                    }  
        
                    void IList.Clear()  
        
                    {  
        
                        throw new Exception("The method or operation is not implemented.");  
        
                    }  
        
                    bool IList.Contains(object value)  
        
                    {  
        
                        return Contains((T) value);  
        
                    }  
        
                    int IList.IndexOf(object value)  
        
                    {  
        
                        return IndexOf((T) value);  
        
                    }  
        
                    void IList.Insert(int index, object value)  
        
                    {  
        
                        throw new Exception("The method or operation is not implemented.");  
        
                    }  
        
                    bool IList.IsFixedSize  
        
                    {  
        
                        get { return true; }  
        
                    }  
        
                    bool IList.IsReadOnly  
        
                    {  
        
                        get { return true; }  
        
                    }  
        
                    void IList.Remove(object value)  
        
                    {  
        
                        throw new Exception("The method or operation is not implemented.");  
        
                    }  
        
                    void IList.RemoveAt(int index)  
        
                    {  
        
                        throw new Exception("The method or operation is not implemented.");  
        
                    }  
        
                    object IList.this[int index]  
        
                    {  
        
                        get 
        
                        {  
        
                            return this[index];  
        
                        }  
        
                        set 
        
                        {  
        
                            throw new Exception("The method or operation is not implemented.");  
        
                        }  
        
                    } 
        
                    #endregion  
        
                    #region ICollection Members  
        
                    void ICollection.CopyTo(Array array, int index)  
        
                    {  
        
                        //CopyTo(array, index);  
        
                    }  
        
                    int ICollection.Count  
        
                    {  
        
                        get { return this.Count; }  
        
                    }  
        
                    bool ICollection.IsSynchronized  
        
                    {  
        
                        get { return false; }  
        
                    }  
        
                    object ICollection.SyncRoot  
        
                    {  
        
                        get { throw new Exception("The method or operation is not implemented."); }  
        
                    } 
        
                    #endregion  
        
                }  
        
            }

OrderPartial.cs class that addes accessor for Products list hanging off of the Order entity - put in App_Code dir

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using ListSelector;

public partial class Order

{

    private ListSelector<Order_Detail, Product> products = null;

    public ListSelector<Order_Detail, Product> Products

    {

        get

        {

            if (products == null)

                products = this.Order_Details.AsListSelector(od => od.Product);

            return products;

        }

    }

}

Modified DataClasses.dbml (LINQ Entities) based on Northwind DB in sample code: - adds 3rd level relationships - replaces same file in App_Code directory

<?xml version="1.0" encoding="utf-8"?>

<Database Name="NorthwindDB" Class="DataClassesDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">

  <Connection Mode="WebSettings" ConnectionString="Data Source=scburk1;AttachDbFilename=|DataDirectory|\Northwind.mdf;Initial Catalog=NorthwindDB;Integrated Security=True" SettingsObjectName="System.Configuration.ConfigurationManager.ConnectionStrings" SettingsPropertyName="NorthwindDBConnectionString" Provider="System.Data.SqlClient" />

  <Table Name="dbo.Customers" Member="Customers">

    <Type Name="Customer">

      <Column Name="CustomerID" Type="System.String" DbType="NChar(5) NOT NULL" CanBeNull="false" />

      <Column Name="CompanyName" Type="System.String" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />

      <Column Name="ContactName" Type="System.String" DbType="NVarChar(30)" CanBeNull="true" />

      <Column Name="ContactTitle" Type="System.String" DbType="NVarChar(30)" CanBeNull="true" />

      <Column Name="Address" Type="System.String" DbType="NVarChar(60)" CanBeNull="true" />

      <Column Name="City" Type="System.String" DbType="NVarChar(15)" CanBeNull="true" />

      <Column Name="Region" Type="System.String" DbType="NVarChar(15)" CanBeNull="true" />

      <Column Name="PostalCode" Type="System.String" DbType="NVarChar(10)" CanBeNull="true" />

      <Column Name="Country" Type="System.String" DbType="NVarChar(15)" CanBeNull="true" />

      <Column Name="Phone" Type="System.String" DbType="NVarChar(24)" CanBeNull="true" />

      <Column Name="Fax" Type="System.String" DbType="NVarChar(24)" CanBeNull="true" />

      <Association Name="Customer_Order" Member="Orders" ThisKey="CustomerID" OtherKey="CustomerID" Type="Order" />

    </Type>

  </Table>

  <Table Name="dbo.Orders" Member="Orders">

    <Type Name="Order">

      <Column Name="OrderID" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />

      <Column Name="CustomerID" Type="System.String" DbType="NChar(5)" CanBeNull="true" />

      <Column Name="EmployeeID" Type="System.Int32" DbType="Int" CanBeNull="true" />

      <Column Name="OrderDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />

      <Column Name="RequiredDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />

      <Column Name="ShippedDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />

      <Column Name="ShipVia" Type="System.Int32" DbType="Int" CanBeNull="true" />

      <Column Name="Freight" Type="System.Decimal" DbType="Money" CanBeNull="true" />

      <Column Name="ShipName" Type="System.String" DbType="NVarChar(40)" CanBeNull="true" />

      <Column Name="ShipAddress" Type="System.String" DbType="NVarChar(60)" CanBeNull="true" />

      <Column Name="ShipCity" Type="System.String" DbType="NVarChar(15)" CanBeNull="true" />

      <Column Name="ShipRegion" Type="System.String" DbType="NVarChar(15)" CanBeNull="true" />

      <Column Name="ShipPostalCode" Type="System.String" DbType="NVarChar(10)" CanBeNull="true" />

      <Column Name="ShipCountry" Type="System.String" DbType="NVarChar(15)" CanBeNull="true" />

      <Association Name="Order_Order_Detail" Member="Order_Details" ThisKey="OrderID" OtherKey="OrderID" Type="Order_Detail" />

      <Association Name="Customer_Order" Member="Customer" ThisKey="CustomerID" OtherKey="CustomerID" Type="Customer" IsForeignKey="true" />

    </Type>

  </Table>

  <Table Name="dbo.[Order Details]" Member="Order_Details">

    <Type Name="Order_Detail">

      <Column Name="OrderID" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />

      <Column Name="ProductID" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />

      <Column Name="UnitPrice" Type="System.Decimal" DbType="Money NOT NULL" CanBeNull="false" />

      <Column Name="Quantity" Type="System.Int16" DbType="SmallInt NOT NULL" CanBeNull="false" />

      <Column Name="Discount" Type="System.Single" DbType="Real NOT NULL" CanBeNull="false" />

      <Association Name="Order_Order_Detail" Member="Order" ThisKey="OrderID" OtherKey="OrderID" Type="Order" IsForeignKey="true" />

      <Association Name="Product_Order_Detail" Member="Product" ThisKey="ProductID" OtherKey="ProductID" Type="Product" IsForeignKey="true" />

    </Type>

  </Table>

  <Table Name="dbo.Products" Member="Products">

    <Type Name="Product">

      <Column Name="ProductID" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />

      <Column Name="ProductName" Type="System.String" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />

      <Column Name="SupplierID" Type="System.Int32" DbType="Int" CanBeNull="true" />

      <Column Name="CategoryID" Type="System.Int32" DbType="Int" CanBeNull="true" />

      <Column Name="QuantityPerUnit" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />

      <Column Name="UnitPrice" Type="System.Decimal" DbType="Money" CanBeNull="true" />

      <Column Name="UnitsInStock" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />

      <Column Name="UnitsOnOrder" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />

      <Column Name="ReorderLevel" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />

      <Column Name="Discontinued" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />

      <Association Name="Product_Order_Detail" Member="Order_Details" ThisKey="ProductID" OtherKey="ProductID" Type="Order_Detail" />

    </Type>

  </Table>

</Database>

Grid

answered on 17 Jul 2009

5 answers

356 views

(Container is GridEditFormInsertItem) inline aspx?

Hi

I am using this demo for my example.

http://demos.telerik.com/aspnet-ajax/grid/examples/dataediting/popupeditform/defaultcs.aspx

For the pop up form, I only want to display a checkbox when editing, not inserting. However I can not seem to get it working.

Have tried:

                                                <tr ID="tr1" runat="server" visible='<%# !(Container is GridEditFormInsertItem) %>'>         
                                            <td>Archived:</td>         
                                            <td><asp:CheckBox ID="Archived" runat="server" Checked='<%# Bind("Archived") %>' Text="Don't display." /></td>         
                                        </tr>         

However there is no Bind in inserting. It work in Updating but on inserting I get a cast error.

I also tried this:

                                                <% if (!(Container is GridEditFormInsertItem)) { %>         
                                        <tr>         
                                            <td>Archived:</td>         
                                            <td><asp:CheckBox ID="Archived" runat="server" Checked='<%# Bind("Archived") %>' Text="Don't display." /></td>         
                                        </tr>         
                                        <%} %>         

And yep couldn't get this working too. Can anyone help? Thanks.

Grid

answered on 17 Jul 2009

2 answers

161 views

ItemIndexHierarchical Removal Problem

Hi

I have 2 questions/problems to ask:

1) I have a Hierarchical Grid that drills down 3 levels and I am currently using a snippet of code found on the forum (see below) that allows me to keep open any children, grandchildren within the Hierarchical Grid on rebind. Although it only works for 2 levels , is it possible for this to be modified for, say, an infinite amount ot children, grandchildren and so on...

    
                    protected void RadGrid1_DataBound(object sender, EventArgs e)  
        
                    {  
        
                        //Expand all items using our custom storage  
        
                        string[] indexes = new string[this.ExpandedStates.Keys.Count];  
        
                        this.ExpandedStates.Keys.CopyTo(indexes, 0);  
        
                        ArrayList arr = new ArrayList(indexes);  
        
                        //Sort so we can guarantee that a parent item is expanded before any of   
        
                        //its children  
        
                        arr.Sort();  
        
                        foreach (string key in arr)  
        
                        {  
        
                            bool value = (bool)this.ExpandedStates[key];  
        
                            if (value)  
        
                            {  
        
                                RadGrid1.Items[key].Expanded = true;  
        
                            }  
        
                        }  
        
                        //Select all items using our custom storage  
        
                        indexes = new string[this.SelectedStates.Keys.Count];  
        
                        this.SelectedStates.Keys.CopyTo(indexes, 0);  
        
                        arr = new ArrayList(indexes);  
        
                        //Sort to ensure that a parent item is selected before any of its children  
        
                        arr.Sort();  
        
                        foreach (string key in arr)  
        
                        {  
        
                            bool value = (bool)this.SelectedStates[key];  
        
                            if (value)  
        
                            {  
        
                                RadGrid1.Items[key].Selected = true;  
        
                            }  
        
                        }  
        
                    }  
        
                    //Save/load expanded states Hash from the session  
        
                    //this can also be implemented in the ViewState  
        
                    private Hashtable ExpandedStates  
        
                    {  
        
                        get  
        
                        {  
        
                            if (this._visitsExpandedState == null)  
        
                            {  
        
                                _visitsExpandedState = this.Session["_visitsExpandedState"] as Hashtable;  
        
                                if (_visitsExpandedState == null)  
        
                                {  
        
                                    _visitsExpandedState = new Hashtable();  
        
                                    this.Session["_visitsExpandedState"] = _visitsExpandedState;  
        
                                }  
        
                            }  
        
                            return this._visitsExpandedState;  
        
                        }  
        
                    }  
        
                    //Clear the state for all expanded children if a parent item is collapsed  
        
                    private void ClearExpandedChildren(string parentHierarchicalIndex)  
        
                    {  
        
                        string[] indexes = new string[this.ExpandedStates.Keys.Count];  
        
                        this.ExpandedStates.Keys.CopyTo(indexes, 0);  
        
                        foreach (string index in indexes)  
        
                        {  
        
                            //all indexes of child items  
        
                            if (index.StartsWith(parentHierarchicalIndex + "_") ||  
        
                                index.StartsWith(parentHierarchicalIndex + ":"))  
        
                            {  
        
                                this.ExpandedStates.Remove(index);  
        
                            }  
        
                        }  
        
                    }  
        
                    //Save/load selected states Hash from the session  
        
                    //this can also be implemented in the ViewState  
        
                    private Hashtable SelectedStates  
        
                    {  
        
                        get  
        
                        {  
        
                            if (this._selectedState == null)  
        
                            {  
        
                                _selectedState = this.Session["_selectedState"] as Hashtable;  
        
                                if (_selectedState == null)  
        
                                {  
        
                                    _selectedState = new Hashtable();  
        
                                    this.Session["_selectedState"] = _selectedState;  
        
                                }  
        
                            }  
        
                            return this._selectedState;  
        
                        }  
        
                    }  
        
                    protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)  
        
                    {  
        
                        //save the expanded/selected state in the session  
        
                        if (e.CommandName == RadGrid.ExpandCollapseCommandName)  
        
                        {  
        
                            //Is the item about to be expanded or collapsed  
        
                            if (!e.Item.Expanded)  
        
                            {  
        
                                //Save its unique index among all the items in the hierarchy  
        
                                this.ExpandedStates[e.Item.ItemIndexHierarchical] = true;  
        
                            }  
        
                            else //collapsed  
        
                            {  
        
                                this.ExpandedStates.Remove(e.Item.ItemIndexHierarchical);  
        
                                this.ClearExpandedChildren(e.Item.ItemIndexHierarchical);  
        
                            }  
        
                        }  
        
                        //Is the item about to be selected   
        
                        else if (e.CommandName == RadGrid.SelectCommandName)  
        
                        {  
        
                            //Save its unique index among all the items in the hierarchy  
        
                            this.SelectedStates[e.Item.ItemIndexHierarchical] = true;  
        
                        }  
        
                        //Is the item about to be deselected   
        
                        else if (e.CommandName == RadGrid.DeselectCommandName)  
        
                        {  
        
                            this.SelectedStates.Remove(e.Item.ItemIndexHierarchical);  
        
                        }  
        
                    }

2) Within the same Hierarchical Grid I am allowing users to remove either children and grandchildren , and when doing so in order for the ribind to reopen any previously open levels, i need to remove the ExpandedStates.Keys of the item being deleted, but i am having trouble doing so, and this causes my rebind to error due to it finding an expandedState Key that no longer exists.

Can you help?

Thanks in advance

Grid

answered on 17 Jul 2009

2 answers

137 views

Repeater in a radDockZone

I want to create a dock zone which contains a list of docks created dynamically using a repeater. How should I go about doing it? Can I do something like:

<telerik:RadDockZone...>
<asp:Repeater...
</telerik:RadDockZone>

Dock

answered on 17 Jul 2009

2 answers

134 views

Related ComboBoxes - Server Side

Hi, does anyone have an example they could post on using related combo boxes using code-behind.

The example on site uses client-side events and i'm struggling to get this working using just code-behind - I can't retrive the text or value from the first combo box in ItemsRequested method for the second combo-box, it just returns a blank string or NULL.

Any examples of how to achieve this would be cool!

Thanks,
N

ComboBox

answered on 17 Jul 2009