110,537
社区成员
发帖
与我相关
我的任务
分享
<head runat="server">
<title>Untitled Page </title>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="AccessDataSource1">
<Columns>
<asp:BoundField DataField="EmployeeID" HeaderText="EmployeeID"
SortExpression="EmployeeID" />
<asp:BoundField DataField="EmployeeName" HeaderText="EmployeeName"
SortExpression="EmployeeName" />
<asp:BoundField DataField="EmployeePosition" HeaderText="EmployeePosition"
SortExpression="EmployeePosition" />
<asp:BoundField DataField="EmployeeRole" HeaderText="EmployeeRole"
SortExpression="EmployeeRole" />
</Columns>
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/App_Data/Employee.mdb" SelectCommand="SELECT * FROM [UserInfo]">
</asp:AccessDataSource>
</form>
</body>
</html>
<form id="form1" 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>