Click here to Skip to main content
15,890,609 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
XML
<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%@ Register assembly="Trirand.Web" namespace="Trirand.Web.UI.WebControls" tagprefix="cc1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
     <script type="text/javascript">
        function showSubGrids(subgrid_id, row_id) {
            // the "showSubGrid_JQGrid2" function is autogenerated and available globally on the page by the second child grid.
            // Calling it will place the child grid below the parent expanded row and will call the OnDataRequesting event
            // of the child grid, with ID equal to the ID of the parent expanded row
            showSubGrid_JQGrid2(subgrid_id, row_id, "<br><b>Inspection details</b><br><br>", "JQGrid2");
            showSubGrid_JQGrid3(subgrid_id, row_id, "<br><b>Inspection Statuss</b><br><br>", "JQGrid3");
        }
    </script>

</head>
<body>
    <form id="form1" runat="server">
    <div>

        <cc1:JQGrid ID="JQGrid1" runat="server" DataSourceID="SqlDataSource1" >
            <Columns>
                <cc1:JQGridColumn DataField="Inspector_PK">
                </cc1:JQGridColumn>
                <cc1:JQGridColumn DataField="Inspector_FirstName">
                </cc1:JQGridColumn>
                <cc1:JQGridColumn DataField="Inspector_LastName" >
                </cc1:JQGridColumn>
                <cc1:JQGridColumn DataField="Inspector_Zip" >
                </cc1:JQGridColumn>
                <cc1:JQGridColumn DataField="Inspector_Mobile">
                </cc1:JQGridColumn>
            </Columns>
            <ClientSideEvents SubGridRowExpanded="showSubGrids" />
        <HierarchySettings HierarchyMode="Parent" />
        </cc1:JQGrid>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:Windinspection_DEVConnectionString %>"
            SelectCommand="SELECT TOP (20) Inspector_PK, Inspector_FirstName, Inspector_LastName, Inspector_Zip, Inspector_Mobile FROM tblInspector">
        </asp:SqlDataSource>
        <cc1:JQGrid ID="Jqgrid2" runat="server" DataSourceID="SqlDataSource2" >
            <Columns>
                <cc1:JQGridColumn DataField="policynumber">
                </cc1:JQGridColumn>
                <cc1:JQGridColumn DataField="id" >
                </cc1:JQGridColumn>
                <cc1:JQGridColumn DataField="address">
                </cc1:JQGridColumn>
                <cc1:JQGridColumn DataField="phno">
                </cc1:JQGridColumn>
            </Columns>
             <HierarchySettings HierarchyMode="Child" />
        </cc1:JQGrid>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server"
            ConnectionString="<%$ ConnectionStrings:Windinspection_DEVConnectionString %>"
            SelectCommand="SELECT [policynumber], [id], [address], [phno] FROM [InspectionDetails] WHERE ([inspectorfk] = @inspectorfk)">
            <SelectParameters>
            <asp:Parameter Name="Inspector_PK" Type="Int32" />
          </SelectParameters>

        </asp:SqlDataSource>
        <cc1:JQGrid ID="Jqgrid3" runat="server" DataSourceID="SqlDataSource3" >

            <Columns>
                <cc1:JQGridColumn DataField="id">
                </cc1:JQGridColumn>
                <cc1:JQGridColumn DataField="status">
                </cc1:JQGridColumn>
                <cc1:JQGridColumn DataField="status_date">
                </cc1:JQGridColumn>
            </Columns>
             <HierarchySettings HierarchyMode="Child" />
        </cc1:JQGrid>
        <asp:SqlDataSource ID="SqlDataSource3" runat="server"
            ConnectionString="<%$ ConnectionStrings:Windinspection_DEVConnectionString %>"
            SelectCommand="SELECT [id], [status], [status_date] FROM [InspStatus]">
             <SelectParameters>
            <asp:Parameter Name="id" Type="Int32" />
          </SelectParameters>
        </asp:SqlDataSource>
    </div>
        <br />
    <br />

    </form>
</body>
</html>




please help me...
Posted

1 solution

:-) I fixed it.Actually it was my mistake.Because I forgot to add javascript links
XML
<link rel="stylesheet" type="text/css" media="screen" href="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.8.16/themes/redmond/jquery-ui.css" />
<!-- The jQuery UI theme extension jqGrid needs -->
<link rel="stylesheet" type="text/css" media="screen" href="themes/ui.jqgrid.css" />
<!-- jQuery runtime minified -->
<script src="http://ajax.microsoft.com/ajax/jquery/jquery-1.7.1.min.js" type="text/javascript"></script>
<!-- The localization file we need, English in this case -->
<script src="js/trirand/i18n/grid.locale-en.js"type="text/javascript"></script>
<!-- The jqGrid client-side javascript -->
<script src="js/trirand/jquery.jqGrid.min.js" type="text/javascript"></script>
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900