dreamweaver 连接数据库后,预览提示insert into语句语法问题!代码如下:
<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="gb2312" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
<MM:Insert
runat="server"
CommandText='<%# "INSERT INTO tbMember (Confirmpassword, Email, Password, Username) VALUES (?, ?, ?, ?)" %>'
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_STRING_Forumregister"] %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_DATABASETYPE_Forumregister"] %>'
Expression='<%# Request.Form["MM_insert"] == "form1" %>'
CreateDataSet="false"
SuccessURL='<%# "welcome.aspx" %>'
FailureURL='<%# "error.aspx" %>'
Debug="true"
>
  <Parameters>
    <Parameter Name="@Confirmpassword" Value='<%# ((Request.Form["Confirmpassword"] != null) && (Request.Form["Confirmpassword"].Length > 0)) ? Request.Form["Confirmpassword"] : "" %>' Type="WChar" />
    <Parameter Name="@Email" Value='<%# ((Request.Form["Email"] != null) && (Request.Form["Email"].Length > 0)) ? Request.Form["Email"] : "" %>' Type="WChar" />
    <Parameter Name="@Password" Value='<%# ((Request.Form["Password"] != null) && (Request.Form["Password"].Length > 0)) ? Request.Form["Password"] : "" %>' Type="WChar" />
    <Parameter Name="@Username" Value='<%# ((Request.Form["Username"] != null) && (Request.Form["Username"].Length > 0)) ? Request.Form["Username"] : "" %>' Type="WChar" />
  </Parameters>
</MM:Insert>
<MM:PageBind runat="server" PostBackBind="true" /><!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>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>IsMyLife注册</title>
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
color: #CCCC00;
}
body {
background-color: #282830;
}
a {
font-size: 12px;
color: #CCCC00;
}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
color: #CCFF00;
}
a:hover {
text-decoration: underline;
}
a:active {
text-decoration: none;
}
.STYLE1 {font-size: 13px}
-->
</style>
</head>
<body>
<table width="300" border="0" align="center" cellpadding="0" cellspacing="0">
  <!--DWLayoutTable-->
  <tr>
    <td width="300" height="100">&nbsp;</td>
  </tr>
  <tr>
    <td height="250" valign="top"><table width="600" border="0" cellspacing="0" cellpadding="0">
      <!--DWLayoutTable-->
      <tr>
        <td height="20" colspan="3"><img src="../image file/forum_register_frame_5.png" width="600" height="20" /></td>
        </tr>
      <tr>
        <td width="20" height="210"><img src="../image file/forum_register_frame_3.png" width="20" height="210" /></td>
        <td width="560" valign="top"><table width="260" border="0" cellspacing="0" cellpadding="0">
          <!--DWLayoutTable-->
          <tr>
            <td width="260" height="28">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
              &nbsp;&nbsp;<span class="STYLE1">注册用户</span>
              <div align="center" class="STYLE1"></div></td>
          </tr>
          <tr>
            <td height="170" valign="top"><form runat='server' method='POST' name='form1' id="form1">
              <table width="559" height="162" border="0" cellpadding="0" cellspacing="1" background="../image file/background_5.png" bgcolor="#282830">
                <tr>
                  <td width="84" bgcolor="#282830">&nbsp;&nbsp;&nbsp;&nbsp;Username:</td>
                  <td width="472" bgcolor="#282830"><input name="Username" type="text" id="Username" size="19" maxlength="20" runat="server" />
                    &nbsp;
                    <asp:RequiredFieldValidator ControlToValidate="Username" EnableClientScript="true" ErrorMessage="对不起!您的用户名不能为空!" runat="server" /></td>
                </tr>
                <tr>
                  <td bgcolor="#282830">&nbsp;&nbsp;&nbsp;&nbsp;Password:</td>
                  <td bgcolor="#282830"><input name="Password" type="password" id="Password" size="20" maxlength="20" runat="server" /></td>
                </tr>
                <tr>
                  <td bgcolor="#282830">&nbsp;&nbsp;&nbsp;&nbsp;密码确认:</td>
                  <td bgcolor="#282830"><input name="Confirmpassword" type="password" id="Confirmpassword" size="20" maxlength="20" runat="server" />
                    &nbsp;<asp:CompareValidator ControlToCompare="Password" ControlToValidate="Confirmpassword" EnableClientScript="true" ErrorMessage="对不起!您输入的确认密码与密码不相同!" Operator="Equal" runat="server" /></td>
                </tr>
                <tr>
                  <td bgcolor="#282830">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Email:</td>
                  <td bgcolor="#282830" runat="server"><input name="Email" type="text" id="Email" size="19" maxlength="20" runat="server" />
                    &nbsp;
                    <asp:RegularExpressionValidator ControlToValidate="Email" Display="Static" EnableClientScript="true" ErrorMessage="对不起!您输入的Email格式不正确!" runat="server" ValidationExpression="\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*" /></td>
                </tr>
                <tr>
                  <td colspan="2" bgcolor="#282830">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                    <input name="Submit" type="submit" value="提交" runat="server" />                    
                    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
                  </tr>
              </table>
            <input type="hidden" name="MM_insert" value="form1">
            </form>
            </td>
          </tr>
        </table>
          </td>
        <td width="20"><img src="../image file/forum_register_frame_4.png" width="20" height="210" /></td>
      </tr>
      <tr>
        <td height="20" colspan="3"><img src="../image file/forum_register_frame_6.png" width="600" height="20" /></td>
        </tr>
    </table></td>
  </tr>
</table>
</body>
</html>