62,074
社区成员
发帖
与我相关
我的任务
分享
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
查询基站表
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/Database1.mdb"
SelectCommand="SELECT [安装地点], [电表编号], [基站号], [基站名], [基站产权归属], [共享情况], [基站在用或不在用] FROM [基站表]"
UpdateCommand="UPDATE [基站表] SET [安装地点]=@安装地点, 电表编号=@电表编号,
,基站名=@基站名, 基站产权归属=@基站产权归属,共享情况=@共享情况,基站在用或不在用=@基站在用或不在用 WHERE (基站号=@基站号) " DeleteCommand="DELETE FROM [基站表] WHERE 基站号=@基站号">
<UpdateParameters>
<asp:Parameter Name="安装地点" />
<!--这些地方都需要绑定值,要想不报错,给个默认值也可以-->
<asp:Parameter Name="电表编号" />
<asp:Parameter Name="基站名" />
<asp:Parameter Name="基站产权归属" />
<asp:Parameter Name="共享情况" />
<asp:Parameter Name="基站在用或不在用" />
<asp:Parameter Name="基站号" />
</UpdateParameters>
<DeleteParameters>
<asp:Parameter Name="基站号" DefaultValue="默认值" />
</DeleteParameters>
</asp:AccessDataSource>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None"
BorderWidth="1px" CellPadding="3" DataSourceID="AccessDataSource1" GridLines="Horizontal"
PageSize="20">
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
<asp:BoundField DataField="安装地点" HeaderText="安装地点" SortExpression="安装地点" />
<asp:BoundField DataField="电表编号" HeaderText="电表编号" SortExpression="电表编号" />
<asp:BoundField DataField="基站号" HeaderText="基站号" SortExpression="基站号" ReadOnly="True" />
<asp:BoundField DataField="基站名" HeaderText="基站名" SortExpression="基站名" />
<asp:BoundField DataField="基站产权归属" HeaderText="基站产权归属" SortExpression="基站产权归属" />
<asp:BoundField DataField="共享情况" HeaderText="共享情况" SortExpression="共享情况" />
<asp:BoundField DataField="基站在用或不在用" HeaderText="基站在用或不在用" SortExpression="基站在用或不在用" />
</Columns>
<RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
<PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
<AlternatingRowStyle BackColor="#F7F7F7" />
</asp:GridView>
<br />
<br />
<br />
</div>
</form>
</body>
</html>