Telerik Forums
UI for ASP.NET AJAX Forum
6 answers
219 views
Hello everyone, I've ha this problem for a few hrs now and still can't resolve it. I have a Master - Detail grid and one particular field in the detail grid does not get updated whereas the rest all get updated correctly. The field that is not gettting updated is the "PermissionID" field found in the 2nd level detail grid:

Here is the aspx code:

<telerik:RadGrid ID="gridCompanies" runat="server" AllowFilteringByColumn="True"

        AllowPaging="True" AllowSorting="True" DataSourceID="dsCompanies" GridLines="None"

        ShowGroupPanel="True" Skin="Office2007" ShowStatusBar="True"

        AllowAutomaticUpdates="True" AllowAutomaticInserts="True" AllowAutomaticDeletes="True">

       

        <AlternatingItemStyle BackColor="#E6E6E6" Font-Bold="False" Font-Italic="False"

        Font-Overline="False" Font-Strikeout="False" Font-Underline="False"

        Wrap="True" />

       

        <PagerStyle Mode="NextPrevAndNumeric" />

   

        <MasterTableView Name="Master" AllowAutomaticUpdates="True" AllowAutomaticInserts="True" CommandItemDisplay="Top" AutoGenerateColumns="False" DataKeyNames="CompanyID" DataSourceID="dsCompanies">

           

            <RowIndicatorColumn>

            <HeaderStyle Width="20px"></HeaderStyle>

            </RowIndicatorColumn>

 

            <DetailTables>

                <telerik:GridTableView Name="Detail" CommandItemDisplay="Top" DataKeyNames="CompanyUserID"

                    DataSourceID="dsCompanyUsers" AllowPaging="true" AllowSorting="true"

                    AllowFilteringByColumn="False" AutoGenerateColumns="false" Width="100%"

                    AllowAutomaticDeletes="True" AllowAutomaticInserts="False" AllowAutomaticUpdates="True">

                    <RowIndicatorColumn>

                        <HeaderStyle Width="20px" />

                    </RowIndicatorColumn>

                    <ParentTableRelation>

                        <telerik:GridRelationFields DetailKeyField="CompanyUserID"

                            MasterKeyField="CompanyUserID" />

                    </ParentTableRelation>

                    <ExpandCollapseColumn>

                        <HeaderStyle Width="20px" />

                    </ExpandCollapseColumn>

 

                    <Columns>

                        <telerik:GridEditCommandColumn UniqueName="EditCommandColumn2">

                            <HeaderStyle Width="3%"></HeaderStyle>

                            <ItemStyle Width="3%"></ItemStyle>

                        </telerik:GridEditCommandColumn>

                        <telerik:GridBoundColumn DataField="CompanyID" DataType="System.Int32"

                            HeaderText="CompanyID" Display="false" ReadOnly="True" SortExpression="CompanyID" UniqueName="CompanyID">

                        </telerik:GridBoundColumn>

                        <telerik:GridBoundColumn DataField="CompanyUserID" HeaderText="CompanyUserID"

                            SortExpression="CompanyUserID" Display="false" ReadOnly="True" UniqueName="CompanyUserID" DataType="System.Int32">

                        </telerik:GridBoundColumn>

                        <telerik:GridBoundColumn DataField="UserID" HeaderText="UserID"

                            SortExpression="UserID" UniqueName="UserID" Display="False" ReadOnly="True" DataType="System.Int32">

                        </telerik:GridBoundColumn>

                        <telerik:GridBoundColumn DataField="UserPermissionID" HeaderText="UserPermissionID"

                            SortExpression="UserPermissionID" UniqueName="UserPermissionID" Display="False" ReadOnly="True" DataType="System.Int32">

                        </telerik:GridBoundColumn>

                        <telerik:GridBoundColumn DataField="CompanyUserFName" HeaderText="First Name"

                            SortExpression="CompanyUserFName" UniqueName="CompanyUserFName">

                        </telerik:GridBoundColumn>

                        <telerik:GridBoundColumn DataField="CompanyUserLName" HeaderText="Last Name"

                            SortExpression="CompanyUserLName" UniqueName="CompanyUserLName">

                        </telerik:GridBoundColumn>

                        <telerik:GridBoundColumn DataField="CompanyUserTitle"

                            HeaderText="Title" SortExpression="CompanyUserTitle"

                            UniqueName="CompanyUserTitle">

                        </telerik:GridBoundColumn>

                        <telerik:GridBoundColumn DataField="CompanyUserEmail" HeaderText="Email"

                            SortExpression="CompanyUserEmail" UniqueName="CompanyUserEmail">

                        </telerik:GridBoundColumn>

                        <telerik:GridBoundColumn DataField="CompanyUserTel"

                            HeaderText="Tel." SortExpression="CompanyUserTel"

                            UniqueName="CompanyUserTel">

                        </telerik:GridBoundColumn>

                        <telerik:GridBoundColumn DataField="CompanyUserTelExt" HeaderText="Ext."

                            SortExpression="CompanyUserTelExt" UniqueName="CompanyUserTelExt">

                        </telerik:GridBoundColumn>

                        <telerik:GridBoundColumn DataField="CompanyUserCell" HeaderText="Cell"

                            SortExpression="CompanyUserCell" UniqueName="CompanyUserCell">

                        </telerik:GridBoundColumn>

                        <telerik:GridDropDownColumn DataField="PermissionID" DataSourceID="dsCompanyUsersPerms"

                            HeaderText="Permission" ListTextField="PermissionName" ListValueField="PermissionID"

                            UniqueName="PermissionID">

                        </telerik:GridDropDownColumn>

                        <telerik:GridCheckBoxColumn DataField="UserActive" HeaderText="Active"

                            SortExpression="UserActive" UniqueName="UserActive">

                            <HeaderStyle Width="5%"></HeaderStyle>

                            <ItemStyle Width="5%"></ItemStyle>

                        </telerik:GridCheckBoxColumn>

                    </Columns>

                </telerik:GridTableView>

            </DetailTables>

 

            <ExpandCollapseColumn>

            <HeaderStyle Width="20px"></HeaderStyle>

            </ExpandCollapseColumn>

           

            <Columns>

                <telerik:GridEditCommandColumn UniqueName="EditCommandColumn">

                    <HeaderStyle Width="3%"></HeaderStyle>

                    <ItemStyle Width="3%"></ItemStyle>

                </telerik:GridEditCommandColumn>

                <telerik:GridBoundColumn DataField="CompanyID" DataType="System.Int32"

                    HeaderText="CompanyID" ReadOnly="True" SortExpression="CompanyID"

                    UniqueName="CompanyID" Display="false">

                </telerik:GridBoundColumn>

                <telerik:GridDropDownColumn DataField="CountryID" DataSourceID="dsCountry"

                    HeaderText="Country" ListTextField="CountryName" ListValueField="CountryID"

                    UniqueName="CountryID">

                </telerik:GridDropDownColumn>

                <telerik:GridDropDownColumn DataField="ProvinceID" DataSourceID="dsProvince"

                    HeaderText="Province" ListTextField="ProvinceName" ListValueField="ProvinceID"

                    UniqueName="ProvinceID">

                </telerik:GridDropDownColumn>

                <telerik:GridBoundColumn DataField="CompanyName" HeaderText="Name"

                    SortExpression="CompanyName" UniqueName="CompanyName">

                </telerik:GridBoundColumn>

                <telerik:GridBoundColumn DataField="CompanyAddress" HeaderText="Address"

                    SortExpression="CompanyAddress" UniqueName="CompanyAddress">

                </telerik:GridBoundColumn>

                <telerik:GridBoundColumn DataField="CompanyCity" HeaderText="City"

                    SortExpression="CompanyCity" UniqueName="CompanyCity">

                </telerik:GridBoundColumn>

                <telerik:GridBoundColumn DataField="CompanyTel" HeaderText="Tel"

                    SortExpression="CompanyTel" UniqueName="CompanyTel">

                </telerik:GridBoundColumn>

                <telerik:GridBoundColumn DataField="CompanyTelAreaCode"

                    HeaderText="Tel Area Code" SortExpression="CompanyTelAreaCode"

                    UniqueName="CompanyTelAreaCode">

                </telerik:GridBoundColumn>

                <telerik:GridBoundColumn DataField="CompanyFax" HeaderText="Fax"

                    SortExpression="CompanyFax" UniqueName="CompanyFax">

                </telerik:GridBoundColumn>

                <telerik:GridBoundColumn DataField="CompanyFaxAreaCode"

                    HeaderText="Fax Area Code" SortExpression="CompanyFaxAreaCode"

                    UniqueName="CompanyFaxAreaCode">

                </telerik:GridBoundColumn>

                <telerik:GridBoundColumn DataField="CompanyDomain" HeaderText="Domain"

                    SortExpression="CompanyDomain" UniqueName="CompanyDomain">

                </telerik:GridBoundColumn>

            </Columns>

 

            <EditFormSettings>

            <EditColumn UniqueName="EditCommandColumn1"></EditColumn>

            </EditFormSettings>

 

            <PagerStyle Mode="NextPrevAndNumeric" />

       

        </MasterTableView>

 

        <ClientSettings AllowDragToGroup="True">

        </ClientSettings>

 

        <FilterMenu EnableTheming="True" Skin="Office2007">

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

        </FilterMenu>

       

    </telerik:RadGrid>

   

    <asp:SqlDataSource ID="dsCompanies" runat="server"

        ConnectionString="<%$ ConnectionStrings:VentrolSecurityConnectionString %>"

        InsertCommand="spCreateCompany" InsertCommandType="StoredProcedure"

        SelectCommand="spGetCompanies" SelectCommandType="StoredProcedure"

        UpdateCommand="spUpdateCompany" UpdateCommandType="StoredProcedure">

        <UpdateParameters>

            <asp:Parameter Name="CompanyID" Type="Int32" />

            <asp:Parameter Name="CountryID" Type="Int32" />

            <asp:Parameter Name="ProvinceID" Type="Int32" />

            <asp:Parameter Name="CompanyName" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyAddress" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyCity" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyTel" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyTelAreaCode" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyFax" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyFaxAreaCode" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyDomain" Type="String" ConvertEmptyStringToNull="true" />

        </UpdateParameters>

        <InsertParameters>

            <asp:Parameter Name="CountryID" Type="Int32" />

            <asp:Parameter Name="ProvinceID" Type="Int32" />

            <asp:Parameter Name="CompanyName" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyAddress" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyCity" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyTel" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyTelAreaCode" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyFax" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyFaxAreaCode" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyDomain" Type="String" ConvertEmptyStringToNull="true" />

        </InsertParameters>

    </asp:SqlDataSource>

   

    <asp:SqlDataSource ID="dsCompanyUsers" runat="server"

        ConnectionString="<%$ ConnectionStrings:VentrolSecurityConnectionString %>"

        SelectCommand="spGetCompanyUsers" SelectCommandType="StoredProcedure"

        UpdateCommand="spUpdateCompanyUser" UpdateCommandType="StoredProcedure">

        <SelectParameters>

            <asp:SessionParameter Name="CompanyID" SessionField="CompanyID" Type="Int32" />

        </SelectParameters>

        <UpdateParameters>

            <asp:Parameter Name="CompanyID" Type="Int32" />

            <asp:Parameter Name="UserID" Type="Int32" />

            <asp:Parameter Name="UserPermissionID" Type="Int32" />

            <asp:Parameter Name="CompanyUserID" Type="Int32" />

            <asp:Parameter Name="CompanyUserFName" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyUserLName" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyUserTitle" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyUserEmail" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyUserTel" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyUserTelExt" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="CompanyUserCell" Type="String" ConvertEmptyStringToNull="true" />

            <asp:Parameter Name="PermissionID" Type="Int32" />

            <asp:Parameter Name="UserActive" Type="Boolean" />

        </UpdateParameters>

    </asp:SqlDataSource>

   

    <asp:SqlDataSource ID="dsCompanyUsersPerms" runat="server"

        ConnectionString="<%$ ConnectionStrings:VentrolSecurityConnectionString %>"

        SelectCommand="spGetCompanyUsersPerms" SelectCommandType="StoredProcedure">

    </asp:SqlDataSource>

   

    <asp:SqlDataSource ID="dsProvince" runat="server"

        ConnectionString="<%$ ConnectionStrings:VentrolSecurityConnectionString %>"

        SelectCommand="spGetAllProvinces" SelectCommandType="StoredProcedure">

    </asp:SqlDataSource>

    <asp:SqlDataSource ID="dsCountry" runat="server"

        ConnectionString="<%$ ConnectionStrings:VentrolSecurityConnectionString %>"

        SelectCommand="spGetCountries" SelectCommandType="StoredProcedure">

    </asp:SqlDataSource>

    

    <telerik:RadAjaxManagerProxy ID="ajmProxy" runat="server" >

        <AjaxSettings>

            <telerik:AjaxSetting AjaxControlID="gridCompanies">

                <UpdatedControls>

                    <telerik:AjaxUpdatedControl ControlID="gridCompanies" />

                </UpdatedControls>

            </telerik:AjaxSetting>

        </AjaxSettings>

    </telerik:RadAjaxManagerProxy>

Here are the stored procedures for the detail grid:

ALTER

PROCEDURE [dbo].[spUpdateCompanyUser]

-- Add the parameters for the stored procedure here
@CompanyID int,
@UserID int,
@UserPermissionID int,
@CompanyUserID int,
@CompanyUserFName nvarchar(50),
@CompanyUserLName nvarchar(50),
@CompanyUserTitle nvarchar(50),
@CompanyUserEmail nvarchar(50),
@CompanyUserTel nvarchar(50),
@CompanyUserTelExt nvarchar(50),
@CompanyUserCell nvarchar(50),
@PermissionID int,
@UserActive bit
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
-- Update Company User
UPDATE tbl_secure_Company_User
SET CompanyUserFName = @CompanyUserFName,
CompanyUserLName = @CompanyUserLName,
CompanyUserTitle = @CompanyUserTitle,
CompanyUserEmail = @CompanyUserEmail,
CompanyUserTel = @CompanyUserTel,
CompanyUserTelExt = @CompanyUserTelExt,
CompanyUserCell = @CompanyUserCell
WHERE CompanyUserID = @CompanyUserID

-- Update Company User Permission
EXEC spUpdateUserPerm @UserPermissionID,@PermissionID
END

------------------------------------------------------------

ALTER

PROCEDURE [dbo].[spUpdateUserPerm] -- Add the parameters for the stored procedure here
@UserPermissionID int,
@PermissionID int
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
UPDATE tbl_secure_User_Permission
SET PermissionID = @PermissionID
WHERE UserPermissionID = @UserPermissionID
END

When I execute the stored procedures from within SQL management studio it all works fine.

Please if any one can help me it would be fantastic.

Thanks in advance, much appreciation.

Reda.

Christopher Lee
Top achievements
Rank 1
 answered on 31 Oct 2013
2 answers
108 views
Hi,

Actually, the defaut is 'None'

I try to find a setting to set SelectionOnFocus="SelectAll" by defaut for all input into my application. Is it possible without parse all webpage to make manually the change?

ty
Allin
Top achievements
Rank 1
 answered on 31 Oct 2013
2 answers
171 views
Hello All,
             I am trying to get the page index and then populate the radgrid with the corresponding page number. But, my NeedDataSource event fires before PageIndexChanged event, which defeats the purpose.  
The following link address the issue but, I cannot do the same.
http://www.telerik.com/community/forums/aspnet/grid/needdatasource-being-called-before-pageindexchanged.aspx

Here is my RadGrid Defination
<telerik:RadGrid runat="server" ID="RadGrid1" AllowPaging="True"
AllowSorting="true" OnNeedDataSource="RadGrid1DataSource" skin="WebBlue"
AllowMultiRowSelection="true" EnableLinqExpressions="False" PageSize="25"
OnPageIndexChanged="RadGrid1_PageIndexChanged" DataSourcePersistenceMode ="ViewState"
EnableViewState="false">
 
    <mastertableview autogeneratecolumns="false" onneeddatasource="RadGrid1DataSource" autogeneratedeletecolumn="true" ShowFilterIcon="false" AllowMultiRowSelection="true">
             
        <columns>
                 
            <telerik:GridClientSelectColumn UniqueName="ClientSelectColumn">
            </telerik:GridClientSelectColumn>
       
 
     </columns>
 
     </mastertableview>
     <ClientSettings EnableRowHoverStyle="true">
            <Selecting AllowRowSelect="True" ></Selecting>
        </ClientSettings>
 
</telerik:RadGrid>
I hope there is some solution this problem. 

Thank you
Smart
Top achievements
Rank 1
 answered on 31 Oct 2013
2 answers
229 views
I have an app using the RadTabStrip.  On my Windows 7 development machine, while testing the functionality of the RadTabStrip locally everything seems to be working properly.  I deploy to the test server and test from my Windows 7 & IE 8 machine and everything seems to be working properly. 

I also have an XP & IE 8 development machine, while testing the functionality of the RadTabStrip locally everything seems to be working properly.  When I test the app on the test server from the XP & IE 8 machine, the tabs don't maintain focus and turn white when I click on them.  Sometimes I get redirected to a different tab than I clicked on. 

Is there any chance this could be an IIS configuration setting since it runs fine locally?

Here is a short video reproducing the issue.

http://screencast.com/t/V00Y8GOJ

Thanks,

Rob
Kate
Telerik team
 answered on 31 Oct 2013
1 answer
59 views
Hello,

Following directions indicated in the thread Customize ImageManager, I have modified the FileBrowser.ascx control/dialog file so that it has the following values for VisibleControls: ContextMenus, Grid, Toolbar.

The goal was to have the left side of the ImageManager display the existing images only as a grid, not as a tree or as a list.  Furthermore, I do not want the list option is available within the toolbar.

This worked perfectly.

However, when I try to use the FlashManager or the MediaManager, it shows as a list.  Furthermore, the grid and list buttons/options in the toolbar are not available.  Consequently, only the list view is available to the user.  This is not desired.  I need to have the grid displayed as the only available view...just like in the ImageManager.

I am using version 2013.2.717.35.

Am I missing something?

Thank you,
-Arizona
Ianko
Telerik team
 answered on 31 Oct 2013
3 answers
98 views
Is there a way to not show the "HD" symbol on the toolbar?
Jerry Jansen
Top achievements
Rank 1
 answered on 31 Oct 2013
1 answer
107 views
When i init ajaxmanager ajaxRequest from client side radprogressmanager starts its nonstop progress callbacks and overloads IIS. Please find the attached code to reproduce the issue. Run App and run chrome/ firefox debugger, wait for 2 mins for timer to init ajax request as required and then you can see radprogress nonstop callbacks.
  Code : RadProgressManagerIssue
Plamen
Telerik team
 answered on 31 Oct 2013
3 answers
230 views
Hello Support,

we are having a problem with content pasted in (Editor). Spaces seem to be randomly removed.

The problem can be duplicated in your demos.

If I copy and paste the following text (which was copy/pasted from "http://simple.wikipedia.org/wiki/Paragraph"):

"A paragraph is a group of words put together to form a group that is usually longer than a sentence. Paragraphs are often made up of many sentences. They are usually between four to eight sentences. Paragraphs can begin with an indentation (about five spaces), or by missing a line out, and then starting again; this makes telling when one paragraph ends and another begins easier."

If I paste it into my editor (or the demo @ http://demos.telerik.com/aspnet-ajax/editor/examples/default/defaultcs.aspx) it randomly removes spaces, notably in my example between the words "many sentences" .  It turns to "manysentences

The editor on your demo asks me if I want to "clean word formatting".  If I say yes, the spacing problem exists."  
Ianko
Telerik team
 answered on 31 Oct 2013
0 answers
97 views
Hi. I have a problem with modalpopup. I try to do thing like this. I set modalPopup.OpenerElementID :

modalPopup.OpenerElementID = btngetReport.ClientID;

This code works. On button click event, I control a value is null or not. If value is null, modalpopup is not hown, else modalpopup will be shown. But I can not do this.

I try a code on button click like below:

......
.....
if(val==null)
modalPopup.Visible = false;

How can I do this? Thanks in advance..


Saadettin
Top achievements
Rank 1
 asked on 31 Oct 2013
1 answer
107 views
We have radgrid on many pages of our site and are using the export to PDF, XLS, and CSV buttons. Telerik is placing those icons within the  <table> tags, which is generating a 508 violation. How can we move those controls outside of the <table> tags?
Daniel
Telerik team
 answered on 31 Oct 2013
Narrow your results
Selected tags
Tags
+? more
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?