[ASP.NET2.0][学习笔记]AccessDataSource的UpdateCommand语句的写法

来源：互联网发布：汪伪国民政府知乎编辑：程序博客网时间：2024/05/17 23:40

VB版示例:

<%@Page  Language="VB" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><HTML>  <BODY>    <form runat="server">      <asp:accessdatasource        id="AccessDataSource1"        runat="server"        datasourcemode="DataSet"        datafile="~/App_Data/Northwind.mdb"        selectcommand="SELECT EmployeeID,FirstName,LastName,Title FROM Employees"        updatecommand="Update Employees SET FirstName=?,LastName=?,Title=? WHERE EmployeeID=@EmployeeID">      </asp:accessdatasource>      <asp:gridview        id="GridView1"        runat="server"        autogeneratecolumns="False"        datakeynames="EmployeeID"        autogenerateeditbutton="True"        datasourceid="AccessDataSource1">        <columns>          <asp:boundfield headertext="First Name" datafield="FirstName" />          <asp:boundfield headertext="Last Name" datafield="LastName" />          <asp:boundfield headertext="Title" datafield="Title" />        </columns>      </asp:gridview>    </form>  </BODY></HTML>-----------------------

以上例子来自微软MSDN：http://msdn2.microsoft.com/zh-CN/library/system.web.ui.webcontrols.accessdatasource.aspx