gridview动态添加列的问题

Question

两个表
表A
id, studentid, info
表B
studentid, name现在gridview绑定objectdatasource到表A
但现在我需要在gridview中显示name
由于我需要在gridview中进行edit,delete操作，所以我想动态的吧name列添加进gridview
该如何做
谢谢了

Answer 1

<asp:GridView ID="GridView1" runat="server" CellPadding="4" DataSourceID="SqlDataSource1"
            ForeColor="#333333" GridLines="None" AutoGenerateColumns="False" PageSize="20" Width ="100%" AllowPaging="True" AllowSorting="True"  DataMember="DefaultView" >
            <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" Width ="100%" />
            <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />            <Columns>
                <asp:TemplateField HeaderText="选择">
                    <ItemTemplate>
                        <asp:CheckBox ID="chkSelect" runat="server" ></asp:CheckBox>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="id" HeaderText="序号" />
                <asp:BoundField DataField ="studentid" HeaderText ="学号" />
                <asp:BoundField DataField="name" HeaderText="姓名" />
             </Columns>
            <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView>

Answer 2

TableCell cl = new TableCell();
cl.Text = Name;
RoleGrid.Rows[0].Cells.Add(cl);

Answer 3

在select中用join把两个表连起来，至于insert/update/delete则需要你自己写代码同时更新两表了。