1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12public partial class ExcuteReader : System.Web.UI.Page
13...{
14    protected void Page_Load(object sender, EventArgs e)
15    ...{
16
17    }
18    protected void Button1_Click(object sender, EventArgs e)
19    ...{
20        //获取要执行的命令
21        string sql = txtsql.Text;
22        SqlCommand cmd = new SqlCommand();
23        //定义对象资源保存的范围，一旦using范围结束，将释放对方所占的资源
24
25            //调用执行方法，因为没有参数，所以最后一项直接设置为null
26            //注意返回结果是SqlDataReader类型
27            SqlDataReader mydr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, 
28                CommandType.Text, sql, null);
29            //将结果赋予DataList，作为其数据源
30            DataList1.DataSource = mydr;
31            //绑定数据
32            DataList1.DataBind();
33    }
34}
35