2004/08/28-Web 窗体用户控件例子-具有事件的用户控件

最新推荐文章于 2024-06-21 19:02:30 发布

sharpcn

最新推荐文章于 2024-06-21 19:02:30 发布

阅读量960

点赞数

分类专栏： ASP.NET 文章标签： dataset asp server import object c#

本文链接：https://blog.csdn.net/sharpcn/article/details/87272

版权

ASP.NET 专栏收录该内容

36 篇文章 0 订阅

订阅专栏

今天天气不错,有点秋天的味儿了.我喜欢秋天.
但是头有点晕晕的.

学习了Web 窗体用户控件,可重用性很强.感觉有点向ASP中的Include.写了一个具有事件的控件.

页面代码如下:BookList.aspx

<%@ Page Language="C#" Debug="True" %>
<%@ Register TagPrefix="Acme" TagName="BookList" Src="BookList.ascx" %>
<html>
<head>
</head>
<body>
<center>
    <form runat="server">
        <p style="FONT-SIZE: large">
            具有事件的用户控件
        </p>
        <p>
            <Acme:BookList id="UserControl1" runat="server"></Acme:BookList>
        </p>
    </form>
</center>
</body>
</html>

逻辑代码如下:BookList.ascx

<%@ Control Language="C#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script language="c#" runat="server">

void Page_Load(Object Src, EventArgs e) {

if (!Page.IsPostBack) {

  SqlConnection myConnection = new SqlConnection("Data Source=localhost;UID=sa;PWD=123456;Initial Catalog=pubs");
  SqlDataAdapter myCommand = new SqlDataAdapter("select * from titles where type='" + Category.SelectedItem.Value + "'",myConnection);

  DataSet ds = new DataSet();
  myCommand.Fill(ds,"书名");

  MyDataList.DataSource = ds.Tables["书名"].DefaultView;
  MyDataList.DataBind();
       }
    }

void Category_Select(Object sender, EventArgs E) {

  SqlConnection myConnection = new SqlConnection("Data Source=localhost;UID=sa;PWD=123456;Initial Catalog=pubs");
  SqlDataAdapter myCommand = new SqlDataAdapter("select * from titles where type='" + Category.SelectedItem.Value + "'",myConnection);

  DataSet ds = new DataSet();
  myCommand.Fill(ds,"书名");

  MyDataList.DataSource = ds.Tables["书名"].DefaultView;
  MyDataList.DataBind();

}

</script>