Second grid does not display any data after deployment

[Ed]

I have a couple pages where only the first grid displays data and second grid says no data to display, I created another simple page pasted below that works from Visual Studio 2022 community but not after I deploy to IIS? What is wrong?

<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="MaintPlayertest2.aspx.vb" Inherits="foosballtournaments.MaintPlayertest2" %>

<%@ Register assembly="Syncfusion.EJ.Web" namespace="Syncfusion.JavaScript.Web" tagprefix="ej" %>

<%@ Register assembly="Syncfusion.EJ" namespace="Syncfusion.JavaScript.Models" tagprefix="ej" %>

<%@ Register Assembly="Syncfusion.EJ" Namespace="Syncfusion.JavaScript.Models" TagPrefix="ej" %>

<%@ Register Assembly="Syncfusion.EJ.Web" Namespace="Syncfusion.JavaScript.Web" TagPrefix="ej" %>

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

    <ej:Grid ID="Grid1" runat="server" CssClass="" DataSourceCachingMode="None" DataSourceID="SqlDataSource1" EnableLoadOnDemand="true" MinWidth="0">

        <Columns>

            <ej:Column AllowEditing="False" DataType="number" Field="player_id" IsIdentity="True" IsPrimaryKey="True">

            </ej:Column>

            <ej:Column DataType="string" Field="first_name">

            </ej:Column>

            <ej:Column DataType="string" Field="middle_name">

            </ej:Column>

            <ej:Column DataType="string" Field="last_name">

            </ej:Column>

            <ej:Column DataType="number" Field="suffix_id">

            </ej:Column>

            <ej:Column DataType="number" Field="gender_id">

            </ej:Column>

            <ej:Column DataType="date" Field="Birth_Dt">

            </ej:Column>

            <ej:Column DataType="string" Field="cellemailnotification">

            </ej:Column>

            <ej:Column DataType="string" Field="emailnotification">

            </ej:Column>

            <ej:Column DataType="string" Field="certified_ref">

            </ej:Column>

            <ej:Column DataType="date" Field="certified_ref_date">

            </ej:Column>

            <ej:Column DataType="date" Field="certified_ref_expires">

            </ej:Column>

            <ej:Column DataType="string" Field="online_userid">

            </ej:Column>

            <ej:Column DataType="string" Field="online_password">

            </ej:Column>

            <ej:Column DataType="string" Field="online_password_locked">

            </ej:Column>

            <ej:Column DataType="number" Field="online_password_tries">

            </ej:Column>

            <ej:Column DataType="date" Field="Create_Dt">

            </ej:Column>

            <ej:Column DataType="string" Field="Create_Userid">

            </ej:Column>

            <ej:Column DataType="date" Field="Update_Dt">

            </ej:Column>

            <ej:Column DataType="string" Field="Update_Userid">

            </ej:Column>

            <ej:Column DataType="string" Field="deleted">

            </ej:Column>

        </Columns>

    </ej:Grid>

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TournamentConnectionString1 %>" DeleteCommand="DELETE FROM [Player] WHERE [player_id] = @player_id" InsertCommand="INSERT INTO [Player] ([first_name], [middle_name], [last_name], [suffix_id], [gender_id], [Birth_Dt], [cellemailnotification], [emailnotification], [certified_ref], [certified_ref_date], [certified_ref_expires], [online_userid], [online_password], [online_password_locked], [online_password_tries], [Create_Dt], [Create_Userid], [Update_Dt], [Update_Userid], [deleted]) VALUES (@first_name, @middle_name, @last_name, @suffix_id, @gender_id, @Birth_Dt, @cellemailnotification, @emailnotification, @certified_ref, @certified_ref_date, @certified_ref_expires, @online_userid, @online_password, @online_password_locked, @online_password_tries, @Create_Dt, @Create_Userid, @Update_Dt, @Update_Userid, @deleted)" SelectCommand="SELECT Top (5) * FROM [Player]" UpdateCommand="UPDATE [Player] SET [first_name] = @first_name, [middle_name] = @middle_name, [last_name] = @last_name, [suffix_id] = @suffix_id, [gender_id] = @gender_id, [Birth_Dt] = @Birth_Dt, [cellemailnotification] = @cellemailnotification, [emailnotification] = @emailnotification, [certified_ref] = @certified_ref, [certified_ref_date] = @certified_ref_date, [certified_ref_expires] = @certified_ref_expires, [online_userid] = @online_userid, [online_password] = @online_password, [online_password_locked] = @online_password_locked, [online_password_tries] = @online_password_tries, [Create_Dt] = @Create_Dt, [Create_Userid] = @Create_Userid, [Update_Dt] = @Update_Dt, [Update_Userid] = @Update_Userid, [deleted] = @deleted WHERE [player_id] = @player_id">

        <DeleteParameters>

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

        </DeleteParameters>

        <InsertParameters>

            <asp:Parameter Name="first_name" Type="String" />

            <asp:Parameter Name="middle_name" Type="String" />

            <asp:Parameter Name="last_name" Type="String" />

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

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

            <asp:Parameter DbType="Date" Name="Birth_Dt" />

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

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

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

            <asp:Parameter DbType="Date" Name="certified_ref_date" />

            <asp:Parameter DbType="Date" Name="certified_ref_expires" />

            <asp:Parameter Name="online_userid" Type="String" />

            <asp:Parameter Name="online_password" Type="String" />

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

            <asp:Parameter Name="online_password_tries" Type="Int16" />

            <asp:Parameter Name="Create_Dt" Type="DateTime" />

            <asp:Parameter Name="Create_Userid" Type="String" />

            <asp:Parameter Name="Update_Dt" Type="DateTime" />

            <asp:Parameter Name="Update_Userid" Type="String" />

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

        </InsertParameters>

        <UpdateParameters>

            <asp:Parameter Name="first_name" Type="String" />

            <asp:Parameter Name="middle_name" Type="String" />

            <asp:Parameter Name="last_name" Type="String" />

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

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

            <asp:Parameter DbType="Date" Name="Birth_Dt" />

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

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

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

            <asp:Parameter DbType="Date" Name="certified_ref_date" />

            <asp:Parameter DbType="Date" Name="certified_ref_expires" />

            <asp:Parameter Name="online_userid" Type="String" />

            <asp:Parameter Name="online_password" Type="String" />

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

            <asp:Parameter Name="online_password_tries" Type="Int16" />

            <asp:Parameter Name="Create_Dt" Type="DateTime" />

            <asp:Parameter Name="Create_Userid" Type="String" />

            <asp:Parameter Name="Update_Dt" Type="DateTime" />

            <asp:Parameter Name="Update_Userid" Type="String" />

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

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

        </UpdateParameters>

    </asp:SqlDataSource>

    <ej:Grid ID="Grid2" runat="server" CssClass="" DataSourceCachingMode="None" DataSourceID="SqlDataSource2" EnableLoadOnDemand="False" MinWidth="0">

        <Columns>

            <ej:Column DataType="number" Field="player_id" IsPrimaryKey="True">

            </ej:Column>

            <ej:Column DataType="number" Field="address_id" IsPrimaryKey="True">

            </ej:Column>

            <ej:Column DataType="string" Field="address1">

            </ej:Column>

            <ej:Column DataType="string" Field="address2">

            </ej:Column>

            <ej:Column DataType="string" Field="city">

            </ej:Column>

            <ej:Column DataType="string" Field="state">

            </ej:Column>

            <ej:Column DataType="string" Field="postal_code">

            </ej:Column>

            <ej:Column DataType="string" Field="country_cd">

            </ej:Column>

        </Columns>

        <ToolbarSettings ShowToolbar="True" ToolbarItems="add,edit,delete,cancel"></ToolbarSettings>

    <EditSettings ShowAddNewRow="false" AllowEditing="True" AllowDeleting="true" AllowAdding="true" AllowEditOnDblClick="true" ShowConfirmDialog="true" ShowDeleteConfirmDialog="true" EditMode="Dialog" />

    </ej:Grid>

    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:TournamentConnectionString1 %>" DeleteCommand="DELETE FROM [Player_Address] WHERE [player_id] = @player_id AND [address_id] = @address_id" InsertCommand="INSERT INTO [Player_Address] ([player_id], [address_id], [address1], [address2], [city], [state], [postal_code], [country_cd]) VALUES (@player_id, @address_id, @address1, @address2, @city, @state, @postal_code, @country_cd)" SelectCommand="SELECT * FROM [Player_Address]" UpdateCommand="UPDATE [Player_Address] SET [address1] = @address1, [address2] = @address2, [city] = @city, [state] = @state, [postal_code] = @postal_code, [country_cd] = @country_cd WHERE [player_id] = @player_id AND [address_id] = @address_id">

        <DeleteParameters>

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

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

        </DeleteParameters>

        <InsertParameters>

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

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

            <asp:Parameter Name="address1" Type="String" />

            <asp:Parameter Name="address2" Type="String" />

            <asp:Parameter Name="city" Type="String" />

            <asp:Parameter Name="state" Type="String" />

            <asp:Parameter Name="postal_code" Type="String" />

            <asp:Parameter Name="country_cd" Type="String" />

        </InsertParameters>

        <UpdateParameters>

            <asp:Parameter Name="address1" Type="String" />

            <asp:Parameter Name="address2" Type="String" />

            <asp:Parameter Name="city" Type="String" />

            <asp:Parameter Name="state" Type="String" />

            <asp:Parameter Name="postal_code" Type="String" />

            <asp:Parameter Name="country_cd" Type="String" />

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

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

        </UpdateParameters>

    </asp:SqlDataSource>

</asp:Content>

[Farveen Sulthana Thameeztheen Basha]

Hi Ed, 

Query#:- Second grid does not display any data after deployment 

We have checked your reported problem by preparing sample but we are unable to replicate the problem at our end. Refer to the sample Link:- 

https://www.syncfusion.com/downloads/support/forum/172014/ze/Sample_(2)-516631756.zip 

Screeenshot:- 

 

We need some more additional details to find the cause of the issue. Share us the following details. 

1. Have you faced the issue only on deploy to IIS alone? If possible, share hosted link.
2. Have you faced any Script Error on console window. If yes please share.
3. Video demo to replicate the issue.

Regards, 

Farveen sulthana T 

[Ed]

Yes only occurs in IIS after deploy I will remove security for the one page so you can see the issue http://www.foosballtournaments.com/Pages/Maintenance/MaintPlayertest2 is the test page in this thread, bottom grid does not display any data but works fine in Visual Studio?

Attachment: screen_shot_of_iis_page_issue_501999d.zip

[Farveen Sulthana Thameeztheen Basha]

Hi Ed, 

We are working on your query with high Priority and update you further details by on or before 24^rd  January 2022. In the meanwhile we will contact you if any details required. 

Regards, 

Farveen sulthana T 

[Farveen Sulthana Thameeztheen Basha]

Hi Ed,  

We appreciate your patience. 

Due to some complexities, we need time to validate this issue at our end and will update further details by 27th January 2022. Until then we value your patience. 

Regards, 

Farveen sulthana T 

[Ed]

Attaching a video where I explain the issue, the sample aspx page I sent simply has a grid at the top and bottom with no code behind but it does not display data when deployed to IIS so I am missing something. Thanks for all your help.

File size zipped is too large but adding share to my gdrive you can view video here:

https://drive.google.com/file/d/1tIDsrJvAFSnwIK3tJFfw0Jl_ob8TK4K6/view?usp=sharing

[Farveen Sulthana Thameeztheen Basha]

Hi Ed,   

We have created a new ticket under your account to follow up with this query. We suggest you to follow up with the ticket for further updates. Please login using the below link.  

https://support.syncfusion.com/support 

  

Regards,  

Farveen sulthana T