Question

请教C#高手，我做了一个aspx的动态页面，添加了一个FormView控件用来更新数据，但是我点击更新就报错？？

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:login_tableConnectionString %>"
DeleteCommand="DELETE FROM [ruzhi] WHERE [id] = @id"
InsertCommand="INSERT INTO [ruzhi] ([city], [ruzhishijian], [xingming], [pinyin], [sex], [bumen], [shangjiyouxiang], [zhiwei], [useid], [yeji], [xingzhi], [mail], [pwd], [current-time]) VALUES (@city, @ruzhishijian, @xingming, @pinyin, @sex, @bumen, @shangjiyouxiang, @zhiwei, @useid, @yeji, @xingzhi, @mail, @pwd, @[current-time])"
SelectCommand="SELECT * FROM [ruzhi] WHERE ([id] = @id)"
UpdateCommand="UPDATE [ruzhi] SET [city] = @city, [ruzhishijian] = @ruzhishijian, [xingming] = @xingming, [pinyin] = @pinyin, [sex] = @sex, [bumen] = @bumen, [shangjiyouxiang] = @shangjiyouxiang, [zhiwei] = @zhiwei, [useid] = @useid, [yeji] = @yeji, [xingzhi] = @xingzhi, [mail] = @mail, [pwd] = @pwd, [current-time] = @[current-time] WHERE [id] = @id">
<SelectParameters>
<asp:QueryStringParameter Name="id" QueryStringField="id" Type="Int32" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>

Answer 1

因为在数据库中使用了不规范的字段current-time，所以这里就出问题了。
可以将current-time改为current_time。（注意是所有地方都改，包括数据库和网页）
[current-time] = @[current-time]，这个也要改为[current_time] = @current_time

追问

没用，我按照你的意思做了修改，但是运行还是出错，它提示"必须声明变量@id"

追答

你没有提供@id这个值。
可以添加:

Answer 2

[current-time] = @[current-time] 这个写错了吧，使用默认的函数要用@么

追问

我将@去掉了，但还是报错啊!

追答

你把那个时间换成getDate()可以不

Answer 3

看你的 sql 语句 错误 。

追问

错在哪儿？