<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>