Telerik Forums
UI for ASP.NET AJAX Forum
4 answers
386 views
Hi,

I have created a grid based on the demo Grid Programmatic Binding but can not get the grid to expand or collapse.  I added the following code to the pre-render event and the grid opens with the first item expanded and the data is displayed in the detail grid correctly.  But, when I try to collapse the row it will not collapse and none of the other rows will expand. 

Private

 

Sub rgvSecurityGroups_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles rgvSecurityGroups.PreRender
If Not Page.IsPostBack Then
    rgvSecurityGroups.MasterTableView.Items(0).Expanded = True
End If
End Sub

Below is the code for my page.  Thank you for your assistance.

Tracy

 

<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/IPSMaster.Master" CodeBehind="WBC SEC Security Groups.aspx.vb" Inherits="IPS_Gateway.WBC_SEC_Security_Groups" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="act" %>
    
<asp:Content ID="cntMain" ContentPlaceHolderID="cphMainContent" runat="server" >
  
  
<asp:SqlDataSource ID="SQLDS_SecurityGroups"     runat="server"  ConnectionString="<%$ ConnectionStrings:IPSDataConnectionString %>"  
        SelectCommandType="StoredProcedure" SelectCommand="[Security].[DSP_SecurityGroups-SEL-INS-UPD-DEL]"> 
        <SelectParameters>
            <asp:Parameter Name="strCommandType" Type="String" DefaultValue="Select" />
        </SelectParameters>
</asp:SqlDataSource>
  
<asp:SqlDataSource ID="SQLDS_SecurityGroupUsers"     runat="server"  ConnectionString="<%$ ConnectionStrings:IPSDataConnectionString %>"  
        SelectCommandType="StoredProcedure" SelectCommand="[Security].[DSP_SecurityGroupUsers-Select]" >
</asp:SqlDataSource>
  
<asp:panel ID="pnlPage"   runat="server"  SkinId="skn_GPC01_Panel_MainContent">      
  
     <telerik:RadAjaxManager ID="RadAjaxManager2"  runat="server">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="rgvSecurityGroups">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="rgvSecurityGroups" LoadingPanelID="RadAjaxLoadingPanel1" />
                    <telerik:AjaxUpdatedControl ControlID="rwmMessageBox" />
                    <telerik:AjaxUpdatedControl ControlID="rwmSecuritySettings" />
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManager>
    <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" BackgroundPosition="Center"  ZIndex="150"   > 
        <asp:Image ID="imgLoading" runat="server" ImageUrl='<%$Resources:Images, LoadingBlack %>' AlternateText="Loading"   />
    </telerik:RadAjaxLoadingPanel>
    <asp:HiddenField ID="hdfSecurityId" runat="server" />
  
    <asp:panel ID="pnlPageHeader"                runat="server"  cssClass="css_GPC01_Panel_PageHeading" >       
        <asp:Label ID="txtPageTitle"             runat="server"  CssClass="css_GPC01_Label_PageTitle" Text="Security Groups" />   
        <asp:ImageButton ID="ibtPageInformation" runat="server"  SkinID="skn_GPC01_ImageButton_PageInformation"  />
    </asp:panel>    
  
    <asp:Panel ID="pnlPageContent"               runat="server"  CssClass="css_GPC01_Panel_PageContent" >     
        <telerik:RadGrid ID="rgvSecurityGroups"  runat="server"  DataSourceID="SQLDS_SecurityGroups"   
                EnableEmbeddedSkins = "true"    Skin="Black"
                AllowMultiRowSelection="false" 
                AllowAutomaticDeletes="True" 
                AllowAutomaticInserts="True"  
                AllowAutomaticUpdates="True"  
                AllowPaging="True" 
                EnableViewState ="true"                 
                AutoGenerateColumns="False"
                height="560px">
                                  
            <PagerStyle AlwaysVisible="true" Mode="NextPrevAndNumeric" />
            <ClientSettings AllowColumnsReorder="false" EnablePostBackOnRowClick="true" 
                            AllowExpandCollapse="true"  >  
                <Selecting AllowRowSelect="true" />
                <Scrolling AllowScroll="true" UseStaticHeaders="true" />
            </ClientSettings>
            <MasterTableView    DataSourceID="SQLDS_SecurityGroups" DataKeyNames="SecurityID"     
                EditMode="InPlace" CommandItemDisplay="Top"  PageSize="30"   >
                <CommandItemTemplate >
                    <div style="padding: 5px 5px;">
                        <asp:LinkButton ID="lbtAdd"          runat="server" CommandName="InitInsert"     ToolTip ="Add New Group"               Visible='<%# Not rgvSecurityGroups.MasterTableView.IsItemInserted %>'><asp:Image ID="imgAdd" runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images,AddRecord20%>" /> Add </asp:LinkButton>  
                        <asp:LinkButton ID="IbtEdit"         runat="server" CommandName="EditSelected"   ToolTip ="Edit Group"                  Visible='<%# rgvSecurityGroups.EditIndexes.Count = 0 and Not rgvSecurityGroups.MasterTableView.IsItemInserted %>'>          <asp:Image runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images, EditRecord20%>"/> Edit </asp:LinkButton>  
                        <asp:LinkButton ID="IbtCancel"       runat="server" CommandName="CancelAll"      ToolTip ="Cancel Edit/Add"             Visible='<%# rgvSecurityGroups.EditIndexes.Count > 0 Or rgvSecurityGroups.MasterTableView.IsItemInserted %>'><asp:Image ID="imgCancel" runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images,CancelRecord20%>" /> Cancel </asp:LinkButton>  
                        <asp:LinkButton ID="lbtSaveNew"      runat="server" CommandName="PerformInsert"  ToolTip ="Save New Group"              Visible='<%# rgvSecurityGroups.MasterTableView.IsItemInserted%>'><asp:Image ID="imgSaveNew" runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images,SaveRecord20%>" /> Save New</asp:LinkButton>  
                        <asp:LinkButton ID="lbtDelete"       runat="server" CommandName="DeleteSelected" ToolTip ="Delete Group"                Visible='<%# rgvSecurityGroups.EditIndexes.Count = 0 and Not rgvSecurityGroups.MasterTableView.IsItemInserted %>'><asp:Image ID="imgDelete"       runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images,DeleteRecord20%>" />Delete </asp:LinkButton>  
                        <asp:LinkButton ID="lbtSave"         runat="server" CommandName="UpdateEdited"   ToolTip ="Save Changes"                Visible='<%# rgvSecurityGroups.EditIndexes.Count > 0 or rgvSecurityGroups.MasterTableView.IsItemInserted%>'><asp:Image runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images,SaveRecord20%>" />  Update </asp:LinkButton>  
                        <asp:LinkButton ID="ibtSettings"     runat="server" CommandName="ShowSettings"   ToolTip ="Edit/View Security Settings" Visible='<%# rgvSecurityGroups.EditIndexes.Count=0 AND Not rgvSecurityGroups.MasterTableView.IsItemInserted%>'><asp:Image ID="Image1" runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images,SecuritySettings20%>" /> Security Settings  </asp:LinkButton>  
                        <asp:LinkButton ID="lbtRefresh"      runat="server" CommandName="RebindGrid"     ><asp:Image id="imgRefresh" runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$Resources:Images, ReloadBlue16 %>" AlternateText ="Refresh Grid" /></asp:LinkButton>                     
                    </div>
                </CommandItemTemplate>
                <Columns>
                    <telerik:GridBoundColumn DataField="SecurityId"     UniqueName="SecurityID"     HeaderText="Security Id"        HeaderStyle-HorizontalAlign="Left"     HeaderStyle-Width="80px"    ItemStyle-HorizontalAlign="Center"  DataType="System.Int32" ReadOnly="true" />
                    <telerik:GridBoundColumn DataField="SecurityGroup"  UniqueName="SecurityGroup"  HeaderText="Group"              HeaderStyle-HorizontalAlign="Left"     HeaderStyle-Width="200px"   ColumnEditorID ="gtcEditor1"/>
                    <telerik:GridBoundColumn DataField="UserCount"      UniqueName="UserCount"      HeaderText="User Count"         HeaderStyle-HorizontalAlign="Left"     HeaderStyle-Width="80px"    ItemStyle-HorizontalAlign="Center"  DataType="System.Int32" ReadOnly="true" />
                    <telerik:GridBoundColumn DataField="CreatedBy"      UniqueName="CreatedBy"      HeaderText="Created By"         HeaderStyle-HorizontalAlign="Left"     HeaderStyle-Width="130px"   ItemStyle-HorizontalAlign="Left"    ReadOnly="true"  />
                    <telerik:GridBoundColumn DataField="CreatedDate"    UniqueName="CreatedDate"    HeaderText="Created Date"       HeaderStyle-HorizontalAlign="Center"   HeaderStyle-Width="130px"   ItemStyle-HorizontalAlign="Center"  DataType="System.DateTime" DataFormatString="{0:MM/dd/yy h:mm:ss t}"   ReadOnly="true" />
                    <telerik:GridBoundColumn DataField="UpdatedBy"      UniqueName="UpdatedBy"      HeaderText="Updated By"         HeaderStyle-HorizontalAlign="Left"     HeaderStyle-Width="130px"   ItemStyle-HorizontalAlign="Left"    ReadOnly="true" />
                    <telerik:GridBoundColumn DataField="UpdatedDate"    UniqueName="UpdatedDate"    HeaderText="Updated Date"       HeaderStyle-HorizontalAlign="Center"   HeaderStyle-Width="130px"   ItemStyle-HorizontalAlign="Center"  DataType="System.DateTime" DataFormatString="{0:MM/dd/yy h:mm:ss t}" ReadOnly="true" />                           
                </Columns>    
                <DetailTables>
                    <telerik:GridTableView   DataKeyNames="SecurityObject" >
                        <Columns>
                            <telerik:GridBoundColumn DataField="UserId"          UniqueName="UserID"         HeaderText="User Id"           HeaderStyle-HorizontalAlign="Left"     HeaderStyle-Width="50px"    ItemStyle-HorizontalAlign="Center"  ReadOnly="true" DataType="System.Int32"  />
                            <telerik:GridBoundColumn DataField="UserName"        UniqueName="UserName"       HeaderText="User Name"         HeaderStyle-HorizontalAlign="Left"     HeaderStyle-Width="150px"   />
                            <telerik:GridBoundColumn DataField="SecurityObject"  UniqueName="SecurityObject" HeaderText="Security Object"   HeaderStyle-HorizontalAlign="Left"     HeaderStyle-Width="150px"  DataType="System.Int32"  />
                            <telerik:GridBoundColumn DataField="UserLoginId"     UniqueName="UserLoginId"    HeaderText="Login Id"          HeaderStyle-HorizontalAlign="Left"     HeaderStyle-Width="150px"   />
                            <telerik:GridBoundColumn DataField="UserStatus"      UniqueName="UserStatus"     HeaderText="Status" />
                            <telerik:GridBoundColumn DataField="EmployeeStatus"  UniqueName="EmployeeStatus" HeaderText="Employee Status" />
                        </Columns>
                    </telerik:GridTableView>
                </DetailTables>                
            </MasterTableView>
        </telerik:RadGrid>
        <telerik:GridTextBoxColumnEditor ID="gtcEditor1" runat="server" TextBoxStyle-Width="200px" />     
        <telerik:RadWindowManager ID="rwmMessageBox" runat="server" Behaviors="Close, Move"  EnableViewState ="false" Animation="Slide" AnimationDuration="5"  Height="400" Width = "400" VisibleOnPageLoad ="true" DestroyOnClose="true"  Modal="true"   EnableEmbeddedSkins="true" Skin="Black" />
        <telerik:RadWindowManager ID="rwmSecuritySettings" runat="server" Behaviors="Close, Move"  EnableViewState ="false" Animation="Slide" AnimationDuration="5"  Height="700" Width = "835" VisibleOnPageLoad ="true" DestroyOnClose="true"  Modal="true"  Style="z-index:3000"  />
        <br />
    </asp:Panel>
</asp:panel> 
<asp:Panel ID="pnlFooter" runat="server" CssClass="css_GPC01_Panel_Footer">
        <asp:Label ID="lblObjectId"              runat="server"  CssClass="css_GPC01_Label_Tiny" />
</asp:Panel>
</asp:Content>
Private Sub rgvSecurityGroups_DetailTableDataBind(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridDetailTableDataBindEventArgs) Handles rgvSecurityGroups.DetailTableDataBind
       Dim SelectedRow As GridDataItem = CType(e.DetailTableView.ParentItem, GridDataItem)
       Dim intSecurityObject As Int32 = SelectedRow.GetDataKeyValue("SecurityID")
       SQLDS_SecurityGroupUsers.SelectParameters.Clear()
       SQLDS_SecurityGroupUsers.SelectParameters.Add("intObjectId", Convert.ToInt32(intSecurityObject))
       e.DetailTableView.DataSourceID = "SQLDS_SecurityGroupUsers"
   End Sub

Tracy
Top achievements
Rank 1
 answered on 17 Feb 2011
7 answers
224 views
Hi, we have a large dataset of nearly 200 columns by 250 rows. On screen, the grid presentation is normal with a row-per-record as it should be. However, when exported to Excel and opened in Excel 2008, each record shows in two rows with one row being blank. This results in a row count that is 2x what it should be.

When selecting an individual data item in the resulting excel file, two cells are selected.

The data does not appear to be grouped, at least as far as Excel is concerned.

We have attempted a variety of 'tricks' in Excel to remove the extra rows, but none are perfect and some result in lost data.

Is the issue (2 rows in excel) known and if so, how can we resolve this so that ideally, the excel file appears as it does on screen? We are using .net 2 framework and telerik 2010 Q1 (2010.1.309.20) for this application. Thanks.

Daniel
Telerik team
 answered on 17 Feb 2011
9 answers
160 views
I have a hierarchy grid with master and detail grid. I need to be able to insert and update the detail grid. There are 2 checkboxes that if one is checked then the other one should not be checked. How do I validate or make this happen? Please help.
Thanks!
illumination
Top achievements
Rank 2
 answered on 17 Feb 2011
0 answers
74 views
EDITED: Nevermind. Programmer error.
Lorne
Top achievements
Rank 1
 asked on 17 Feb 2011
3 answers
153 views
I just deployed my web app and I am getting javascript errors, when I run it in VS .NET 2010 and on my local machine's IIS it's fine but when I deploy it to our test server I get this error.

"Webpage error details

Message: 'Sys' is undefined
Line: 79
Char: 1
Code: 0

Message: 'Sys' is undefined
Line: 201
Char: 1
Code: 0

"

the offending line is:

<script type="text/javascript">
//<![CDATA[
Sys.WebForms.PageRequestManager._initialize('RadScriptManager1', 'form1', ['trgSpeakersPanel','','trgSponsorsPanel','','tRadAjaxManager1SU',''], [], [], 90, '');
//]]>
</script>

I have searched this topic with no fixes working yet I do know there are legacy apps running on this that use an older version of Telerik controls. I am using VS.NET 2010 and .net framework 4.0.

Thanks
Clark
Top achievements
Rank 1
 answered on 17 Feb 2011
3 answers
327 views
Hi all,

I'd like to display a hierarchical grid - Master/Detail (or parent/child if you will).  I've created a dataset that contains the parent and child records. My dataset only returns columns I want to display...in other words, I don't want to "hard-code" columns in the HTML markup  or in the code behind. I also DON"T want to use any object datasource controls (ie: SQLDataSourceControl). Simply, I want to bind and display whatever data is in the dataset directly to the grid control.

Can you please provide me with the grid HTML and code that will allow me to bind this dataset to a grid?

        public static DataSet GetHierarchicalDataSet()
        {
                DataTable parentTable = GetParentData();  //retrieves parent data from database
                parentTable.TableName = "Parent";
                DataTable childTable = GetChildData();  //retrieves child data from database
                childTable.TableName = "Child"

                DataSet ds = new DataSet();
                ds.Tables.Add(parentTable.Copy());
                ds.Tables.Add(childTable.Copy());

                DataColumn parentColumn = ds.Tables["Parent"].Columns["ParentID"];
                DataColumn childColumn = ds.Tables["Child"].Columns["ParentID"];
                DataRelation relationship = new DataRelation("ParentChild", parentColumn, childColumn);
                ds.Relations.Add(relationship);

                return ds;
        } 





K
Top achievements
Rank 1
 answered on 17 Feb 2011
5 answers
178 views
I have a tabstrip control with 5 tabs and one multiview.

When I execute the client side js to enable and select a specific tab, the view gets selected fine, but the tab header doesn't get selected. During debugging, I have verified that the text coming back is "Sec Ins". I have also verified by the attachment, that before the "tab.enable()" was hit the "enabled" property was "false". After passing that code to enable the tab, you can see it says it's "enabled". Another attachment is how the screen looks after the js funtion is completed as I have explained above. I have also tried the findTabByValue method getting the same results.

How can I enable & select the tab header to correspond to the selected view?

Here is my html: Notice the bolding...
<code>
<telerik:RadTabStrip ID="tsPatientDemographics" runat="server" AutoPostBack="false"
                                                                                    ScrollButtonsPosition="Right" MultiPageID="RadMultiPage1" BackColor="Gray" CausesValidation="False"
                                                                                    Align="Left" Width="100%">
                                                                                    <Tabs>
                                                                                        <telerik:RadTab Text="P<u>a</u>tient" AccessKey="A" Width="60px">
                                                                                        </telerik:RadTab>
                                                                                        <telerik:RadTab Text="G<u>u</u>arantor" AccessKey="U" Width="80px">
                                                                                        </telerik:RadTab>
                                                                                        <telerik:RadTab Text="<u>P</u>ri Ins" AccessKey="P" Width="60px">
                                                                                        </telerik:RadTab>
                                                                                        <telerik:RadTab Text="<u>S</u>ec Ins" AccessKey="S" Value="Sec Ins" Width="60px"
                                                                                            Enabled="false">
                                                                                        </telerik:RadTab>
                                                                                        <telerik:RadTab Text="<u>T</u>er Ins" AccessKey="T" Value="Ter Ins" Width="70px"
                                                                                            Enabled="false">
                                                                                        </telerik:RadTab>
                                                                                    </Tabs>
                                                                                </telerik:RadTabStrip>
                                                                                <telerik:RadMultiPage ID="RadMultiPage1" runat="server" SelectedIndex="0" ScrollBars="None">
                                                                                    <telerik:RadPageView ID="RadPatientInfoView" runat="server" Width="100%" BackColor="LightGray">
                                                                                        <table width="100%" bgcolor="#F6F6F6" cellpadding="0" cellspacing="0">

</code>

Here is my js:
<code>
function selectSecTab() {
                var tabStrip = $find("<%= tsPatientDemographics.ClientID %>");
                var tab = tabStrip.findTabByText("Sec Ins");
                tab.enable();
                tab.select();
               
            }

</code>
Bill
Top achievements
Rank 2
 answered on 17 Feb 2011
2 answers
160 views
I followed the samples of show/hide column using client event, however I get js runtime error on the line "var a=this.get_columns()[b].Display=a" that says "get_column()[...] is null or not an object", i am pretty sure that I passed the right index. Any ideas?

Thanks a lot!

Shannon
Shannnon
Top achievements
Rank 1
 answered on 17 Feb 2011
2 answers
162 views
I have a web form which saves a record to the database via server-side code, but then upon postback, I want to show the RadWindow i created.  I dont want the radwindow to show initially when the page loads.  Its only when the user clicks the Save button on the form, which runs server-side code, but then I need to invoke the RadWindow to show.  How do I do this? 
Dan
Top achievements
Rank 1
 answered on 17 Feb 2011
2 answers
130 views
I've modified an existing (working) ASP webpage by adding auto spellcheck per the example code.  There are two text boxes, one of which is seldom used, so I'd rather spell check them seperately (rather than use ControlsToCheck and getting both at the same time). 

Specifically, I've added two RadSpell controls:

<telerik:RadSpell id="RadSpellRepairOnly" runat="server" controltocheck="RepairTextBox" buttontype="None" IsClientID="true" />
<telerik:RadSpell id="RadSpellInstructionsOnly" runat="server" controltocheck="InstructionsTextBox" buttontype="None" IsClientID="true" />

...two scripts:

function spellCheckRepair() {
GetRadSpell(
'<%= RadSpellRepairOnly.ClientID %>').startSpellCheck();
}

 function spellCheckInstructions() {
GetRadSpell(
'<%= RadSpellInstructionsOnly.ClientID %>').startSpellCheck();
}

 


...and modified the two textboxes accordingly:

<asp:TextBox ID="RepairTextBox" runat="server" Rows="12" Width="100%" TextMode="MultiLine" BorderColor="White" onblur="javascript: spellCheckRepair();"></asp:TextBox>

 <asp:TextBox ID="InstructionsTextBox" runat="server" Rows="6" Width="100%" TextMode="MultiLine" BorderColor="White" onblur="javascript: spellCheckInstructions();"></asp:TextBox>

 


This works, but if I jump between the text boxes more than once I get an 'out of stack space' exception and execution is halted.  Is this not a supported configuration?

 

 

 

Henry
Top achievements
Rank 1
 answered on 17 Feb 2011
Narrow your results
Selected tags
Tags
+? more
Top users last month
Shiori
Top achievements
Rank 2
Iron
Tien
Top achievements
Rank 1
Iron
Robert
Top achievements
Rank 1
Rob
Top achievements
Rank 4
Bronze
Bronze
Iron
Geoff
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Top users last month
Shiori
Top achievements
Rank 2
Iron
Tien
Top achievements
Rank 1
Iron
Robert
Top achievements
Rank 1
Rob
Top achievements
Rank 4
Bronze
Bronze
Iron
Geoff
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?