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;
12
13//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)
14
15public partial class ExcuteSQL : System.Web.UI.Page
16...{
17    protected void Page_Load(object sender, EventArgs e)
18    ...{
19
20    }
21    protected void Button1_Click(object sender, EventArgs e)
22    ...{
23        //获取要执行的命令
24        string sql = TextBox1.Text;
25        SqlCommand cmd = new SqlCommand();
26        //定义对象资源保存的范围，一旦using范围结束，将释放对方所占的资源
27        using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
28        ...{
29            //打开连接
30            conn.Open();
31            //调用执行方法，因为没有参数，所以最后一项直接设置为null
32            SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, null);
33            
34            Response.Write("<font color=red>操作完成！请检查数据库！</font>");
35        }
36    }
37}
38//5_1_a_s_p_x.c_o_m