/// <summary> /// Executes sql string and returns scalar value. /// </summary> /// <param name="sql">Sql string.</param> /// <returns></returns> public object ExecuteScalar(string sql) { return(SWExecutor.ExecuteCommand(DB.Command, typeof(object), m_autoCloseConnection)); }
/// <summary> /// Executes sql string and returns no result. /// </summary> /// <param name="sql">Sql string.</param> public void ExecuteNonQuery(string sql) { SWExecutor.ExecuteCommand(DB.Command, typeof(void), m_autoCloseConnection); }
/// <summary> /// Executes sql string and returns DataTable object. /// </summary> /// <param name="sql">Sql string.</param> /// <returns></returns> public DataTable ExecuteDataTable(string sql) { return((DataTable)SWExecutor.ExecuteCommand(DB.Command, typeof(DataTable), m_autoCloseConnection)); }