Questions on UI for ASP.NET AJAX Forum

3 answers

93 views

I've got a fairly basic grid set up, with data being retrieved from database view, but I would like to display some related data that's from a separate source. In my current requirement it would be a count of records on an item table, but there is logic required to determine which item table is used. In standard aspx we would use a function call to the code-behind, passing some data from the row, that would return the the required value.

What is the best way of achieving this with Telerik?

Cheers

Grid

answered on 16 Mar 2015

1 answer

219 views

RadGrid pre-selected rows

Hello,

I have a radgrid in my aspx file that allows for selecting multiple rows with a checkbox. I am using the two properties:

AllowMultiRowSelection="true" and

<ClientSettings EnableRowHoverStyle="true">
<Selecting AllowRowSelect="True"></Selecting>
</ClientSettings>

In my code behind, I populate the grid using a datasource as follows:

CogCustomCompetenciesGrid.DataSource = cl.OrderByDescending(p=> p.ImportanceRating).ToList();

The list used for population consists of objects with multiple properties. One of the properties is a boolean called PreviouslySelected.

Based on whether the PreviouslySelected property is true or false, I need to pre-set the checkmark selection for that particular row.

How do I do this?

Grid

answered on 16 Mar 2015

4 answers

93 views

How to install controls

I have taken over someone else's computer and it seems that Telerik is already installed on it. e.g I see a a menu item "Telerik" on the bar; there is a "Telerik" folder in "Program Files" Which contains thousands of files; the GAC shows many Telerik assemblies but they are all for Reporting. But, the folder "Telerik" in the ToolBox contains only one control "ReportViewer".
How do I get the other tools to show up?

General Discussions

answered on 16 Mar 2015

1 answer

133 views

Custom paging with radgrid

Hi guys,

I was asked to bind around 1 lakh records to radgrid . but it will create some client side problem so i planned to bring first 100 records from sql db and bind it grid in terms of 10 in each page (10*10) , if user clicks eleventh page, i would like to bring another 100 records from sql and bind it to another page..

is this possible in radgrid?

or do i need to make db calls whenever next page gets clicked ? i want to reduce db calls as well.. How this can be achieved in radgrid..

Any sample much appreciated.

Thanks in advance

Grid

answered on 16 Mar 2015

4 answers

695 views

TreeView Bind Error:"This constraint cannot be enabled as not all values have corresponding parent values."

Hi everyone.
I've a problem with my TreeView controls. the problem is;

When I try to bind data from DB to RadTreeView, it gives this error : "This constraint cannot be enabled as not all values have corresponding parent values."

C# Code :

    
            private void ForTree()
        
            {
        
            line 1:String Query = "SELECT * FROM dbo.FESTIVAL WHERE flag=0";
        
            line 2:myDataTable3 = dtClass.GetQuery(Query);
        
                    RadTreeView3.DataSource = myDataTable3;
        
                    RadTreeView3.DataFieldID = "fest_id";
        
                    RadTreeView3.DataValueField = "fest_id";
        
                    RadTreeView3.DataFieldParentID = "cat_id";
        
                    RadTreeView3.DataTextField = "title";
        
            line 8:RadTreeView3.DataBind();&nbsp;&nbsp; // This is the line where error occurs. 

            }

line 2 is connects to DB and fill the datatable from another class.

when I write the query :"SELECT * FROM dbo.FESTIVAL", there was no problem but when I add it "WHERE flag=0" clause to filter some data at "line 1" it gives me error. And interesting point is When I change the Flag value to "1" (flag=1) it works fine !!, it makes me crazy.

I search all the topics in "Telerik Forums" and there were some problems as mine, but my table is not spereated and all the Parent_id's values are "NULL"

so what can I do at this situation?

Database DataTable:

cat_id is a child_id. title column has some words will placed on node.

dbo.Festival
Fest_id   Cat_id flag title
1   NULL      0
2   NULL      1
3    NULL      0
4   NULL      1
5   NULL 0
6             NULL 1
7   NULL      0
8   NULL      1
9 NULL      0
10 NULL   1
11    NULL   0
12   NULL    1
13    NULL   0
14    NULL    1
15    NULL    0
16 NULL    1
17           NULL    0
18           NULL     1
19    NULL   0
20    NULL     1
21   1          0
22           1 1
23           1      0
24           1 1
25   2      0
26   2    1
27    2   0
28    2         1
29    3    0
30    3    1
31    4      0
32   4      1
33           7      0
34   7      1
35            8   0
36      8   1
37            9      0
38            9          1
39          10 0

...it goes until 180 records.

TreeView

answered on 14 Mar 2015

1 answer

81 views

Unwanted column text added after sort

The grid looks fine and when I sort a column the class name of my Serializable class gets added many time to the right. Every time I press sort more text gets added. I have attached picture.

I am trying to add columns names at runtime since I do not know them in advanced. My code is based on the Grid - Virtualization example and the documentation on columns Creating a Hierarchical Grid Programmatically. It basically right out of the example and documentation.

My Asp:

<%@ Page Title="Group Administration" Language="C#" MasterPageFile="~/Organization.Master" AutoEventWireup="true" CodeBehind="GroupAdmin.aspx.cs" Inherits="SignupList.Admin.GroupAdmin" %>

<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">

Administration

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

<telerik:RadAjaxPanel runat="server" ID="RadAjaxPanel" LoadingPanelID="RadAjaxLoadingPanel" CssClass="demo-container">

<telerik:RadGrid ID="AdminGrid" OnNeedDataSource="AdminGrid_NeedDataSource" runat="server"

Skin="Default" AutoGenerateColumns="false" AllowSorting="true" GroupingEnabled="false"

EnableHeaderContextMenu="true" AllowPaging="true" PageSize="50">

<ClientSettings ReorderColumnsOnClient="true" AllowColumnsReorder="true" ColumnsReorderMethod="Reorder">

<Virtualization EnableVirtualization="true" InitiallyCachedItemsCount="2000"

LoadingPanelID="RadAjaxLoadingPanel" ItemsPerView="100"/>

<Scrolling AllowScroll="true" UseStaticHeaders="true" ScrollHeight="500px" />

<Resizing AllowColumnResize="true" />

</ClientSettings>

<PagerStyle Mode="NextPrevNumericAndAdvanced"></PagerStyle>

</telerik:RadGrid>

</telerik:RadAjaxPanel>

</asp:Content>

My aspx.cs file

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web.UI.WebControls;

using SignupList.Com.SignupList;

using SignupList.Com.SignupList.Display.Models;

using Telerik.Web.UI;

namespace SignupList.Admin

{

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

{

protected void Page_Init(object source, System.EventArgs e)

{

DefineGridStructure(AdminGrid);

}

protected void Page_Load(object sender, EventArgs e) {

}

private static readonly Random Random = new Random();

static string[] contactNames = new string[] { "Antonio Moreno", "Elizabeth Lincoln", "Hanna Moos", "Jaime Yorres", "Georg Pipps",

"Pascale Cartrain", "Paul Henriot", "Matti Karttunen", "Patricio Simpson","Howard Snyder"};

static string[] companyNames = new string[] { "Blauer See Delikatessen", "Folies gourmandes", "Hungry Coyote Import Store", "Let's Stop N Shop",

"B's Beverages", "QUICK-Stop", "Split Rail Beer & Ale", "Wartian Herkku","Sant� Gourmet","Romero y tomillo" };

static string[] contactTitles = new string[] { "Marketing Assistant", "Sales Associate", "Sales Agent", "Sales Representative",

"Owner", "Sales Manager", "Accounting Manager","Marketing Manager","Sales Consultant","Accountant"};

static string[] countries = new string[] { "Bulgaria", "USA", "Austria", "Germany", "Italy", "England", "Argentina", "Brazil", "France", "Spain" };

static string[] ratings = { "1", "2", "3", "4", "5", "6", "7", "8", "9", "10" };

public List<Member> DataSource

{

get

{

object obj = Application["GroupAdminDataSource"];

if (obj == null) {

List<Member> customers = new List<Member>();

for (int i = 0; i < 2000; i++)

{

int titlesIndex = Random.Next() % 10;

int companyIndex = Random.Next() % 10;

int contactIndex = Random.Next() % 10;

int ratingIndex = Random.Next() % 10;

int countryIndex = Random.Next() % 10;

Member customer = new Member();

customer.ID = (i + 1).ToString();

;

customer.Value1 = contactTitles[titlesIndex];

customer.Value2 = companyNames[companyIndex];

customer.Value3 = contactNames[contactIndex];

customer.Value4 = countries[countryIndex];

customer.Value5 = ratings[ratingIndex];

customers.Add(customer);

}

Application["GroupAdminDataSource"] = customers;

}

return (List<Member>)Application["GroupAdminDataSource"];

}

set

{

Application["GroupAdminDataSource"] = value;

}

protected void AdminGrid_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

AdminGrid.DataSource = DataSource;

}

[Serializable]

public class Member

{

public string ID { get; set; }

public string Value1 { get; set; }

public string Value2 { get; set; }

public string Value3 { get; set; }

public string Value4 { get; set; }

public string Value5 { get; set; }

}

private void DefineGridStructure(RadGrid adminGrid)

{

if (adminGrid.MasterTableView.Columns.Count > 1) {

// exit if columns are already defined

return;

}

adminGrid.MasterTableView.DataKeyNames = new string[] { "ID", "Value1", "Value2","Value3", "Value4", "Value5" };

//Add columns

GridBoundColumn boundColumn;

boundColumn = new GridBoundColumn();

boundColumn.UniqueName = "ID";

boundColumn.DataField = "ID";

boundColumn.HeaderText = "ID";

boundColumn.HeaderStyle.Width = Unit.Pixel(50);