Nested Data

[Guest Liangzai]

I need some help here. Quite confuse here.How to display my customername with this code? I am stuck. It can only show the customer code and not the name... anyone can help?Below is my form: <asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Horizontal" AllowPaging="True" AllowSorting="True" DataSourceID="SqlDataSource1" CellSpacing="3" AutoGenerateColumns="False"> <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" /> <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" /> <Columns> <asp:TemplateField HeaderText="Customer Code"> <ItemTemplate> <asp:Label id="lblcode" Runat="Server" Text='<%# Eval("customercode") %>'/> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="View"> <ItemTemplate> <asp:Button ID="btnEdit" runat="server" Text="+" CommandName="Edit" /> </ItemTemplate> <EditItemTemplate> <asp:Button ID="btnCancel" runat="server" Text="-" CommandName="Cancel" /> <asp:GridView ID="GridView2" runat="server" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Horizontal" DataSourceID="SqlDataSource2" AllowPaging="True" AllowSorting="True" CellSpacing="3" AutoGenerateColumns="False"> <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" /> <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" /> <Columns> <asp:TemplateField HeaderText="Customer Name"> <ItemTemplate> <asp:Label id="lblname" Runat="Server" Text='<%# Eval("customername") %>'/> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="View"> <ItemTemplate> <asp:Button ID="btnEdit2" runat="server" Text="+" CommandName="Edit" /> </ItemTemplate> <EditItemTemplate> <asp:Button ID="btnCancel2" runat="server" Text="-" CommandName="Cancel" /> </EditItemTemplate> </asp:TemplateField> </Columns> <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" /> <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" /> <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" /> <AlternatingRowStyle BackColor="#F7F7F7" /> </asp:GridView> </EditItemTemplate> </asp:TemplateField> </Columns> <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" /> <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" /> <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" /> <AlternatingRowStyle BackColor="#F7F7F7" /> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:hbeConnectionString %>" ProviderName="<%$ ConnectionStrings:hbeConnectionString.ProviderName %>" SelectCommand="SELECT * FROM customerinfo"> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:hbeConnectionString %>" ProviderName="<%$ ConnectionStrings:hbeConnectionString.ProviderName %>" SelectCommand="SELECT * FROM customerinfo WHERE customercode='<%# lblcode.text %>'"> </asp:SqlDataSource>