国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 編程 > ASP > 正文

Asp+語法介紹(六)----數據庫篇

2019-11-18 22:25:42
字體：大 中 小
來源：轉載
供稿：網友

  asp+ 給我們提供了一套數據表格和數據列表的控件。這些控件可以幫助我們定制我們UI(user interFace 用戶界面)而不去考
慮一種數據庫或者其他的數據庫。例如：在下面的例子中，我們將要介紹一下<asp:datagrid runat=server>控件是怎么樣通過
sql 語句給我們提供數據的
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQL" %>

<html>
   <head>
      <link rel="stylesheet"href="intro.CSS">
   </head>

   <script language="VB" runat=server>

       Sub SubmitBtn_Click(Sender As Object, E As EventArgs)

          Dim DS As DataSet
          Dim MyConnection As SQLConnection
          Dim MyCommand As SQLDataSetCommand
          '以下是數據庫聯結
          MyConnection = New SQLConnection("server=localhost;uid=sa;pwd=;database=pubs")
          MyCommand = New SQLDataSetCommand("select * from Titles where type='" +
Category.SelectedItem.Value + "'", myConnection)

          DS = new DataSet()
          MyCommand.FillDataSet(DS, "Titles")

          MyList.DataSource = DS.Tables("Titles").DefaultView
          MyList.DataBind()

       End Sub


   </script>

   <body>

       <center>

       <form action="intro75.aspx" method="post" runat="server">

           <asp:adrotator AdvertisementFile="ads.xml" BorderColor="black" BorderWidth=1 runat="server"/>

           <h3> Name: <asp:textbox id="Name" runat="server"/>

           Category:  <asp:dropdownlist id="Category" runat=server>
                         <asp:listitem >psychology</asp:listitem>
                         <asp:listitem >business</asp:listitem>
                         <asp:listitem >popular_comp</asp:listitem>
                      </asp:dropdownlist>

           <asp:button type=submit text="Lookup" OnClick="SubmitBtn_Click" runat="server"/>

           <p>

           <ASP:DataGrid id="MyList" HeaderStyle-BackColor="#aaaadd" BackColor="#ccccff" runat="server"/>

       </form>

       </center>

   </body>

</html>
這個例子的運行示例在
http://tutorial.superexpert.com/quickstart/aspplus/samples/webforms/intro/intro75.aspx

數據表格(data grid)控件 <asp:datagrid runat=server>
給我們提供了一種非常簡單的方法用傳統的UI截面去顯示數據查詢的結果.Asp+ 的開發者現在還可以通過<asp:dataList
runat=server>
來定制數據列表顯示來定制信息

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQL" %>

<html>
   <head>
      <link rel="stylesheet"href="intro.css">
   </head>

   <script language="VB" runat=server>

       Sub SubmitBtn_Click(Sender As Object, E As EventArgs)

          Dim DS As DataSet
          Dim MyConnection As SQLConnection
          Dim MyCommand As SQLDataSetCommand

          MyConnection = New SQLConnection("server=localhost;uid=sa;pwd=;database=pubs")
          MyCommand = New SQLDataSetCommand("select * from Titles where type='" +
Category.SelectedItem.Value + "'", myConnection)

          DS = new DataSet()
          MyCommand.FillDataSet(DS, "Titles")

          MyList.DataSource = DS.Tables("Titles").DefaultView
          MyList.DataBind()

       End Sub

   </script>

   <body>

       <center>

       <form action="intro8.aspx" method="post" runat="server">

           <asp:adrotator AdvertisementFile="ads.xml" BorderColor="black" BorderWidth=1 runat="server"/>

           <h3> Name: <asp:textbox id="Name" runat="server"/>

           Category:  <asp:dropdownlist id="Category" runat=server>
                         <asp:listitem >psychology</asp:listitem>
                         <asp:listitem >business</asp:listitem>
                         <asp:listitem >popular_comp</asp:listitem>
                      </asp:dropdownlist>

           <asp:button type=submit text="Lookup" OnClick="SubmitBtn_Click" runat="server"/>

           <p>

           <asp:datalist id="MyList" repeatcolumns="2" borderwidth="0" runat="server">

             <template name="itemtemplate">

                 <table>
                   <tr>

                     <td>
                         <img src='<%# DataBinder.Eval
(Container.DataItem, "title_id", "/quickstart/aspplus/images/title-{0}.gif") %>'>
                     </td>

                     <td width=250 valign=top>

                         <b><%# DataBinder.Eval(Container.DataItem, "title") %></b>

                         <br><br>

                         PRice: <%# DataBinder.Eval(Container.DataItem, "price", "${0}") %>
                     </td>

                   </tr>
                 </table>

             </template>

           </asp:datalist>

       </form>

       </center>

   </body>

</html>


這個程序的運行例子在
http://tutorial.superexpert.com/quickstart/aspplus/samples/webforms/intro/intro8.aspx

發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表

圖片精選

主站蜘蛛池模板： 武邑县| 湛江市| 清苑县| 松滋市| 长兴县| 长武县| 麻城市| 彰化县| 呼玛县| 马关县| 贵德县| 宜君县| 沅江市| 峡江县| 健康| 米林县| 洛隆县| 察雅县| 长治市| 高台县| 哈尔滨市| 巫山县| 江山市| 纳雍县| 定边县| 奉节县| 昌黎县| 左云县| 吉隆县| 清新县| 玛多县| 双柏县| 寿宁县| 任丘市| 伊吾县| 武清区| 罗城| 香河县| 澎湖县| 容城县| 康马县|