コード例 #1
0
        protected void run_Click(object sender, EventArgs e)
        {
            var MSHELP = new MSSqlHelper();
            var OHELP  = new OracleHelper();
            //判断下执行oracle语句还是sqlserver语句
            var sql = this.sqli.Value;

            //执行语句到数据库
            if (IsDB == 11)
            {
                OHELP.Run_sql(sql, ORACLEDB2);
                Response.Write("<script Language=JavaScript>alert('sql语句已经在oracle镜像库中执行!')</script>");
            }
            if (IsDB == 12)
            {
                MSHELP.Run_sql(sql, MSSQLDB);
                Response.Write("<script Language=JavaScript>alert('sql语句已经在sqlserver目标库中执行!')</script>");
            }
            if (IsDB == 0)
            {
                Response.Write("<script Language=JavaScript>alert('未能成功执行sql语句!')</script>");
            }
        }