GridView的使用，高手来帮看下怎么回事？
我是新手，自带的GridView的功能，后台没有任何代码，可是在调试的时候，按删除时，提示"至少一个参数没有被指定值"；按更新，提示"UPDATE 语句的语法错误"．
数据库表名和字段名都是中文，安装地点，电表编号，基站号，基站名，基站产权归属，共享情况，基站在用或不在用
%@ Page Language="C#" AutoEventWireup="true" CodeFile="SelectBTSInfo.aspx.cs" Inherits="SelectBTSInfo" %>
<!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 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="基站号"/>
</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>
[解决办法]
获取值的代码呢？还是没有取值？
[解决办法]
- HTML code
<!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>
[解决办法]
就是这个网址 你自己过来看吧 ： http://www.cnblogs.com/jay-c/articles/972377.html