Gridview over gridview problem!!

May 17 2010 3:47 AM
Good afternoon. 
I've already posted question about gridview over gridview problem, one member suggested watching tutorial and I did. The instructions are well done also but my "insider gridview" doesn't appear in my "outsider" gridview. Where did I go wrong?
 here's my code in .aspx:

 <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:Job Assign %>" 
            OldValuesParameterFormatString="original_{0}" 
            
            SelectCommand="SELECT [Job_No], [Assign_Status] FROM [JOB_ASSIGN]">
        </asp:SqlDataSource>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            DataSourceID="SqlDataSource1" DataKeyNames="Job_No">
            <Columns>
                <asp:BoundField DataField="Job_No" HeaderText="Job_No" 
                    SortExpression="Job_No" />
                <asp:BoundField DataField="Assign_Status" HeaderText="Assign_Status" 
                    SortExpression="Assign_Status" />
                <asp:TemplateField HeaderText="Details">
                    <ItemTemplate>
                        <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
                            DataSourceID="SqlDataSource1">
                            <Columns>
                                <asp:BoundField DataField="JO_DateRequest" HeaderText="JO_DateRequest" 
                                    SortExpression="JO_DateRequest" />
                                <asp:BoundField DataField="JO_Type" HeaderText="JO_Type" 
                                    SortExpression="JO_Type" />
                                <asp:BoundField DataField="JO_Desc" HeaderText="JO_Desc" 
                                    SortExpression="JO_Desc" />
                            </Columns>
                        </asp:GridView>
                        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                            ConnectionString="<%$ ConnectionStrings:Job Requests %>" 
                            SelectCommand="SELECT [JO_DateRequest], [JO_Type], [JO_Desc] FROM [JOB_SUBMIT] WHERE ([Job_No] = @Job_No)">
                            <SelectParameters>
                                <asp:Parameter Name="Job_No" Type="Int64" />
                            </SelectParameters>
                        </asp:SqlDataSource>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>

*outsider gridview contains: Job_No, Assign_Status and column Details(that contains the insider column)
*insider column contains: date_request, Job_type and Job_description
*I'm using C#
*and Ms Sql 

thank you in advance :)

Answers (2)