thedataset.aspx

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

ASPX
52
字号
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="gb2312" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
<MM:DataSet 
id="dsCustomer"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_connSales") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_connSales") %>'
CommandText='<%# "SELECT *  FROM Customers  WHERE CustomerID < ? AND City =?" %>'
Debug="true"
><Parameters>
  <Parameter  Name="@CustomerID"  Value='<%# 1020 %>'  Type="Integer"   />  
  <Parameter  Name="@City"  Value='<%# 北京市 %>'  Type="WChar"   />  
</Parameters></MM:DataSet>
<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>
</head>
<body>
<form runat="server">
<div align="center">
  <table width="259" border="0">
    <tr>
      <td width="60">&nbsp;</td>
      <td width="124">&nbsp;</td>
    </tr>
    <tr>
      <td>客户编号</td>
      <td>
        <asp:TextBox ID="txtCustomerID" runat="server" text='<%# dsCustomer.FieldValue("CustomerID", Container) %>' />      
    </td>
    </tr>
    <tr>
      <td>客户名称</td>
      <td><asp:TextBox ID="txtCustomerName" runat="server" text='<%# dsCustomer.FieldValue("CustomerName", Container) %>' />      </td>
    </tr>
    <tr>
      <td>联系电话</td>
      <td><asp:TextBox ID="txtTel" runat="server" text='<%# dsCustomer.FieldValue("Phone", Container) %>' />      </td>
    </tr>
    <tr>
      <td>电子邮件</td>
      <td><asp:TextBox ID="txteMail" runat="server" text='<%# dsCustomer.FieldValue("eMail", Container) %>' />      </td>
    </tr>
  </table>
</form>
</body>
</html>

⌨️ 快捷键说明

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