anewcustomerw.aspx

来自「用VB实现」· ASPX 代码 · 共 77 行

ASPX
77
字号
<%@ Page Language="VB" ContentType="text/html" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
<MM:Insert
runat="server"
CommandText='<%# "INSERT INTO Customers (CustomerID, CustomerName, eMail) VALUES (?, ?, ?)" %>'
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_connSales") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_connSales") %>'
Expression='<%# Request.Form("MM_insert") = "form1" %>'
CreateDataSet="false"
Debug="true"
>
  <Parameters>
    <Parameter Name="@CustomerID" Value='<%# IIf((Request.Form("txtCustomerID") <> Nothing), Request.Form("txtCustomerID"), "") %>' Type="Integer" />
    <Parameter Name="@CustomerName" Value='<%# IIf((Request.Form("txtCustomerName") <> Nothing), Request.Form("txtCustomerName"), "") %>' Type="WChar" />
    <Parameter Name="@eMail" Value='<%# IIf((Request.Form("txteMail") <> Nothing), Request.Form("txteMail"), "") %>' Type="WChar" />
  </Parameters>
</MM:Insert>
<MM:PageBind runat="server" PostBackBind="true" />
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>添加客户数据</title>
<style type="text/css">
<!--
.style1 {font-size: large}
.style2 {
	font-size: x-large;
	font-weight: bold;
}
-->
</style>
</head>
<body>
<form name='form1' method='POST' runat='server'>
  <p align="center">&nbsp;</p>
  <div align="center">
    <table width="373" border="0">
      <tr>
        <td colspan="2"><div align="center" class="style2">添加客户数据
          <hr>
        </div></td>
      </tr>
      <tr>
        <td width="81"><span class="style1">客户编号</span></td>
        <td width="276"><span class="style1">
          <asp:TextBox ID="txtCustomerID" runat="server" />          
</span></td>
      </tr>
      <tr>
        <td><span class="style1">客户名称</span></td>
        <td><span class="style1">
          <asp:TextBox ID="txtCustomerName" runat="server" />          
</span></td>
      </tr>
      <tr>
        <td><span class="style1">电子邮件</span></td>
        <td><span class="style1">
          <asp:TextBox ID="txteMail" runat="server" />          
</span></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td><asp:Button ID="btnSend" Text="添加" runat="server" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      </table>
  </div>
  <p align="center">&nbsp; </p>
  <input type="hidden" name="MM_insert" value="form1">
</form>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?