偶是一个asp.net2的初学者,我想往access数据库里面插入数据一个日期的字段类型的数据,操作是,添加一个textbox控件绑定了数据库里面的“成交时间”的字段,可是运行的点击插入的时候,插入的数据是空白的。我用的工具是VWD2005,以下是代码,高手帮忙看看了
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="addorder.aspx.vb" Inherits="addorder" %><!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 style="font-size: 12pt">
<form id="form1" runat="server">
<div style="text-align: center">
<strong><span style="font-size: 12pt"><span style="font-size: 14pt">订单管理系统<br />
</span>
<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" CellPadding="4"
DataKeyNames="编号" DataSourceID="AccessDataSource1" DefaultMode="Insert" Height="50px"
Width="400px" AutoGenerateInsertButton="True">
<Fields>
<asp:TemplateField HeaderText="成交时间">
<InsertItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%#Bind("成交时间") %>'></asp:TextBox>
</InsertItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="300px" />
</asp:TemplateField>
</Fields>
</asp:DetailsView>
<br />
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/ddcl.mdb"
DeleteCommand="DELETE FROM [shoporder] WHERE [编号] = ?" InsertCommand="INSERT INTO [shoporder] ([成交时间]) VALUES (?)"
SelectCommand="SELECT * FROM [shoporder]" UpdateCommand="UPDATE [shoporder] SET [成交时间] = ? WHERE [编号] = ?">
<DeleteParameters>
<asp:Parameter Name="编号" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="成交时间" Type="DateTime" />
<asp:Parameter Name="编号" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="编号" Type="Int32" />
<asp:Parameter Name="成交时间" Type="DateTime" />
</InsertParameters>
</asp:AccessDataSource>
</span></strong></div>
</form>
</body>
</html>
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="addorder.aspx.vb" Inherits="addorder" %><!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 style="font-size: 12pt">
<form id="form1" runat="server">
<div style="text-align: center">
<strong><span style="font-size: 12pt"><span style="font-size: 14pt">订单管理系统<br />
</span>
<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" CellPadding="4"
DataKeyNames="编号" DataSourceID="AccessDataSource1" DefaultMode="Insert" Height="50px"
Width="400px" AutoGenerateInsertButton="True">
<Fields>
<asp:TemplateField HeaderText="成交时间">
<InsertItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%#Bind("成交时间") %>'></asp:TextBox>
</InsertItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="300px" />
</asp:TemplateField>
</Fields>
</asp:DetailsView>
<br />
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/ddcl.mdb"
DeleteCommand="DELETE FROM [shoporder] WHERE [编号] = ?" InsertCommand="INSERT INTO [shoporder] ([成交时间]) VALUES (?)"
SelectCommand="SELECT * FROM [shoporder]" UpdateCommand="UPDATE [shoporder] SET [成交时间] = ? WHERE [编号] = ?">
<DeleteParameters>
<asp:Parameter Name="编号" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="成交时间" Type="DateTime" />
<asp:Parameter Name="编号" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="编号" Type="Int32" />
<asp:Parameter Name="成交时间" Type="DateTime" />
</InsertParameters>
</asp:AccessDataSource>
</span></strong></div>
</form>
</body>
</html>
是你的程序最终发送给数据库执行的SQL语句!!你给我这个,那还要调试干吗?
直接看看你贴得代码不就知道了
<asp:Parameter Name="编号" Type="Int32" />
<asp:Parameter Name="成交时间" Type="DateTime" />
</InsertParameters>添加的时候你自己写的明明就一个参数 怎么多了一个