如何在DataGrid绑定之前为DataSet添加新列
日期：2012-05-29 浏览次数：20593 次
在实际的应用中经常会遇到根据其它列计算某一新列的结果，实现这样的功能有两种办法：一个直接使用SQL语句；另外就是在绑定时进行动态添加。第一种方法以前已经介绍过。下面就是第二种方法的具体实现：
AddDataSetColumn.aspx
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="AddDataSetColumn.<a href="http://www.chinaitpower.com/Dev/Web/Asp/index.html" target="_blank">asp</a>x.vb"
Inherits="<a href="http://www.chinaitpower.com/Dev/Web/Asp/index.html" target="_blank">asp</a>xWeb.AddDataSetColumn"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>AddDataSetColumn</title>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" content="Visual Basic .NET 7.1">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<<a href="http://www.chinaitpower.com/Dev/Web/Asp/index.html" target="_blank">asp</a>:DataGrid id="DataGrid1" runat="server" AutoGenerateColumns="False"
ShowFooter="True" Width="100%">
<HeaderStyle Font-Names="宋体" Font-Bold="True" HorizontalAlign="Center"
ForeColor="Navy" BackColor="LightSalmon"></HeaderStyle>
<FooterStyle BackColor="#FFCCFF"></FooterStyle>
<Columns>
<<a href="http://www.chinaitpower.com/Dev/Web/Asp/index.html" target="_blank">asp</a>:TemplateColumn HeaderText="订单号">
<ItemTemplate>
<<a href="http://www.chinaitpower.com/Dev/Web/Asp/index.html" target="_blank">asp</a>:Label ID="OrderID" Runat="server"></<a href="http://www.chinaitpower.com/Dev/Web/Asp/index.html" target="_blank">asp</a>:Label>
</ItemTemplate>
</<a href="http://www.chinaitpower.com/Dev/Web/Asp/index.html" target="_blank">asp</a>:TemplateColumn>
<<a href="http://www.chinaitpower.com/Dev/Web/Asp/index.html" target="_blank">asp</a>:TemplateColumn HeaderText="产品号">
<ItemTemplate>
<<a href="http://www.chinaitpower.com/Dev/Web/Asp/index.html" target="_blank">asp</a>:Label ID="ProductID" Runat="server"></<a href="http://www.chinaitpower.com/Dev/Web/Asp/index.html" target="_blank">asp</a>:Label>
</ItemTemplate>
</<a href="http://www.chinaitpower.com/Dev/Web/Asp/index.html" target="_blank">asp</a>:TemplateColumn>
<<a href="http://www.chinaitpower.com/Dev/Web/Asp/index.html" target="_blank">asp</a>:TemplateColumn HeaderText="单价">
&
