Question

GridView控件事件，如何改变DataField绑定的值

假如if（a==1)
{
gv.DataSource=dt;//dt是一个已知DataTable，select * from Student
gv.Bind();
}
if(a==2)
{
gv.DataSource=dt2;//dt2是一个已知DataTable，select * from Teacher
gv.Bind();
}
我的前台中<asp:BoundField DataField="Sno" HeaderText="学号" >
<HeaderStyle HorizontalAlign="Center" />
</asp:BoundField>

问题出现了dt2中没有Sno，只有Tno，导致绑定出错。请问我该怎么把BoundField DataField="Sno"修改成BoundField DataField="Tno"或者有什么别的方法吗

Answer 1

用隐藏吧protected void Button1_Click(object sender, EventArgs e)
{
GridView1.Columns[1].Visible = true;
GridView1.Columns[2].Visible = false;
} protected void Button2_Click(object sender, EventArgs e)
{
GridView1.Columns[1].Visible = false;
GridView1.Columns[2].Visible = true;
}

Answer 2

改变sql查询的值吧，select Sno as Tno from Teacher

Answer 3

select sno Num from Studentselect tno Num from Teacher这样绑定No这个列名。