ASP.NET

namespace TAMIS.Business.Common
{
    public class MyParam
    {
        public SqlParameter SqlParam { get; set; }

        public string Name { get; set; }

        public object Value { get; set; }

        public int Type { get; set; }
    }
    /// <summary>
    /// Summary description for QueryContainer SGH
    /// </summary>
    public class QueryContainer
    {

        string _query;

        public List<myparam> parameterList = new List<myparam>();

        public QueryContainer(string query) { _query = query; }

        public SqlDbType AddParameterType(int type)
        {
            switch (type)
            {
                case 1:
                    return  (SqlDbType) Enum.Parse( typeof(SqlDbType) , "int" , true );
                case 2:
                    return (SqlDbType)Enum.Parse(typeof(SqlDbType), "NVarChar", true);
            }

            return SqlDbType.VarChar;
                
        }

        public string Query
        {
            get
            {
                return _query;
            }

            set { _query = value;  }
        }
    }

public int GetAccountSortByAccountCode(int account)
        {
            QueryContainer Instance = new QueryContainer("SELECT ac_sort_order FROM lkup_account_codes where ac_code = <a href="http://www.codeproject.com/Members/account">@account</a>");

            MyParam myParam = new MyParam();

            myParam.SqlParam = new SqlParameter("@account", Instance.AddParameterType(1));

            myParam.SqlParam.Value = account;
            
            Instance.parameterList.Add(myParam);
            
            return Convert.ToInt32(ExecuteScaler(Instance, 1));

protected Object ExecuteScaler(QueryContainer Instance, int i)
        {

            object returnValue = null;


            if (!_iserror)
            {
                if (_trace)
                {
                   // DoTrace("TAMIS.Data.Loader.ExecuteScalar", Instance.Query);
                }

                if (_connection == null || _connection.State == ConnectionState.Closed)
                {
                    OpenConnection();
                }

                DbCommand command = _provider.CreateCommand();

                command.Connection = _connection;
                {
                    command.CommandText = Instance.Query;
                    command.CommandType = CommandType.Text;

                    foreach (var p in Instance.parameterList)
                    {
                        command.Parameters.Add(p.SqlParam);
                    }

                    if (_useTransaction) { command.Transaction = _transaction; }

                    try
                    {
                        returnValue = command.ExecuteScalar();
                    }
                    catch (Exception ex)
                    {
                        if (ex is EntryPointNotFoundException)
                            throw ex;
                        //if (_useTransaction == true)
                        //_transaction.Rollback();
                        RollBack();

                        LogBLL bll = new LogBLL();
                        bll.WriteErrorLog(ex);

                        _iserror = true;
                    }
                    finally
                    {

                        if ((!KeepAlive && _connection.State == ConnectionState.Open) || _iserror == true)
                        {
                            CloseConnection();
                        }

                    }
                }
            }
            else
            {
                returnValue = -1;
            }

            return returnValue;
        }

<pre>

Sys.WebForms.PageRequestManager.getInstance().add_endRequest(EndRequestHandler);
            function EndRequestHandler(sender, args) {
                var elId = sender._activeElement.id;

                if (elId.indexOf("btnAddTypeQuest") > -1 || elId.indexOf("btnEditQuest") > -1) {
                    $('#dialogQuests').dialog({
                        maxHeight: 600,
                        minWidth: 840,
                        open: function (type, data) {
                            $(this).parent().appendTo("form");
                        }
                    });
                }

                if (args.get_error() != undefined) {
                    args.set_errorHandled(true);
                }
            }