Questions on UI for ASP.NET AJAX Forum

4 answers

174 views

Filtering on foreign key columns not working

Morning,
My foreign key columns are not filtering.
I get this error: "Expression expected".
Furthermore none of the foreign key columns have the "Contains" filter option.
The WebsiteUrl column has "Contains" filter option and works perfectly.

My columns look like this:

        <telerik:GridBoundColumn DataField="WebsiteId" DataType="System.Int64"

            EmptyDataText="&nbsp;" HeaderText="WebsiteId" ReadOnly="True"

            SortExpression="WebsiteId" UniqueName="WebsiteId" Visible="false" ForceExtractValue="InEditMode">

        </telerik:GridBoundColumn>



        <telerik:GridBoundColumn DataField="WebsiteUrl" EmptyDataText="&nbsp;"

            HeaderText="WebsiteUrl" SortExpression="WebsiteUrl" UniqueName="WebsiteUrl">

        </telerik:GridBoundColumn>



            <telerik:GridTemplateColumn HeaderText="Client"

                DataType="System.Int64" UniqueName="Client" >

                    <EditItemTemplate>

                        <telerik:RadComboBox ID="RadComboBoxClientName" Runat="server"

                            DataSourceID="LinqDataSourceClient" DataTextField="ClientName"

                            DataValueField="ClientId" SelectedValue='<%# Bind("ClientId") %>'

                            Skin="Vista" Width="280px">

                            <CollapseAnimation Duration="200" Type="OutQuint" />

                        </telerik:RadComboBox>

                    </EditItemTemplate>



                    <ItemTemplate>



                        <asp:Label ID="LabelClientName" runat="server" Text= <%#Eval("tblClient.ClientName")%>         > </asp:Label>



                    </ItemTemplate>

                </telerik:GridTemplateColumn>



            <telerik:GridTemplateColumn HeaderText="Server"

                DataType="System.Int32" UniqueName="Server"  >

                    <EditItemTemplate>

                        <telerik:RadComboBox ID="RadComboBoxServerName" Runat="server"

                            DataSourceID="LinqDataSourceServer" DataTextField="ServerName"

                            DataValueField="ServerId" SelectedValue='<%# Bind("ServerId") %>'

                            Skin="Vista" Width="280px">

                            <CollapseAnimation Duration="200" Type="OutQuint" />

                        </telerik:RadComboBox>

                    </EditItemTemplate>



                    <ItemTemplate>



                        <asp:Label ID="LabelServerName" runat="server" Text= <%#Eval("tblServer.ServerName")%>> </asp:Label>



                    </ItemTemplate>

                </telerik:GridTemplateColumn>



        <telerik:GridBoundColumn DataField="LogFilePath" EmptyDataText="&nbsp;"

            HeaderText="LogFilePath" SortExpression="LogFilePath"

            UniqueName="LogFilePath" Display="False">

        </telerik:GridBoundColumn>

        <telerik:GridBoundColumn DataField="BandWidthCost" DataType="System.Decimal"

            EmptyDataText="&nbsp;" HeaderText="BandWidthCost"

            SortExpression="BandWidthCost" UniqueName="BandWidthCost" Visible="false">

        </telerik:GridBoundColumn>

I've Specified the filter menu manually like this:

    protected void RadGrid1_Init(object sender, EventArgs e)

    {

        GridFilterMenu menu = RadGrid1.FilterMenu;

        int i = 0;

        while (i < menu.Items.Count)

        {

            if (menu.Items[i].Text == "NoFilter" ||

               menu.Items[i].Text == "Contains" ||

               menu.Items[i].Text == "EqualTo" ||

               menu.Items[i].Text == "GreaterThan" ||

               menu.Items[i].Text == "LessThan")

            {

                i++;

            }

            else

            {

                menu.Items.RemoveAt(i);

            }

        }

    }

Grid

answered on 19 Apr 2011

1 answer

89 views

GridDropDownColumn and SQL SELECT

Hello.

I need to add a drop-down column to RadGrid at Page_Load.
I have SQLDataSource in ASP.

C# code:
GridDropDownColumn ddColumn = new GridDropDownColumn();
RadGridTable.MasterTableView.Columns.Add(ddColumn);
ddColumn.DataSourceID = "LookupDS";
ddColumn.DataField = "table_name";
ddColumn.ListValueField = "id";
ddColumn.ListTextField = "name";

Everything works fine with SQL statement:
SELECT s.name AS id, s.name AS name
FROM sys.sysobjects s LEFT JOIN org_menu m ON (s.name=m.table_name)
WHERE (s.xtype='U') ORDER BY s.id

Then I slightly modify SQL to skip existing tables:
SELECT s.name AS id, s.name AS name
FROM sys.sysobjects s LEFT JOIN org_menu m ON (s.name=m.table_name)
WHERE ( (s.xtype='U') AND ( m.table_name IS NULL ) ) ORDER BY s.id

Now in that specific grid column all cells are empty.
However if I open row in editor the value shows up (in editor).

I checked SQL statements in management studio - both work fine.
The only difference is that the first returns more rows.

Any suggestions?

Grid

answered on 19 Apr 2011

3 answers

155 views

Why not add an embedded emoticon dropdownlist

hello telerik,
sometimes we need to insert some emoticons to the text, although we can implement this function by customization, it is still inconvenient. why not add an embedded emoticon dropdownlist, and offer us a property to set a path which the folder contains the images we wanted, it's better that we can set a root folder, if it has sub-folder, it can be grouped automatically, Please see my attach image. thanks.

Editor

answered on 19 Apr 2011

3 answers

297 views

Natural Sort vs. Alphabetical Sort

I'm using a RadGrid found in RadControls for ASPNET AJAX Q1 2008.

I've got alphanumeric data in a column that I need to sort via natural sort. Please look at this for better information about natural sort: http://www.codinghorror.com/blog/archives/001018.html

I tried getting it to work and I have been unsuccessful. Has anyone else tried implementing this in a RadGrid with out having to call the DB again?

Any suggestions are greatly appreciated.

Zack

Grid

answered on 19 Apr 2011

2 answers

74 views

Master-detail RadGrid--->Chart?

Hi, I was just wondering if it is possible to have a master detail relationship between radgrid and radchart.

I would like to display a piechart of data, however, it is likely that this pie chart may end up with a lot of records, so I would like the user to be able to select a record in a grid and this even to cause the chart to highlight or explode the corresponding segment of the piechart for that record.

Is this possible? If so, are there any examples I could look at or could be provided?

Thanks,
Matt

- Please ignore this, I found a solution

Chart (Obsolete)

answered on 19 Apr 2011

2 answers

96 views

Access radrotator click events for controlbuttons server-side

Hello,

I am using a RadRotator to display one item at a time. I have my own controlbuttons (using ImageButtons) to navigate the RadRotator left and right.

I want to perform a server-side action on my page whenever a user clicks the left or right navigation buttons. Unfortunately, the onclick event for my ImageButton is not working whenever the ImageButton is used as a controlbutton for the RadRotator.

How do I accomplish my scenario?

Thanks,
Zeyad

Rotator

answered on 19 Apr 2011

2 answers

93 views

RadAjaxManager OnRequestStart is not fired when press for the second time on a button in the user control in an aspx page at sharepoint

hi all

how are you

i wish anyone could help me in this problem

i have an aspx page deployed on sharepoint as an edit form of an SPList item in a custom list

the aspx page contain a custom user control

in the custom user control i have one button

when the button is clicked it open a RadAjaxLoadingPanel that is spanned over the whole page

my problem is if i press the first time on the button the panel is displayed successfuly and the OnRequestStart and OnRequestEvents
fires successfuly

but when i press for the button on the second time the OnRequestStart doesnt fires

can anyone help me in this problem

i have read so many posts and tried all what is mentioned in them but nothing worked for me

thanks a lot

Ajax

answered on 18 Apr 2011

1 answer

119 views

RadGrid ItemCommand event not firing

I have a RadGrid with a hierarchy view (about 5 levels deep). I bind programmatically in the OnPreRender event. EnableViewState=false. The ItemCommand event fires for any item in the first three levels of the hierarchy but when I try to expand something beyond that level, the event doesn't fire anymore. Any ideas?

Trevor

Grid

answered on 18 Apr 2011

1 answer

103 views

RadGrid Office2007 Style Table Design Custom Style Problem

My problem realated with Office2007 Custom Style.I created my custom skin from default Office2007 css files.

And I changed Alternative row backcolor from html.But When I select row.Problem with background color.In 

white rows there is no problem.How can I redesign css file.Please look image what is my problem

I have changed just


.RadGrid_MyCustomSkin

.rgRow td ,  
 


.RadGrid_MyCustomSkin

 

 

.rgAltRow 
td 

 

{
border-color:#d0d7e5 ;


 

 

border-width:0px ;


 

 

padding: 0 !important 
; }

 

<

telerik:RadGrid ID="grdGidis" Width="720px" Skin="MyCustomSkin" AlternatingItemStyle-BackColor="#F2F2F2"

EnableEmbeddedSkins="false" Height="720px" runat="server" AutoGenerateColumns="False"

OnItemCommand="grdGidis_ItemCommand">

<MasterTableView TableLayout="Fixed" DataKeyNames="UcusID,D_UcusID">

<NoRecordsTemplate>

Sefer Bulunamadı...

</NoRecordsTemplate>

<Columns>

<telerik:GridTemplateColumn ItemStyle-VerticalAlign="Middle" UniqueName="HavayoluLogo">

<HeaderTemplate>

Header...

</HeaderTemplate>

<ItemTemplate>

Items...

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

</MasterTableView>

<PagerStyle Mode="NumericPages"></PagerStyle>

<ClientSettings EnableRowHoverStyle="true" AllowRowsDragDrop="false" Selecting-AllowRowSelect="true"

AllowColumnsReorder="False">

<Resizing AllowRowResize="False" EnableRealTimeResize="False" ResizeGridOnColumnResize="False"

AllowColumnResize="False"></Resizing>

<Selecting AllowRowSelect="false" />

<Scrolling AllowScroll="true" UseStaticHeaders="true" SaveScrollPosition="true" />

</ClientSettings>

</telerik:RadGrid>

Grid

answered on 18 Apr 2011

7 answers

267 views

Codebehind version of the Master/Detail SelectedValue sample

Hello,

I need to build same code as in this sample but I have no declarative datasources.
Is there somewhere some samples off a full code behind version.

How to have the master grid triggering an ajax event to rebind details when a row is changed, how to select first row and, if exists, first details row.

Thanks for help.
CS

Grid

answered on 18 Apr 2011