回复:dreamweaver向access插入记录
我的插入原代码 是:
<MM:Insert
runat="server"
CommandText='<%# "INSERT INTO yuan (name, nicheng, password, qq, sex) VALUES (?, ?, ?, ?, ?)" %>'
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_hui") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_hui") %>'
Expression='<%# Request.Form("MM_insert") = "zhuce" %>'
CreateDataSet="false"
SuccessURL='<%# "chenggong.aspx" %>'
Debug="true"
><Parameters>
<Parameter Name="@name" Value='<%# IIf((Request.Form("name") <> Nothing), Request.Form("name"), "") %>' Type="WChar" />
<Parameter Name="@nicheng" Value='<%# IIf((Request.Form("nicheng") <> Nothing), Request.Form("nicheng"), "") %>' Type="WChar" />
<Parameter Name="@password" Value='<%# IIf((Request.Form("password") <> Nothing), Request.Form("password"), "") %>' Type="WChar" />
<Parameter Name="@qq" Value='<%# IIf((Request.Form("qq") <> Nothing), Request.Form("qq"), "") %>' Type="Integer" />
<Parameter Name="@sex" Value='<%# IIf((Request.Form("sex") <> Nothing), Request.Form("sex"), "") %>' Type="WChar" />
</Parameters>
</MM:Insert>