请教GridView动态添加，动态添加数据。

[yangfan270]

[code=C#]前台代码：
<asp:GridView ID="GvData" Width="100%" runat="server" AutoGenerateColumns="False"
CssClass="gridview" EmptyDataText="没有数据" OnRowDataBound="GvData_RowDataBound"
HorizontalAlign="Center">
<RowStyle Wrap="false" Height="25px" />
<PagerSettings Visible="False" />
<Columns>
<asp:TemplateField HeaderText="选择" HeaderStyle-Wrap="False"><ItemTemplate>
<asp:CheckBox ID="chkDelete" runat="server" />
</ItemTemplate>
<ItemStyle Width="40px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="操作" HeaderStyle-Wrap="False" ItemStyle-Wrap="False">
<ItemTemplate>
<asp:LinkButton ID="lnkbtnEdit" CssClass="lnkbtn" runat="server" CommandArgument='<%#Eval("Buss_ID")+"|"+Eval("guestid") %>' OnClick="lnkbtnEdit_Click" >查看详情</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>

<asp:BoundField DataField="Buss_ID" HeaderText="业务Id" ItemStyle-Wrap="False" HeaderStyle-Wrap="False">
<ItemStyle Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="Buss_num" HeaderText="业务编号" ItemStyle-Wrap="False" HeaderStyle-Wrap="False">
<ItemStyle Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="GuestName" HeaderText="客户名称" ItemStyle-Wrap="False" HeaderStyle-Wrap="False">
<ItemStyle Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="Phone" HeaderText="电话" ItemStyle-Wrap="False" HeaderStyle-Wrap="False">
<ItemStyle Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="Province" HeaderText="省" ItemStyle-Wrap="False" HeaderStyle-Wrap="False">
<ItemStyle Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="City" HeaderText="市" ItemStyle-Wrap="False" HeaderStyle-Wrap="False">
<ItemStyle Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="countStock" HeaderText="跟进" ItemStyle-Wrap="False" HeaderStyle-Wrap="False">
<ItemStyle Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="Buss_sata" HeaderText="状态" ItemStyle-Wrap="False" HeaderStyle-Wrap="False">
<ItemStyle Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="countvisit" HeaderText="回访" ItemStyle-Wrap="False" HeaderStyle-Wrap="False">
<ItemStyle Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="Buss_pepo" HeaderText="受理人" ItemStyle-Wrap="False" HeaderStyle-Wrap="False">
<ItemStyle Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="Buss_data" HeaderText="受理时间" ItemStyle-Wrap="False" HeaderStyle-Wrap="False">

<ItemStyle Wrap="False" />
</asp:BoundField>

</Columns>
<RowStyle HorizontalAlign="Center" />
<EmptyDataRowStyle ForeColor="Red" HorizontalAlign="Center" />
</asp:GridView>
后台代码：
protected void btnSelec_Click(object sender, EventArgs e)
{
if(Busstype.SelectedValue=="")
{
ClientScript.RegisterStartupScript(typeof(Page), "aa", "alert('请选择业务类型！');", true);
}
else
{
if (GvData.Columns.Count > 13)
{
for (int i = 0; i < (GvData.Columns.Count - 13); i++)
{
GvData.Columns.Remove(GvData.Columns[13 + i]);
}
}
string busr = Busstype.SelectedValue;
string search = "";
string sql = "select b.*,g.guestid,g.guestname,g.phone,g.province,g.city,(SELECT COUNT(1) FROM Gj_info WHERE Gj_info.B_id = b.Buss_ID) AS countStock,(SELECT COUNT(1) FROM V_visitwork WHERE V_visitwork.v_buss = b.Buss_ID) AS countvisit from C_Buss as b join CS_Guest as g on b.Buss_guestid=g.guestid where Buss_type_id="+busr+"";
if (!string.IsNullOrEmpty(Datastar.Text.Trim()) && !string.IsNullOrEmpty(Dataend.Text.Trim()))
{
sql += " and Buss_data >='" + Common.FormatParameter(Datastar.Text) + " 00:00:00' and Buss_data<='" + Common.FormatParameter(Dataend.Text) + " 23:59:59'";
search += "&Datastar=" + Datastar.Text + "'&Dataend='" + Dataend.Text + "'";
}
if (!string.IsNullOrEmpty(Buss_guestname.Text.Trim()))
{
search += "&Buss_guestname=" + Buss_guestname.Text;
sql += " and b.GuestName='"+Buss_guestname.Text.Trim()+"'";
}
if(Buss_sata.SelectedValue != "")
{
search += "&Buss_sata=" + Buss_sata.SelectedValue;
sql += " and B_sata='"+Buss_sata.SelectedValue+"'";
}
if (!string.IsNullOrEmpty(Buss_phone.Text.Trim()))
{

search += "&Buss_phone=" + Buss_phone.Text;
sql += " and b.Phone='" + Buss_phone.Text.Trim() + "'";
}
if (Buss_A.SelectedValue != "")
{
search += "&Buss_qus=" + Buss_A.SelectedValue;
sql += " and (select Buss_Value_id from Buss_Result where Buss_ID=b.Buss_ID and Buss_Param_ID='" + DropDownList1.SelectedValue + "')='" + Buss_A.SelectedValue + "'";
}
if (Buss_B.SelectedValue != "")
{
search += "&Buss_zqus=" + Buss_B.SelectedValue;
sql += " and (select Buss_Value_id from Buss_Result where Buss_ID=b.Buss_ID and Buss_Param_ID='" + DropDownList2.SelectedValue + "')='" + Buss_B.SelectedValue + "'";
}
if (Buss_C.SelectedValue != "")
{
search += "&Buss_type=" + Buss_C.SelectedValue;
sql += " and (select Buss_Value_id from Buss_Result where Buss_ID=b.Buss_ID and Buss_Param_ID='" + DropDownList3.SelectedValue + "')='" + Buss_C.SelectedValue + "'";
}
if (Buss_D.SelectedValue != "")
{
search += "&Buss_ztype=" + Buss_D.SelectedValue;
sql += " and (select Buss_Value_id from Buss_Result where Buss_ID=b.Buss_ID and Buss_Param_ID='" + DropDownList4.SelectedValue + "')='" + Buss_D.SelectedValue + "'";
}
sql += " ORDER BY Buss_data DESC";
string Buss_id = Busstype.SelectedValue;
ZSql zs = new ZSql();
zs.Open("select * from C_Buss_param where Buss_type_id='" + Buss_id + "'");
if (zs.m_table.Rows.Count > 0)
{

for (int i = 0; i < zs.m_table.Rows.Count; i++)
{
string Gcallname = f.GetTableValue("C_Buss_param", "Buss_Param_text", "Buss_Param_ID='" + zs.m_table.Rows[i]["Buss_Param_ID"].ToString() + "'");
BoundField NewBoundField = new System.Web.UI.WebControls.BoundField();
NewBoundField.HeaderText = Gcallname;
NewBoundField.ItemStyle.Wrap = false;
NewBoundField.HeaderStyle.Wrap = false;
GvData.Columns.Add(NewBoundField);
}

}
PageNavigator1.Url = Hidurl.Value + search;
PageNavigator1.Total = 1;
PageNavigator1.Query = sql;
}


}

[yangfan270]

protected void GvData_RowDataBound(object sender, GridViewRowEventArgs e)
{

if (e.Row.RowType == DataControlRowType.DataRow)
{
string ProNum = DataBinder.Eval(e.Row.DataItem, "Buss_sata").ToString();
string Bussid = DataBinder.Eval(e.Row.DataItem, "Buss_ID").ToString();
if (Convert.ToInt32(ProNum) == 0)
{
e.Row.Cells[9].Text = "已下单";
}
ZSql zs = new ZSql();
zs.Open("select * from Buss_Result where Buss_ID='" + Bussid + "'");
if (zs.m_table.Rows.Count > 0)
{
for (int i = 0; i < zs.m_table.Rows.Count; i++)
{
string B_type = f.GetTableValue("C_Buss_param", "Buss_Param_type", "Buss_Param_ID='" + zs.m_table.Rows[i]["Buss_Param_ID"].ToString() + "'");
switch (B_type)
{
case "1":
e.Row.Cells[13 + i].Text = zs.m_table.Rows[i]["Buss_Value_string"].ToString();
break;
case "2":
if (!string.IsNullOrEmpty(zs.m_table.Rows[i]["Buss_Value_id"].ToString()))
{
e.Row.Cells[13 + i].Text = f.GetTableValue("Buss_Value", "Buss_Value", "Buss_Value_id='" + zs.m_table.Rows[i]["Buss_Value_id"] + "'");
}
break;
case "3":
if (!string.IsNullOrEmpty(zs.m_table.Rows[i]["Buss_Value_id"].ToString()))
{
ZSql Tsql = new ZSql();
Tsql.Open("select Buss_Value from Buss_Value where Buss_Value_id in(" + zs.m_table.Rows[i]["Buss_Value_id"] + ")");
string Rtext = "";
for (int k = 0; k < Tsql.m_table.Rows.Count; k++)
{
Rtext += Tsql.m_table.Rows[k]["Buss_Value"].ToString() + ",";
}
Rtext = Rtext.Remove(Rtext.Length - 1, 1);
e.Row.Cells[13 + i].Text = Rtext;
}
break;
}
}
}
}

}

问题：

改变搜索条件后，无法完全清除新增列。

操作列变空[/code]