SagaDB.MSSQLOperator.ExeSqlScalar C# (CSharp) Method

        public string ExeSqlScalar(string sql)
        {
            DataTable dt = null;
            try
            {
                dt = this.GetDataTable( sql);
                if (dt.Rows.Count > 0)
                {
                    string v_Value = dt.Rows[0][0].ToString();
                    dt.Dispose();
                    return v_Value;
                }
                else
                {
                    return "";
                }
            }
            catch (Exception ex)
            {
                Logger.ShowSQL("Error on query:" + sql, null);
                Logger.ShowSQL(ex, null);
                return "";
            }
        }