/// <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));
}
