Questions on UI for ASP.NET AJAX Forum

3 answers

342 views

I am new to using rad controls and I am in the process of creating a simple front end to a database. The tables in the database are set up in such a way that I have a many-to-many relationship with an intermediate table. An example is I have a vendor table and a contact table and an intermediate table called vendor-contact which has the vendor id and contact id and it links the other 2 tables. I am using a radgrid control and am having difficulty setting up the hierarchy with the vendor being the master table and the contacts being the detail table. Is it possible to use the hierarchy in radgrid with a many-to-many relationship? If so, does someone have a sample of the select query I could use for the details table?

Also, on a different question, I would like to use the tooltip so that when a user hovers over the vendor name, all the data from the vendor table populates in the tooltip. Is it possible to combine the radgrid and the tooltip?

Thanks in advance,
Laura

Grid

answered on 28 Apr 2009

2 answers

138 views

NextPrevNumericAndAdvanced: Localization

Hi, i follow some guides and forum posts, to translate the NextPrevNumericAndAdvanced pager, but i lost an information on how to translate a label.
I do this:

    
            Protected Sub RadGrid1_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles RadGrid1.ItemDataBound 
        
                    If TypeOf e.Item Is Telerik.Web.UI.GridPagerItem Then 
        
                        Dim lblGoToPage As Label = DirectCast(e.Item.FindControl("GoToPageLabel"), Label) 
        
                        If Not lblGoToPage Is Nothing Then lblGoToPage.Text = "Seleziona Pagina:" 
        
                        Dim lbGoToPage As Button = DirectCast(e.Item.FindControl("GoToPageLinkButton"), Button) 
        
                        If Not lbGoToPage Is Nothing Then lbGoToPage.Text = "Visualizza" 
        
                        Dim lblPageSize As Label = DirectCast(e.Item.FindControl("ChangePageSizeLabel"), Label) 
        
                        If Not lblPageSize Is Nothing Then lblPageSize.Text = "Comunicazioni per Pagina:" 
        
                        Dim lbPageSize As Button = DirectCast(e.Item.FindControl("ChangePageSizeLinkButton"), Button) 
        
                        If Not lbPageSize Is Nothing Then lbPageSize.Text = "Mostra" 
        
                    End If 
        
                End Sub

In the example i translate "GoToPageLabel" and "ChangePageSizeLabel", but in the grid i have another label contains "of number of pages as number".
How can i translate this label? what is its name?

thank you

Ellis

Grid

answered on 28 Apr 2009

1 answer

130 views

How to update a css of Skin

Dear all,

I have to change the css of rad grid skin....
Please tell me....

Thanks & regards
brijendra pandey

Grid

answered on 28 Apr 2009

1 answer

100 views

Paging is not working After Sorting column in RadGrid while using UpdatePanel

HI,

I am using RadGrid Control in side Asp.net updatepanel. I am facing following problem... When user clicks paging it is working perfectly. When user clicks any column for sorting purpose (Sort Mode) and after that clicks paging it is not working.....

What is issue with this ?

Thanks & Regards

SHAJI P.D.

Grid

answered on 28 Apr 2009

1 answer

149 views

[Solved] IgnorePaging and filter problem in grid export

Hi..
I am hiding column filter while exporting grid to excel. it works fine if i do not add grid1.ExportSettings.IgnorePaging = true;
if i add IgnorePaging = true; it adds one blank row in exported excel file.

    
            protected void btn_Click(object sender, EventArgs e) 
        
            {         
        
                foreach (GridItem commandItem in this.grid1.MasterTableView.GetItems(GridItemType.FilteringItem)) 
        
                { 
        
                    commandItem.Visible = false; 
        
                } 
        
                grid1.ExportSettings.FileName = "file"; 
        
                grid1.ExportSettings.ExportOnlyData = true; 
        
                grid1.ExportSettings.OpenInNewWindow = true; 
        
                grid1.ExportSettings.IgnorePaging = true; 
        
                grid1.MasterTableView.ExportToExcel(); 
        
            }

IgnorePaging is creating problem.
how can it be solved.?

Thanks,

Grid

answered on 28 Apr 2009

2 answers

61 views

[Solved] limit the number of concurrent recurrent appointments for a single resource

Hello,

I'm looking for a way to prevent users to make an recurrent appointment within a room where an appointment already exists. I´ve already checked
http://www.telerik.com/support/kb/aspnet-ajax/scheduler/limit-the-number-of-concurrent-appointments-just-for-a-single-resource.aspx
Can you provide a sample code?

With regards,
Pim

Scheduler

answered on 28 Apr 2009

7 answers

171 views

[Solved] Confused about RadGrid and ContextMenu

I am trying to have a context menu in my grid but have no joy so far...

    
            <telerik:RadContextMenu ID="GridContextMenu" runat="server"> 
        
                <Targets> 
        
                    <telerik:ContextMenuControlTarget ControlID="RadGridKids" /> 
        
                    <telerik:ContextMenuControlTarget ControlID="Label1" /> 
        
                </Targets> 
        
                <Items> 
        
                    <telerik:RadMenuItem runat="server" Text="Root Stuff"> 
        
                        <Items> 
        
                            <telerik:RadMenuItem runat="server" Text="Child RadMenuItem 1"> 
        
                            </telerik:RadMenuItem> 
        
                            <telerik:RadMenuItem runat="server" Text="Child RadMenuItem 2"> 
        
                            </telerik:RadMenuItem> 
        
                        </Items> 
        
                    </telerik:RadMenuItem> 
        
                    <telerik:RadMenuItem runat="server" Text="Root Item 2"> 
        
                    </telerik:RadMenuItem> 
        
                </Items> 
        
            </telerik:RadContextMenu> 
        
            <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label> 
        
            <telerik:RadGrid ID="RadGridKids" runat="server" GridLines="Horizontal" OnItemDataBound="RadGridKids_ItemDataBound" 
        
                AutoGenerateColumns="False" Height="99%" ShowStatusBar="True" GroupingEnabled="False"> 
        
                <MasterTableView CellSpacing="-1"> 
        
                    <RowIndicatorColumn> 
        
                        <HeaderStyle Width="20px" /> 
        
                    </RowIndicatorColumn> 
        
                    <ExpandCollapseColumn> 
        
                        <HeaderStyle Width="20px" /> 
        
                    </ExpandCollapseColumn> 
        
                    <Columns> 
        
                        <telerik:GridBoundColumn HeaderText="Node Description" UniqueName="NodeDesc"> 
        
                        </telerik:GridBoundColumn> 
        
                    </Columns> 
        
                </MasterTableView> 
        
                <ClientSettings> 
        
                    <Selecting AllowRowSelect="True" /> 
        
                    <Scrolling AllowScroll="True" UseStaticHeaders="True" /> 
        
                    <ClientEvents OnRowContextMenu="GridRowContextMenu" /> 
        
                </ClientSettings> 
        
            </telerik:RadGrid>

My grid is populated via assigning a DataSource in an Ajax Request.
In the ..._ItemDataBound, I assign a Tooltip to each item.

Before the Grid is populated, the code shows the context menu fine on the label and on the datagrid.
The GridRowContextMenu(...) does not fire which I suppose is normal since there are no rows.

After the grid is populated, the GridRowContextMenu() javascript fires all right but there is no more context menu on the Grid...

Am I supposed to do something when DataBinding the grid?

Thanks

Eric

Menu

answered on 28 Apr 2009

0 answers

100 views

runtime error

i'm using rad chart , but a run time error appears
Unexpected error has occured.please review the inner exception for more information to solve the problem.
INNER EXCEPTION as follow:
Object reference not set to an instance of an object.

SOURCE:
Telerik.wincontrols.radchart
What is the problem and how to solve it?

General Discussions

asked on 28 Apr 2009

7 answers

188 views

RadScriptManager + ASP.NET MVC

Im using RadScriptManager but when i Debug the page i've keep getting this error:
Microsoft ASP.NET AJAX cannot be initialized!
[Break on this error] if(typeof(Sys) != "undefined"){$addH...t ASP.NET AJAX cannot be initialized!"

RadScriptManager automaticly adds the folowing javascript:

<script type="text/javascript">
//<![CDATA[
if(typeof(Sys) != "undefined"){$addHandler(window, "load", function(){Sys.Application.initialize();}); } else { throw new Error("Microsoft ASP.NET AJAX cannot be initialized!")}
//]]>

General Discussions

answered on 28 Apr 2009

5 answers

169 views

[Solved] IE column width expands on ExpandCollapse command

Hi,

I've been trying a lot of diferent ways how to achieve that column width wouldn't expand when I try to expand parent nodes (IE).

Here is my aspx code. When child tables are viewed, IE simpli expands mastertableview columns.

Any help would be appreciated.

<telerik:RadGrid ID="skupineGrid" runat="server" AllowAutomaticDeletes="True" EnableAJAX="true" Width="100%"

          AllowAutomaticInserts="True" AllowAutomaticUpdates="True"
          AllowMultiRowSelection="True" AllowPaging="True"
          AllowSorting="True" SortingSettings-SortToolTip="Klikni tukaj za sortiranje"
          AutoGenerateColumns="False" AutoGenerateDeleteColumn="False"
          AutoGenerateEditColumn="False" DataSourceID="skupineSource" GridLines="None"
          Skin="Vista"
          OnItemCommand="skupineGrid_ItemCommand"
          OnItemCreated="skupineGrid_ItemCreated"
          onitemdatabound="skupineGrid_ItemDataBound"
          oninsertcommand="skupineGrid_InsertCommand"
          onprerender="skupineGrid_PreRender">

          <PagerStyle Mode="NextPrevAndNumeric" ShowPagerText="True"
              PagerTextFormat="Stran: {4} &nbsp;Prikazujem stran {0} od {1}, zapisov {2} do {3} od {5}."
              NextPagesToolTip="Naslednje strani" NextPageToolTip="Naslednja stran"
              PrevPagesToolTip="Prejšnje strani" PrevPageToolTip="Prejšnja stran"
              FirstPageToolTip="Prva stran" LastPageToolTip="Zadnja stran" />

           <ValidationSettings EnableValidation="false" />

            <MasterTableView DataSourceID="skupineSource" DataKeyNames="ID,checked" ClientDataKeyNames="ID" Width="100%"
              TableLayout="Auto" EditMode="InPlace" CommandItemDisplay="Top"
              CommandItemSettings-AddNewRecordText="Dodaj skupino"
              CommandItemSettings-RefreshText="Osveži" Name="Skupine"
              NoDetailRecordsText="V bazi ni zapisov o naslovnikih."
              NoMasterRecordsText="V bazi ni zapisov o skupinah.">



<CommandItemSettings AddNewRecordText="Dodaj skupino" RefreshText="Osveži"></CommandItemSettings>

    <Columns>
        <telerik:GridBoundColumn DataField="skupina" HeaderText="Skupina" HeaderButtonType="TextButton"
            UniqueName="skupina">
        </telerik:GridBoundColumn>
        <telerik:GridEditCommandColumn ButtonType="ImageButton" HeaderText="Uredi"
            UniqueName="EditCommandColumn">
            <HeaderStyle HorizontalAlign="Center" Width="50"></HeaderStyle>
            <ItemStyle HorizontalAlign="Center" />
        </telerik:GridEditCommandColumn>
        <telerik:GridButtonColumn ConfirmText="Ali želite res izbrisati skupino?\n\nIzbrisali boste tudi vsa planirana sporočila (SMS + e-mail) namenjena tej skupini, tako kot tudi vezave naslovnikov na to skupino." ButtonType="ImageButton" HeaderText="Izbriši"
                    CommandName="Delete" UniqueName="DeleteColumn">
                    <HeaderStyle HorizontalAlign="Center" Width="50"></HeaderStyle>
                     <ItemStyle HorizontalAlign="Center" />
         </telerik:GridButtonColumn>
         <telerik:GridTemplateColumn HeaderText="Pošlji SMS" UniqueName="SMS">
         <ItemTemplate>
             <asp:CheckBox ID="smscheck" runat="server" Enabled="true" />
            </ItemTemplate>
            <HeaderStyle HorizontalAlign="Center" Width="80"></HeaderStyle>
            <ItemStyle HorizontalAlign="Center" />
         </telerik:GridTemplateColumn>
   </Columns>

<DetailTables>
                    <telerik:GridTableView DataKeyNames="ID,checked" DataSourceID="naslovnikiSource"
                    EditMode="InPlace" CommandItemDisplay="Top"
                     CommandItemSettings-AddNewRecordText="Dodaj Naslovnika" Width="100%"
                     CommandItemSettings-RefreshText="Osveži"
                     NoDetailRecordsText="V tej skupini ni zapisov o naslovnikih." runat="server"
                     Name="Naslovniki">

              <PagerStyle Mode="NextPrevAndNumeric" ShowPagerText="True"
                  PagerTextFormat="Stran: {4} &nbsp;Prikazujem stran {0} od {1}, zapisov {2} do {3} od {5}."
                  NextPagesToolTip="Naslednje strani" NextPageToolTip="Naslednja stran"
                  PrevPagesToolTip="Prejšnje strani" PrevPageToolTip="Prejšnja stran"
                  FirstPageToolTip="Prva stran" LastPageToolTip="Zadnja stran" />

                        <ParentTableRelation>
                            <telerik:GridRelationFields DetailKeyField="skupID" MasterKeyField="ID" />
                        </ParentTableRelation>

                        <CommandItemSettings AddNewRecordText="Dodaj Naslovnika" RefreshText="Osveži"></CommandItemSettings>

                        <Columns>
                            <telerik:GridBoundColumn HeaderText="Ime" HeaderButtonType="TextButton"
                                DataField="ime" UniqueName="ime">
                            </telerik:GridBoundColumn>

                            <telerik:GridBoundColumn HeaderText="Telefonska številka(m)" HeaderButtonType="TextButton"
                                DataField="stevilka" UniqueName="stevilka">
                            </telerik:GridBoundColumn>

                            <telerik:GridBoundColumn HeaderText="e-mail" HeaderButtonType="TextButton"
                                DataField="email" UniqueName="email">
                            </telerik:GridBoundColumn>

                             <telerik:GridTemplateColumn UniqueName="LST" HeaderText="Skupine">
                             <ItemTemplate>
                                 <asp:ListBox ID="skupddl" Width="160" runat="server" Rows="5" SelectionMode="Multiple"></asp:ListBox>
                                </ItemTemplate>
                                <HeaderStyle HorizontalAlign="Center" Width="80px"></HeaderStyle>
                                <ItemStyle HorizontalAlign="Center" />
                             </telerik:GridTemplateColumn>

                                   <telerik:GridEditCommandColumn ButtonType="ImageButton" HeaderText="Uredi"
                                        UniqueName="EditCommandColumn">
                                        <HeaderStyle HorizontalAlign="Center" Width="50"></HeaderStyle>
                                        <ItemStyle HorizontalAlign="Center" />
                                    </telerik:GridEditCommandColumn>

                                    <telerik:GridButtonColumn ConfirmText="Ali želite res izbrisati naslovnika?\n\nIzbrisali boste tudi vsa planirana sporočila (SMS + e-mail) namenjena temu naslovniku." ButtonType="ImageButton" HeaderText="Izbriši"
                                                CommandName="Delete" UniqueName="DeleteColumn">
                                                <HeaderStyle HorizontalAlign="Center" Width="50"></HeaderStyle>
                                                 <ItemStyle HorizontalAlign="Center" />
                                     </telerik:GridButtonColumn>


                                     <telerik:GridTemplateColumn HeaderText="Pošlji SMS" UniqueName="SMS">
                                     <ItemTemplate>
                                         <asp:CheckBox ID="smscheck" runat="server" Enabled="true" />
                                        </ItemTemplate>
                                        <HeaderStyle HorizontalAlign="Center" Width="80"></HeaderStyle>
                                        <ItemStyle HorizontalAlign="Center" />
                                     </telerik:GridTemplateColumn>

                        </Columns>
                    </telerik:GridTableView>
                </DetailTables>

</MasterTableView>

         <ClientSettings AllowKeyboardNavigation="True">
            <Selecting AllowRowSelect="True" EnableDragToSelectRows="true" />
            <ClientEvents OnRowSelecting="RowSelecting" OnRowSelected="RowSelected" />
             <ClientMessages PagerTooltipFormatString="Stran: <b>{0}</b> od <b>{1}</b> strani" />
            </ClientSettings>


          <SortingSettings SortToolTip="Klikni tukaj za sortiranje"></SortingSettings>
          <StatusBarSettings LoadingText="Nalagam..." ReadyText="Pripravljen" />
          <HierarchySettings CollapseTooltip="Minimiziraj" ExpandTooltip="Maksimiziraj" />
    </telerik:RadGrid>

LP, Luka

Grid

answered on 28 Apr 2009

	Protected Sub RadGrid1_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles RadGrid1.ItemDataBound
	If TypeOf e.Item Is Telerik.Web.UI.GridPagerItem Then
	Dim lblGoToPage As Label = DirectCast(e.Item.FindControl("GoToPageLabel"), Label)
	If Not lblGoToPage Is Nothing Then lblGoToPage.Text = "Seleziona Pagina:"
	Dim lbGoToPage As Button = DirectCast(e.Item.FindControl("GoToPageLinkButton"), Button)
	If Not lbGoToPage Is Nothing Then lbGoToPage.Text = "Visualizza"
	Dim lblPageSize As Label = DirectCast(e.Item.FindControl("ChangePageSizeLabel"), Label)
	If Not lblPageSize Is Nothing Then lblPageSize.Text = "Comunicazioni per Pagina:"
	Dim lbPageSize As Button = DirectCast(e.Item.FindControl("ChangePageSizeLinkButton"), Button)
	If Not lbPageSize Is Nothing Then lbPageSize.Text = "Mostra"
	End If
	End Sub

	protected void btn_Click(object sender, EventArgs e)
	{
	foreach (GridItem commandItem in this.grid1.MasterTableView.GetItems(GridItemType.FilteringItem))
	{
	commandItem.Visible = false;
	}

	grid1.ExportSettings.FileName = "file";
	grid1.ExportSettings.ExportOnlyData = true;
	grid1.ExportSettings.OpenInNewWindow = true;
	grid1.ExportSettings.IgnorePaging = true;
	grid1.MasterTableView.ExportToExcel();
	}