MESProductionWeb/AntORM/Ant.Data/Class1.cs

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;

namespace ETD.Data
{
    class Class1
    {
        public bool ValidateSQL(string sql)
        {

            bool bResult;



            SqlCommand cmd = _conn.CreateCommand();

            cmd.CommandText = "SET PARSEONLY ON";

            cmd.ExecuteNonQuery();

            try
            {

                cmd.CommandText = sql;

                cmd.ExecuteNonQuery();

                bResult = true;

            }

            catch (Exception ex)
            {

                bResult = false;

            }

            finally
            {

                cmd.CommandText = "SET PARSEONLY OFF";

                cmd.ExecuteNonQuery();

            }



            return bResult;

        }

    }
}